[TORQUE-12] serializable transactions using dbcp do not work in oracle

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.1, 3.1.1, 3.2
• Fix Version/s: 3.3-RC3
• Component/s: Runtime
• Environment: oracle
• Old Scarab Id: TRQS303
• Assignee: Thomas Fox
• Reporter: Thomas Fox
• Created: 01/May/06 23:34
• Updated: 24/Sep/07 20:38
• Resolved: 24/Sep/07 20:38

Description

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

Issue Links

• is duplicated by: TORQUE-83 ORA-01453: SET TRANSACTION must be first statement of transaction error in the method