[Opensource] Problem with setAutoCommit

[Eddie Lewis]

Hi all.
 
We use innodb tables in mysql which do support transactions. It isnt hard
and to convert the tables to support this and i can post the steps to
convert if required (there is a bit of typing involved so i will hold off
unless someone really wants the instructions we used).
 
Just a quick message.
 
We used to use myISAM tables that did not support transactions and we still
set the autocommit flag in the code (as we where moving to innodb in the
future). The only time we had problems with the system was when we tried to
rollback a transaction (which was understandable). mysql version 4.0.3.
expresso 4.02.

-----Original Message-----
From: "Ruiz González, Jose de Jesus" [mailto:jjruiz at mapfre.com]
Sent: Saturday, 15 February 2003 1:53 AM
To: opensource at jcorporate.com
Subject: RE: [Opensource] Problem with setAutoCommit


Must versions of mySQL dos not support COMMIT or ROLLBACK nor Transactions. 
All SQL statements are commited automatically.
Read the documentation of your mySQL distribution
 

Jose de Jesus Ruiz Gonzalez 
Depto. de Sistemas 
5480-3886 
jjruiz at mapfre.com 

-----Mensaje original-----
De: Ali Ghadiri [mailto:ali_gholi_ir at yahoo.com]
Enviado el: Jueves, 13 de Febrero de 2003 02:19 p.m.
Para: opensource at jcorporate.com
Asunto: [Opensource] Problem with setAutoCommit



Hi,

I used 'setAutoCommit' function in DBConnection class to have a transaction
control in my application in which I use Mysql as the DBMS. But I had
received an error such as:

"Nested exception
message:com.sprout.fuel.controller.ReportsCntrl.runProcessConsumedFuelState(
ControllerRequest,
ControllerResponse)com.jcorporate.expresso.core.db.DBConnection.setAutoCommi
t(boolean):Could not set auto commit (New Connection):Cannot disable
AUTO_COMMIT" 

I want to know if there is a problem with this function or it is Mysql
problem, so how can one manage transaction controls. Please recommend if
there are another ways to do so.

Thanks



Amir Ali Ghadiri
B-> 




  _____  

Do you Yahoo!?
Yahoo!
<http://rd.yahoo.com/O=1/I=brandr/vday03/text/flow/*http://shopping.yahoo.co
m/shop?d=browse&id=20146735> Shopping - Send Flowers for Valentine's Day

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.jcorporate.com/pipermail/opensource/attachments/20030217/23177449/attachment-0002.htm