[OAK-2918] RDBConnectionHandler: handle failure on setReadOnly() gracefully

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.0.14, 1.2.2, 1.3.0
• Fix Version/s: 1.0.15, 1.2.3, 1.3.0, 1.4
• Component/s: rdbmk
• Assignee: Julian Reschke
• Reporter: Julian Reschke
• Created: 27/May/15 15:14
• Updated: 02/Mar/16 11:28
• Resolved: 28/May/15 12:13

Description

It appears that WAS wraps Oracle JDBC connection objects and throws upon setReadOnly():

java.sql.SQLException: DSRA9010E: 'setReadOnly' is not supported on the WebSphere java.sql.Connection implementation.
at com.ibm.ws.rsadapter.spi.InternalOracleDataStoreHelper.setReadOnly(InternalOracleDataStoreHelper.java:369)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.setReadOnly(WSJdbcConnection.java:3626)
at org.apache.jackrabbit.oak.plugins.document.rdb.RDBConnectionHandler.getROConnection(RDBConnectionHandler.java:61)

...which of course is a bug in WAS (setReadOnly() is documented as a hint, the implementation is not supposed to throw an exception here); see also <http://www-01.ibm.com/support/docview.wss?uid=swg1PM58588>

Issue Links

• is cloned by: OAK-2952 RDBConnectionHandler: log failures on setReadOnly() only once