Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What transaction isolation levels does the WebLogic jDriver for Oracle support?

April 26, 2017isolation jDriver levels Oracle support transaction WebLogic

0

Posted

What transaction isolation levels does the WebLogic jDriver for Oracle support?

2 Answers

0

Posted

Your servlet application may use Oracle Thin Drivers to access a database that includes BLOB fields. If you install and try to use WebLogic jDriver for Oracle and the same code fails and produces an exception similar to the following: com.roguewave.jdbtools.v2_0.LoginFailureException: TRANSACTION_READ_UNCOMMITTED isolation level not allowed The Stack Trace: com.roguewave.jdbtools.v2_0.LoginFailureException: TRANSACTION_READ_UNCOMMITTED isolation level not allowed at com.roguewave.jdbtools.v2_0.jdbc.JDBCServer.createConnection (JDBCServer.java :46) at com.roguewave.jdbtools.v2_0.ConnectionPool.getConnection_ (ConnectionPool.jav a:412) at com.roguewave.jdbtools.v2_0.ConnectionPool.getConnection (ConnectionPool.java :109) Setting the Isolation_level to 1 in the code that calls the RogueWave JDBCServer class works with the Oracle thin driver but fails with WebLogic jDriver for Oracle. WebLogic jDriver for Oracle supports the following transaction isolation levels: SET TRANSACTION ISOLATION

0

Posted

A. Your servlet application may use Oracle Thin Drivers to access a database that includes BLOB fields. If you install and try to use WebLogic jDriver for Oracle and the same code fails and produces an exception similar to the following: com.roguewave.jdbtools.v2_0.LoginFailureException: TRANSACTION_READ_UNCOMMITTED isolation level not allowed The Stack Trace: com.roguewave.jdbtools.v2_0.LoginFailureException: TRANSACTION_READ_UNCOMMITTED isolation level not allowed at com.roguewave.jdbtools.v2_0.jdbc.JDBCServer.createConnection (JDBCServer.java :46) at com.roguewave.jdbtools.v2_0.ConnectionPool.getConnection_ (ConnectionPool.jav a:412) at com.roguewave.jdbtools.v2_0.ConnectionPool.getConnection (ConnectionPool.java :109) Setting the Isolation_level to 1 in the code that calls the RogueWave JDBCServer class works with the Oracle thin driver but fails with WebLogic jDriver for Oracle. WebLogic jDriver for Oracle supports the following transaction isolation levels: SET TRANSACTION ISOLAT