Issue Details (XML | Word | Printable)

Key: DERBY-3427
Type: Bug Bug
Status: Resolved Resolved
Resolution: Fixed
Priority: Critical Critical
Assignee: Knut Anders Hatlen
Reporter: Rene Levantinh
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
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:
  Size
Text File Licensed for inclusion in ASF works d3427.diff 2008-03-05 02:15 PM Knut Anders Hatlen 4 kB
Java Source File SimpleNetworkClientSample1.java 2008-02-17 06:28 PM Rene Levantinh 17 kB
Java Source File SimpleNetworkServerSample.java 2008-02-17 06:28 PM Rene Levantinh 10 kB
Text File Licensed for inclusion in ASF works 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
 

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: Ascending order - Click to sort in descending 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]