[Opensource] Problem with setAutoCommit

[Ali Ghadiri]

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.setAutoCommit(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! Shopping - Send Flowers for Valentine's Day
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.jcorporate.com/pipermail/opensource/attachments/20030213/483dfea4/attachment-0002.htm