[
https://issues.apache.org/jira/browse/DERBY-3427?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12569877#action_12569877
]
Knut Anders Hatlen commented on DERBY-3427:
-------------------------------------------
Dyre, I managed to reproduce it with this ij script:
connect 'jdbc:derby://localhost/d3427db;create=true';
create table t (b blob);
insert into t values cast (x'ffff' as blob);
select * from t;
set isolation rr;
It works on 10.2.2.0 and fails with X0X03 on 10.3.1.4, so it seems like it is a
regression.
> setting transaction isolation level to read committed raise ERROR X0X03:
> Invalid transaction state - held cursor requires same isolation level
> ----------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-3427
> URL: https://issues.apache.org/jira/browse/DERBY-3427
> Project: Derby
> Issue Type: Bug
> Affects Versions: 10.3.1.4, 10.3.2.1
> Environment: windows XP Java version 1.6.0_03
> Reporter: Rene Levantinh
> Priority: Critical
> Attachments: SimpleNetworkClientSample1.java,
> SimpleNetworkServerSample.java
>
>
> 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.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
