How to configure CLOSE_CURSORS_AT_COMMIT option for db2 datasource?
Issue
-
How to set the
db2 driver
toCLOSE_CURSORS_AT_COMMIT
and the default isHOLD_CURSORS_OVER_COMMIT
? -
DB2 tables
getting locked due to thejdbc driver
using its default value -HOLD_CURSORS_OVER_COMMIT
.
Environment
-
Red Hat JBoss Enterprise Application Platform 6.x
-
IBM DB2 driver
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.