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

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 10.3.1.4, 10.3.2.1
• Fix Version/s: 10.3.3.0, 10.4.1.3
• Component/s: SQL
• Environment: windows XP Java version 1.6.0_03
• Urgency: Urgent
• Bug behavior facts: Regression
• Assignee: Knut Anders Hatlen
• Reporter: Rene Levantinh
• Created: 17/Feb/08 18:24
• Updated: 21/Jan/11 17:51
• Resolved: 17/Mar/08 06:52

Description

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.

Issue Links

• relates to: DERBY-3496 CallableStatement with output parameter leaves cursor open after execution