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)
AFAIK Oracle doesn't like you changing the transaction isolation level unless it
is the first operation on an opened connection.
READ_COMMITTED is the default for Oracle anyway.