[ http://jira.jboss.com/jira/browse/JBJCA-16?page=comments#action_12314910 ] youngm commented on JBJCA-16: -----------------------------
Actually, after thinking about this is a bigger problem then I thought. Moving checkState() above setAutoCommit() won't help if the underlying connection's autoCommit==true. That would mean the solution on your side would be to: setAutoCommit(true); change readonly status; setAutoCommit(false); which looks more like a special C-JDBC hack. What do you think? In the mean time I'm going to lobby C-JDBC for a better transaction detection system. Mike > Changing readonly after autocommitt set to false fails with C-JDBC Driver > ------------------------------------------------------------------------- > > Key: JBJCA-16 > URL: http://jira.jboss.com/jira/browse/JBJCA-16 > Project: JBoss JCA > Type: Bug > Versions: JBossAS-4.0.1 > Reporter: youngm > Assignee: Adrian Brock > > > In the C-JDBC JDBC Connection driver it uses autoCommit=false to determine if > it is in a transaction when changing readOnly. > Unfortunatly LocalManagedConnection sets autoCommit=false prior to > "checkState()" which synchronizes the readOnly property with the underlying > connection. This approach works fine with most JDBC drivers with but not > with C-JDBC. Looking at the JDBC 3 spec (10.1) JDBC says: > "Typically, a new transaction is started when the current SQL statement > requires one and there is > no transaction already in place." > The key word being "Typically". So it appears that it may be within C-JDBC's > right to declare a transaction started once setAutoCommit=false. > So, would there be any problem with changing LocalManagedConnection.begin() > to call checkState() prior to setting autoCommit in the underlying connection? > Mike -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa - If you want more information on JIRA, or have a bug to report see: http://www.atlassian.com/software/jira ------------------------------------------------------- This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting Tool for open source databases. Create drag-&-drop reports. Save time by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc. Download a FREE copy at http://www.intelliview.com/go/osdn_nl _______________________________________________ JBoss-Development mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-development
