Re: autocommit=true problem with oc4j application server
Posted by: dd dd
Date: February 08, 2008 03:25PM

Hello,
I'm using Sun App Server 9.1 and MySQL 5.0, connectorJ 5.0.8.

I set the URL property (?relaxAutoCommit="true" (I also tried =true))
But anyway, when my code reaches
con.commit();
it throws an exception:
java.sql.SQLException: Can't call commit when autocommit=true

Is there something more I should do? Other settings in app server? Other settings in MySQL?

Thanks for helping me

ADD - Oh, sorry, I noticed, I'm using two connections and I set only one. I set the second also and it finally works :/ sorry



Edited 1 time(s). Last edit at 02/08/2008 03:54PM by dd dd.

Options: ReplyQuote


Subject
Written By
Posted
Re: autocommit=true problem with oc4j application server
February 08, 2008 03:25PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.