[DERBY-3496] CallableStatement with output parameter leaves cursor open after execution

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 10.4.1.3
• Fix Version/s: 10.3.3.0, 10.4.1.3
• Component/s: JDBC
• Assignee: Dyre Tjeldvoll
• Reporter: Knut Anders Hatlen
• Created: 05/Mar/08 12:17
• Updated: 27/May/08 16:17
• Resolved: 25/Mar/08 13:38

Description

When executing a CallableStatement which has an output parameter, the language result set is left open and makes subsequent calls to Connection.setTransactionIsolation() fail with "ERROR X0X03: Invalid transaction state - held cursor requires same isolation level".

Issue Links

• is related to: DERBY-3427 setting transaction isolation level to read committed raise ERROR X0X03: Invalid transaction state - held cursor requires same isolation level