[TechNote] PM58588: [wi 154473] RTC-Oracle J2EE fails to connect: DSRA9010E: 'setRea dOnly' is not supported on the WebSphere java.sql.Connection

PM58588: [wi 154473] RTC-Oracle J2EE fails to connect: DSRA9010E: 'setRea dOnly' is not supported on the WebSphere java.sql.Connection

APAR status

• Closed as program error.

Error description

• If you turn on the RTC Datasource with Oracle the problem
  happens in server startup.
  Oracle J2EE fails to connect:  DSRA9010E: 'setReadOnly' is not
  supported on the WebSphere java.sql.Connection implementation
  
  
  Jazz.net Workitem URL:
  https://jazz.net/jazz/resource/itemName/com.ibm.team.workitem.Wo
  rkItem/154473
  

Local fix

• 
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Oracle J2EE fails to connect:  DSRA9010E: 'setReadOnly' is
  not supported on the WebSphere java.sql.Connection
  implementation
  

Problem conclusion

• Oracle databases do not support read-only mode.  Most JDBC
  connection drivers gracefully ignore this directive since
  it's only considered a hint to the underlying database.
  However, the WAS connection pool wrapper classes throw an
  exception.
  
  Added a wrapper Connection class to gracefully handle this
  limitation.