When DataSourceUtils calls connection.setReadOnly, it catches the exception, logs it and continues.
When LazyConnectionDataSourceProxy gets instructions to call connection.setReadOnly, it does not catch the exception. This causes problems when using WebSphere 7 with an oracle database. The Oracle database does not support readOnly, and WebSphere 7 will throw an exception (see also http://www-01.ibm.com/support/docview.wss?uid=swg21194913) even though setReadOnly is only a hint. So the exception should be logged and ignored similar to what happens in DataSourceUtils.
Attached is a maven project which can be used to reproduce the issue and a stack trace.
Tim Alkemade opened SPR-10312 and commented
When
DataSourceUtils
callsconnection.setReadOnly
, it catches the exception, logs it and continues.When
LazyConnectionDataSourceProxy
gets instructions to callconnection.setReadOnly
, it does not catch the exception. This causes problems when using WebSphere 7 with an oracle database. The Oracle database does not supportreadOnly
, and WebSphere 7 will throw an exception (see also http://www-01.ibm.com/support/docview.wss?uid=swg21194913) even thoughsetReadOnly
is only a hint. So the exception should be logged and ignored similar to what happens inDataSourceUtils
.Attached is a maven project which can be used to reproduce the issue and a stack trace.
Affects: 3.1 GA
Attachments:
The text was updated successfully, but these errors were encountered: