[jira] Commented: (TORQUE-12) serializable transactions using dbcp do not work in oracle

["Thomas Fischer (JIRA)" <ji...@apache.org>]

    [ 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: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org