1 Reply Latest reply on Oct 15, 2004 7:31 AM by adrian.brock

    Transaction not committing

    cagreen

      I have an update as part of my transaction which doesn't seem to want to commit.
      Here's my set up:
      -I have set transaction-type = Container and trans-attribute=NotSupported in my ejb-jar.xml file.
      -I'm using a jndi datasource (OracleDS)
      -I'm explicitly setting transaction-isolation = TRANSACTION_READ_COMMITTED in oracle-ds.xml
      ...and I am getting the exception below. Any ideas?

      16:02:13,427 WARN [LocalManagedConnectionFactory] Error resetting transaction i
      solation
      java.sql.SQLException: READ_COMMITTED and SERIALIZABLE are the only valid transa
      ction levels
      at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
      at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
      at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
      at oracle.jdbc.driver.OracleConnection.setTransactionIsolation(OracleCon
      nection.java:1713)
      at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.cleanup(
      BaseWrapperManagedConnection.java:208)