4 messages in com.mysql.lists.perlRe: Transactions in Mysql
FromSent OnAttachments
Eran Boudjnah11 Oct 2001 00:48 
Jeremy Zawodny11 Oct 2001 00:56 
Heikki Tuuri11 Oct 2001 09:49 
Eran Boudjnah14 Oct 2001 09:55 
Subject:Re: Transactions in Mysql
From:Eran Boudjnah (er@d-net.co.il)
Date:10/14/2001 09:55:16 AM
List:com.mysql.lists.perl

Thank you and thanks to Jochen Wiedmann for the help... We uninstalled mysql,
reinstalled the max version, and the DBI and DBD::mysql (as the package they come in) - and
now everything seems to be working...

Thanks again, -Eran Boudjnah

Heikki Tuuri wrote:

Hi!

Eran, you can also send the SQL string "COMMIT" or "ROLLBACK" directly to the server, like you send "INSERT..." or "SELECT..."

Regards,

Heikki http://www.innodb.com

On Thu, Oct 11, 2001 at 09:49:09AM +0200, Eran Boudjnah wrote:

Hi all,

This is the second time I'm posting this message. I got no reply the first time, and was hoping to have more luck this time... I've compiled MySQL with InnoDB support. I've run some tests with the MySQL client and have verified that both rollback and commit worked. I then installed DBI and DBD::mysql.

Which version of DBD::mysql?

I got the following error when trying to utilize them:

Transactions not supported by database at ./test.cgi line 10. Issuing rollback() for database handle being DESTROY'd without explicit disconnect().

I think that older versions of DBD::mysql didn't believe that MySQL could handle transactions.

Jeremy

-- Jeremy D. Zawodny, <jzaw@yahoo-inc.com> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878   Fax: (408) 349-5454   Cell: (408) 685-5936

MySQL 3.23.41-max: up 35 days, processed 773,006,610 queries (254/sec. avg)

---------------------------------------------------------------------------

-----

--------------------------------------------------------------------- Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before posting. To request this thread, e-mail
msql@lists.mysql.com

To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail msql@lists.mysql.com instead.