commons-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ondrej Tisler (JIRA)" <j...@apache.org>
Subject [jira] Created: (DBCP-308) ORA-01453: SET TRANSACTION must be first command of transaction exception with SharedPoolDataSource
Date Thu, 26 Nov 2009 14:05:39 GMT
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.


Mime
View raw message