db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas Fischer (JIRA)" <j...@apache.org>
Subject [jira] Commented: (TORQUE-12) serializable transactions using dbcp do not work in oracle
Date Mon, 01 May 2006 16:37:47 GMT
    [ 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


Mime
View raw message