Re: Transaction Not supported
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]
Re: Transaction Not supported
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]
Re: Transaction Not supported
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.
--
MikemickaloBlezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
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]
Transaction Not supported
Hello, I keep getting this error when attempting to utilize a database that has Innodb tables, and using transactions. This is from a Perl/DBI script too: Error: Transactions not supported by database at module. bla..bla I realize this maybe a DBI question, but I thought I'd check here first incase we missed something is the settings for the MySQL server Version: 4.0.17-standard - Official MySQL-standard binary and it has innodb enabled, the autocommit is set to 1, then when the transaction is executed, the autocommit is set to 0 untill the commit is called Is there something in the variables I can check to make sure transaction have been enabled ?? TIA -- MikemickaloBlezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Quality Web Hosting http://www.justlightening.net MSN: [EMAIL PROTECTED] =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Transaction Not supported
I dont think that transactions are supported (yet?) by the PERL DBI. /Jonas - Original Message - From: Mike Blezien [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Tuesday, March 30, 2004 9:42 PM Subject: Transaction Not supported Hello, I keep getting this error when attempting to utilize a database that has Innodb tables, and using transactions. This is from a Perl/DBI script too: Error: Transactions not supported by database at module. bla..bla I realize this maybe a DBI question, but I thought I'd check here first incase we missed something is the settings for the MySQL server Version: 4.0.17-standard - Official MySQL-standard binary and it has innodb enabled, the autocommit is set to 1, then when the transaction is executed, the autocommit is set to 0 untill the commit is called Is there something in the variables I can check to make sure transaction have been enabled ?? TIA -- MikemickaloBlezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Quality Web Hosting http://www.justlightening.net MSN: [EMAIL PROTECTED] =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= -- 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]
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]
