WebSphere Application Server & Liberty

WebSphere Application Server & Liberty

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only

websphere Default Isolation Level

  • 1.  websphere Default Isolation Level

    Posted Tue April 29, 2014 02:36 PM
    How do I achieve a webSphereDefaultIsolationLevel of  "Read Uncommited" in WAS 7.0.0.31.

    I change the datasource custom property value to 1 , which corresponds to Read Uncommitted , restarted my nodeagents,  JVMs, n my connection to DB looks good

    When the transaction is being validated I get the following  error 

    Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: READ_COMMITTED and SERIALIZABLE are the only valid transaction levelsDSRA0010E: SQL State = 99999, Error Code = 17,030

    I am using Oracle as a backend database with ojbc6.jar at a version 11.2.0.3.