Re: Transaction Not supported

[Mike Blezien]

Thx's for all the responses... are coding was correct, and the database was set 
up correct. The problem was the Perl DBI and DBD::mysql modules where way 
out-dated and didn't support the 'rollback' and 'commit' yet... problem solved 
after updating the modules.

appologizes as this was not related to this mailing list.
--
Mike<mickalo>Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Quality Web Hosting
http://www.justlightening.net
MSN: [EMAIL PROTECTED]
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=


Joshua J. Kugler wrote:
Hmm...but it *should* work.  DBI::mysql should implement those calls and 
transform them to BEGIN/COMMIT calls.  I wonder why it doesn't.

j----- k-----

On Tuesday 30 March 2004 11:24 pm, Jonas Lindén said something like:

Sorry Mike, Joshua is absolutly correct. Dont listen to my nonses ;)

What I did was trying to use something like this which  to my knowledge
doesnt work on MySQL servers.
$dbh->commit();
$dbh->rollback();
/Jonas


----- Original Message -----
From: "Joshua J. Kugler" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 31, 2004 9:02 AM
Subject: Re: Transaction Not supported
On Tuesday 30 March 2004 09:35 pm, Jonas Lindén said something like:

I dont think that transactions are supported (yet?) by the PERL DBI.
to  "Mike Blezien" <[EMAIL PROTECTED]>.  My response follows.

Yes they are...at least I have used them in a project before using
Perl::DBI.
[EMAIL PROTECTED] ~]$ perl
use DBI;
print $DBI::VERSION, "\n";
1.37
[EMAIL PROTECTED] ~]$

My mysql.pm shows $VERSION = '2.0419'

Are you sure you are connecting to an InnoDB database and that you are
doing


transactions on InnoDB tables?

My code is rather simple:

#Begins the transaction
$dbh->do('BEGIN');
.
.
.
.
$dbh->do('COMMIT');
What does your code look like?

j----- k-----

--
Joshua J. Kugler
Fairbanks, Alaska
Computer Consultant--Systems Designer
.--- --- ... .... ..- .-    -.- ..- --. .-.. . .-.
[EMAIL PROTECTED]
ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and
under
the earth, that Jesus Christ is LORD -- Count on it!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]






--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]