[ http://issues.apache.org/jira/browse/TORQUE-12?page=comments#action_12377241 ]
Thomas Fischer commented on TORQUE-12: -------------------------------------- I have verified the behaviour and suspect it is a bug in commons-dbcp-1.2.1.See http://issues.apache.org/bugzilla/show_bug.cgi?id=31811 This one is fixed in cvs repository. However, I found another problem, see http://issues.apache.org/bugzilla/show_bug.cgi?id=35591 I have submitted a patch to this against svn Revision 279315 of dbcp which should resolve the problem. On building dbcp with the patch, a dbcp testcase fails, but it also fails without the patch. I'd suggest to wait till dbcp releases a new snapshot (or even a release) and then iclude this snapshot. > serializable transactions using dbcp do not work in oracle > ---------------------------------------------------------- > > Key: TORQUE-12 > URL: http://issues.apache.org/jira/browse/TORQUE-12 > Project: Torque > Type: Bug > Components: Runtime > Versions: 3.1, 3.1.1, 3.2 > Environment: oracle > Reporter: Thomas Fischer > > Reported by raphael.x.mankin: > when connections are retrieved via SharedPoolDataSource and the transaction > mode is set to serializable, e.g. by > torque.dsfactory.bookstore.pool.defaultTransactionIsolation = 8, > oracle exits with the error ORA-01453: SET TRANSACTION must be first in > transaction when a sql command is issued -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
