PreparedStatement.executeUpdate throws a XJ05C exception in a global
transaction if the statement is HOLD_CURSORS_OVER_COMMIT
------------------------------------------------------------------------------------------------------------------------------
Key: DERBY-1159
URL: http://issues.apache.org/jira/browse/DERBY-1159
Project: Derby
Type: Bug
Versions: 10.1.2.1, 10.2.0.0
Reporter: Daniel John Debrunner
Assigned to: Daniel John Debrunner
Priority: Minor
SQLSTATE(XJ05C): Cannot set holdability ResultSet.HOLD_CURSORS_OVER_COMMIT for
a global transaction.
Exception is thrown in client, in embedded the statement executes successfully.
Since HOLD_CURSORS_OVER_COMMIT only applies to ResultSets and executeUpdate
states it only succeeds if the statement
does not generate ResultSets, then this combination should succeed.
Probably related to the fact that in embedded an execute() call on the same
PreparedStatement will thrown a XJ05C exception
Workaround is to prepare the statement explicitly with CLOSE_CURSORS_AT_COMMIT.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
