[DERBY-1850] Test jdbcapi/SURTest_ij.sql fails on IBM WCTME 5.7 Foundation (jdkJ2ME Foundation Specification v1.0)

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.2.2.0, 10.3.1.4
• Fix Version/s: 10.2.2.0, 10.3.1.4
• Component/s: Test
• Environment: Windows
• Assignee: Myrna van Lunteren
• Reporter: Rajesh Kartha
• Created: 14/Sep/06 01:14
• Updated: 01/Jul/09 00:09
• Resolved: 18/Nov/06 19:55

Description

The diff for the test is:

• • • Start: SURTest_ij jdkJ2ME Foundation Specification v1.0 derbyall:jdbcapi 2006-09-10 12:51:18 ***
      1 del
      < CONNECTION0* - jdbc:derby:SURTest
      2 del
      < * = current connection
      2a1
      > java.lang.reflect.InvocationTargetException: java.lang.NullPointerException
      4 del
      < WARNING 01J01: Database 'SURTest' not created, connection made to existing database instead.
      5 del
      < ij(CONNECTION1)> autocommit off;
      6 del
      < ij(CONNECTION1)> create table t1 (c1 int primary key, c2 int);
      6a3,4
      > ij> autocommit off;
      > ij> create table t1 (c1 int primary key, c2 int);
      8 del
      < ij(CONNECTION1)> insert into t1 values
      8a6
      > ij> insert into t1 values
      12 del
      < ij(CONNECTION1)> get scroll insensitive cursor sc1 as 'SELECT * FROM t1 FOR UPDATE';
      13 del
      < ij(CONNECTION1)> next sc1;
      13a10,11
      > ij> get scroll insensitive cursor sc1 as 'SELECT * FROM t1 FOR UPDATE';
      > ij> next sc1;
      17 del
      < ij(CONNECTION1)> next sc1;
      17a15
      > ij> next sc1;
      21 del
      < ij(CONNECTION1)> – update row nr. 2 after positioning with next
      21a19
      > ij> – update row nr. 2 after positioning with next
      24 del
      < ij(CONNECTION1)> absolute 5 sc1;
      24a22
      > ij> absolute 5 sc1;
      28 del
      < ij(CONNECTION1)> – update row nr. 5 after positioning with absolute
      28a26
      > ij> – update row nr. 5 after positioning with absolute
      31 del
      < ij(CONNECTION1)> relative 2 sc1;
      31a29
      > ij> relative 2 sc1;
      35 del
      < ij(CONNECTION1)> – update row nr. 7 after positioning with relative
      35a33
      > ij> – update row nr. 7 after positioning with relative
      38 del
      < ij(CONNECTION1)> previous sc1;
      38a36
      > ij> previous sc1;
      42 del
      < ij(CONNECTION1)> – update row nr. 6 after positioning with previous
      42a40
      > ij> – update row nr. 6 after positioning with previous
      45 del
      < ij(CONNECTION1)> relative -1 sc1;
      45a43
      > ij> relative -1 sc1;
      49 del
      < ij(CONNECTION1)> last sc1;
      49a47
      > ij> last sc1;
      53 del
      < ij(CONNECTION1)> – update row nr. 10 after positioning with last
      53a51
      > ij> – update row nr. 10 after positioning with last
      56 del
      < ij(CONNECTION1)> after last sc1;
      56a54
      > ij> after last sc1;
      58 del
      < ij(CONNECTION1)> – update when positioned after last should cause an error
      58a56
      > ij> – update when positioned after last should cause an error
      61 del
      < ij(CONNECTION1)> first sc1;
      61a59
      > ij> first sc1;
      65 del
      < ij(CONNECTION1)> – update row nr. 1 after positioning with first
      65a63
      > ij> – update row nr. 1 after positioning with first
      68 del
      < ij(CONNECTION1)> before first sc1;
      68a66
      > ij> before first sc1;
      70 del
      < ij(CONNECTION1)> – update when positioned before first should cause an error
      70a68
      > ij> – update when positioned before first should cause an error
      73 del
      < ij(CONNECTION1)> close sc1;
      74 del
      < ij(CONNECTION1)> commit;
      75 del
      < ij(CONNECTION1)> – check that row where correctly updated
      75a71,73
      > ij> close sc1;
      > ij> commit;
      > ij> – check that row where correctly updated
      90 del
      < ij(CONNECTION1)> get scroll insensitive cursor sc1 as 'SELECT * FROM t1 FOR UPDATE';
      91 del
      < ij(CONNECTION1)> next sc1;
      91a88,89
      > ij> get scroll insensitive cursor sc1 as 'SELECT * FROM t1 FOR UPDATE';
      > ij> next sc1;
      95 del
      < ij(CONNECTION1)> next sc1;
      95a93
      > ij> next sc1;
      99 del
      < ij(CONNECTION1)> – delete row nr. 2 after positioning with next
      99a97
      > ij> – delete row nr. 2 after positioning with next
      102 del
      < ij(CONNECTION1)> absolute 5 sc1;
      102a100
      > ij> absolute 5 sc1;
      106 del
      < ij(CONNECTION1)> – delete row nr. 5 after positioning with absolute
      106a104
      > ij> – delete row nr. 5 after positioning with absolute
      109 del
      < ij(CONNECTION1)> relative 2 sc1;
      109a107
      > ij> relative 2 sc1;
      113 del
      < ij(CONNECTION1)> – delete row nr. 7 after positioning with relative
      113a111
      > ij> – delete row nr. 7 after positioning with relative
      116 del
      < ij(CONNECTION1)> previous sc1;
      116a114
      > ij> previous sc1;
      120 del
      < ij(CONNECTION1)> – delete row nr. 6 after positioning with previous
      120a118
      > ij> – delete row nr. 6 after positioning with previous
      123 del
      < ij(CONNECTION1)> relative -1 sc1;
      123a121
      > ij> relative -1 sc1;
      127 del
      < ij(CONNECTION1)> last sc1;
      127a125
      > ij> last sc1;
      131 del
      < ij(CONNECTION1)> – delete row nr. 10 after positioning with last
      131a129
      > ij> – delete row nr. 10 after positioning with last
      134 del
      < ij(CONNECTION1)> after last sc1;
      134a132
      > ij> after last sc1;
      136 del
      < ij(CONNECTION1)> – delete when positioned after last should cause an error
      136a134
      > ij> – delete when positioned after last should cause an error
      139 del
      < ij(CONNECTION1)> first sc1;
      139a137
      > ij> first sc1;
      143 del
      < ij(CONNECTION1)> – delete row nr. 1 after positioning with first
      143a141
      > ij> – delete row nr. 1 after positioning with first
      146 del
      < ij(CONNECTION1)> before first sc1;
      146a144
      > ij> before first sc1;
      148 del
      < ij(CONNECTION1)> – delete when positioned before first should cause an error
      148a146
      > ij> – delete when positioned before first should cause an error
      151 del
      < ij(CONNECTION1)> close sc1;
      152 del
      < ij(CONNECTION1)> commit;
      153 del
      < ij(CONNECTION1)> – check that row where correctly updated
      153a149,151
      > ij> close sc1;
      > ij> commit;
      > ij> – check that row where correctly updated
      162 del
      < ij(CONNECTION1)>
      162 add
      > ij>
      Test Failed.
    • End: SURTest_ij jdkJ2ME Foundation Specification v1.0 derbyall:jdbcapi 2006-09-10 12:51:26 ***