ORA-01453: SET TRANSACTION must be first command of transaction exception with SharedPoolDataSource
---------------------------------------------------------------------------------------------------
Key: DBCP-308
URL: https://issues.apache.org/jira/browse/DBCP-308
Project: Commons Dbcp
Issue Type: Bug
Affects Versions: 1.2.2
Environment: JDK 1.5
Reporter: Ondrej Tisler
Priority: Minor
When using SharedPoolDataSource I get ORA-01453: SET TRANSACTION exception on con.setReadOnly(isDefaultReadOnly());
in setupDefaults method
I correct it with code -
protected void setupDefaults(Connection con, String username) throws SQLException {
con.rollback();
con.setReadOnly(isDefaultReadOnly());
con.setAutoCommit(isDefaultAutoCommit());
int defaultTransactionIsolation = getDefaultTransactionIsolation();
if (defaultTransactionIsolation != UNKNOWN_TRANSACTIONISOLATION) {
con.setTransactionIsolation(defaultTransactionIsolation);
}
}
rollback is important, without it it ends on same exception ...
I'm using 10.1.2.0.2 oracle driver
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
|