Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Supported Isolation Level

21 views
Skip to first unread message

eric

unread,
Aug 7, 2001, 2:45:57 PM8/7/01
to

I set a session bean's isolation level to TRANSACTION_READ_UNCOMMITTED in wls5.1
sp8 w/ oracle 8.1.6i. Then get an error "java.sql.SQLException: READ_COMMITTED
and SERIALIZABLE are the only valid transaction levels". How can I get TRANSACTION_READ_UNCOMMITTED
level? The stack trace:

javax.ejb.ObjectNotFoundException: Exception raised while finding bean with prim
ary key: '0001' in home: 'Ta'
java.sql.SQLException: READ_COMMITTED and SERIALIZABLE are the only valid transa
ction levels
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:156)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:219)
at oracle.jdbc.driver.OracleConnection.setTransactionIsolation(OracleCon
nection.java:716)
at weblogic.jdbcbase.jts.Connection.setTransactionIsolation(Connection.j
ava:389)
at weblogic.jdbcbase.jts.Connection.openConnectionIfNecessary(Connection
java:626)
at weblogic.jdbcbase.jts.Connection.prepareStatement(Connection.java:135
)
at com.mtc.test.TaEJBPSWebLogic_CMP_RDBMS.refreshByPrimaryKey(TaEJBPSWeb
Logic_CMP_RDBMS.java:485)
at com.mtc.test.TaEJBPSWebLogic_CMP_RDBMS.loadByPrimaryKey(TaEJBPSWebLog
ic_CMP_RDBMS.java:466)
at com.mtc.test.TaEJBPSWebLogic_CMP_RDBMS.findByPrimaryKey(TaEJBPSWebLog
ic_CMP_RDBMS.java:438)
at com.mtc.test.TaEJBHomeImpl.findByPrimaryKey(TaEJBHomeImpl.java:64)
at com.mtc.test.TaEJBHomeImpl_ServiceStub.findByPrimaryKey(TaEJBHomeImpl
_ServiceStub.java:149)
at com.mtc.test.SaEJB.handler(SaEJB.java:78)
at com.mtc.test.SaEJBEOImpl.handler(SaEJBEOImpl.java:55)
at com.mtc.test.SaEJBEOImpl_WLSkel.invoke(SaEJBEOImpl_WLSkel.java:126)
at weblogic.rmi.extensions.BasicServerObjectAdapter.invoke(BasicServerOb
jectAdapter.java:347)
at weblogic.rmi.extensions.BasicRequestHandler.handleRequest(BasicReques
tHandler.java:77)
at weblogic.rmi.internal.BasicExecuteRequest.execute(BasicExecuteRequest
java:15)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:129)

at com.mtc.test.TaEJBPSWebLogic_CMP_RDBMS.findByPrimaryKey(TaEJBPSWebLog
ic_CMP_RDBMS.java:454)
at com.mtc.test.TaEJBHomeImpl.findByPrimaryKey(TaEJBHomeImpl.java:64)
at com.mtc.test.TaEJBHomeImpl_ServiceStub.findByPrimaryKey(TaEJBHomeImpl
_ServiceStub.java:149)
at com.mtc.test.SaEJB.handler(SaEJB.java:78)
at com.mtc.test.SaEJBEOImpl.handler(SaEJBEOImpl.java:55)
at com.mtc.test.SaEJBEOImpl_WLSkel.invoke(SaEJBEOImpl_WLSkel.java:126)
at weblogic.rmi.extensions.BasicServerObjectAdapter.invoke(BasicServerOb
jectAdapter.java:347)
at weblogic.rmi.extensions.BasicRequestHandler.handleRequest(BasicReques
tHandler.java:77)
at weblogic.rmi.internal.BasicExecuteRequest.execute(BasicExecuteRequest
java:15)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:129)
Tue Aug 07 10:35:32 PDT 2001:<I> <RJVM> Signaling peer 2648168446091542635C192.1
68.10.24 gone: weblogic.rjvm.PeerGoneException:
- with nested exception:
[java.net.SocketException: Connection reset by peer]


Alexander Petrushko

unread,
Aug 7, 2001, 3:30:00 PM8/7/01
to
eric wrote:

> I set a session bean's isolation level to TRANSACTION_READ_UNCOMMITTED in wls5.1
> sp8 w/ oracle 8.1.6i. Then get an error "java.sql.SQLException: READ_COMMITTED
> and SERIALIZABLE are the only valid transaction levels". How can I get TRANSACTION_READ_UNCOMMITTED
> level?

You can't -- Oracle only supports read committed and serializable isolation levels. Are you trying to
mix CMP and JDBC in the same transaction?

Cheers,

Alex

eric

unread,
Aug 7, 2001, 7:39:59 PM8/7/01
to

thanks Alex,

No, i let container take over transaction controls.

eric

michali...@gmail.com

unread,
Jan 17, 2018, 6:17:41 AM1/17/18
to
did you fix it ??

i am getting the same error

michali...@gmail.com

unread,
Jan 18, 2018, 5:49:19 AM1/18/18
to
On Wednesday, August 8, 2001 at 12:39:59 AM UTC+1, eric wrote:
0 new messages