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

Derby

CallableStatement with output parameter leaves cursor open after execution

Created: 05/Mar/08 12:17 PM Updated: 27/May/08 04:17 PM

Return to search

Component/s:

JDBC

Affects Version/s:

10.4.1.3

Fix Version/s:

10.3.3.0, 10.4.1.3

Time Tracking:

Not Specified

File Attachments:

File Name	Date Attached	Attached By	Size
derby-3496.diff	2008-03-20 02:36 PM	Dyre Tjeldvoll	1 kB
junit-repro.diff	2008-03-05 12:21 PM	Knut Anders Hatlen	1.0 kB

Issue Links:

Reference

This issue is related to:

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

Resolution Date:

25/Mar/08 01:38 PM

Description

« Hide

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".

All

Comments

Work Log

Change History

Subversion Commits

Sort Order:

Repository	Revision	Date	User	Message
ASF	#640787	Tue Mar 25 12:34:18 UTC 2008	dyre	~~DERBY-3496~~: CallableStatement with output parameter leaves cursor open after execution Patch file: ~~DERBY-3496~~.diff (fixed the indentation problem)
				Files Changed
				MODIFY /db/derby/code/trunk/java/engine/org/apache/derby/impl/jdbc/EmbedCallableStatement.java MODIFY /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/CallableTest.java

Repository	Revision	Date	User	Message
ASF	#640801	Tue Mar 25 13:28:52 UTC 2008	dyre	~~DERBY-3496~~: CallableStatement with output parameter leaves cursor open after exe cution Close the result set used to get the output parameter of an EmbedCallableStatement Merged to 10.4 with svn merge -r 640786:640787 ../derby-scratch No conflicts
				Files Changed
				MODIFY /db/derby/code/branches/10.4/java/engine/org/apache/derby/impl/jdbc/EmbedCallableStatement.java MODIFY /db/derby/code/branches/10.4/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/CallableTest.java

Repository	Revision	Date	User	Message
ASF	#640808	Tue Mar 25 13:39:16 UTC 2008	dyre	~~DERBY-3496~~: CallableStatement with output parameter leaves cursor open after exe cution Close the result set used to get the output parameter of an EmbedCallableStatement Merged to 10.3 with svn merge -r 640786:640787 ../derby-scratch No conflicts
				Files Changed
				MODIFY /db/derby/code/branches/10.3/java/engine/org/apache/derby/impl/jdbc/EmbedCallableStatement.java MODIFY /db/derby/code/branches/10.3/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/CallableTest.java