Critical issue with Connection.setReadOnly on WebLogic
269171Sep 21 2009 — edited Oct 15 2014Hi All,
We've just hit a critical issue while running on WebLogic.
After establishing a connection from a connection pool, we set the ReadOnly status to true on the Connection.
(We do this so user entered SQL can be executed)
In testing, we put in a DELETE FROM TEST_TABLE_NAME command, and the code is actually performing the delete.
(Updates the same)
I've connected a remote debugger and seen that the ReadOnly flag is set to true inside the connection Object.
This is how my connection pool is configured........
driver class name: oracle.jdbc.OracleDriver
properties:
user=V42_ISMART_DEMO_USER
ejb=sisPool
class=oracle.jdbc.pool.OracleConnectionPoolDataSource
protocol=thin
xa-location=jdbc/xa/sisPool
Transaction is using One-Phase commit.
database is 11.1.0.7.0
Weblogic 10.3
Java 1.6
Any pointers in the right direction would be greatly appreciated, as this is currently blocking a product release.
Thanks,
Ronan