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

Derby

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

Created: 17/Feb/08 06:24 PM Updated: 30/Jun/09 03:55 PM

Return to search

Component/s:

SQL

Affects Version/s:

10.3.1.4, 10.3.2.1

Fix Version/s:

10.3.3.0, 10.4.1.3

Time Tracking:

Not Specified

File Attachments:

File Name	Date Attached	Attached By	Size
d3427.diff	2008-03-05 02:15 PM	Knut Anders Hatlen	4 kB
SimpleNetworkClientSample1.java	2008-02-17 06:28 PM	Rene Levantinh	17 kB
SimpleNetworkServerSample.java	2008-02-17 06:28 PM	Rene Levantinh	10 kB
use-holdability.diff	2008-03-04 04:18 PM	Knut Anders Hatlen	0.9 kB

Environment:

windows XP Java version 1.6.0_03

Issue Links:

Reference

This issue relates to:

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

Urgency:	Urgent
Bug behavior facts:	Regression
Resolution Date:	17/Mar/08 06:52 AM

Description

« Hide

setting transaction isolation level to read committed after reading a BLOG record raise ERROR X0X03: Invalid transaction state - held cursor requires same isolation level .

Using Derby client 10.2 either with Derby server 10.3 or 10.2 works fine .

Using Derby Client 10.3 with Derby Server 10.2 also work fine.

All

Comments

Work Log

Change History

Subversion Commits

Sort Order:

Rene Levantinh made changes - 17/Feb/08 06:28 PM

Field	Original Value	New Value
Attachment		SimpleNetworkServerSample.java [ 12375800 ]
Attachment		SimpleNetworkClientSample1.java [ 12375799 ]

Dyre Tjeldvoll made changes - 18/Feb/08 11:21 AM

Comment

[ Are you saying that this is a regression from 10.2 to 10.3?

Your example contains quite a bit of code. Could you pin-point where you're getting the error?

Do you get the same errors with data types other than BLOB/CLOB? ]

Knut Anders Hatlen made changes - 18/Feb/08 12:31 PM

Derby Info

[Regression]

Knut Anders Hatlen made changes - 04/Mar/08 04:18 PM

Attachment

use-holdability.diff [ 12377092 ]

Knut Anders Hatlen made changes - 05/Mar/08 09:12 AM

Assignee

Knut Anders Hatlen [ knutanders ]

Knut Anders Hatlen made changes - 05/Mar/08 12:27 PM

Link

This issue relates to ~~DERBY-3496~~ [ ~~DERBY-3496~~ ]

Knut Anders Hatlen made changes - 05/Mar/08 02:15 PM

Attachment

d3427.diff [ 12377171 ]

Knut Anders Hatlen made changes - 05/Mar/08 02:16 PM

Status

Open [ 1 ]

In Progress [ 3 ]

Knut Anders Hatlen made changes - 05/Mar/08 02:16 PM

Derby Info

[Regression]

[Patch Available, Regression]

Knut Anders Hatlen made changes - 06/Mar/08 10:00 AM

Derby Info	[Regression, Patch Available]	[Regression]
Fix Version/s		10.4.0.0 [ 12312540 ]

Dyre Tjeldvoll made changes - 07/Mar/08 10:57 AM

Fix Version/s

10.3.2.2 [ 12312885 ]

Knut Anders Hatlen made changes - 17/Mar/08 06:52 AM

Resolution		Fixed [ 1 ]
Status	In Progress [ 3 ]	Resolved [ 5 ]

Kathey Marsden made changes - 25/Jul/08 05:14 PM

Component/s

SQL [ 11408 ]

Dag H. Wanvik made changes - 30/Jun/09 03:55 PM

Bug behavior facts

[Regression]