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]
--
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]
