Derby
  1. Derby
  2. DERBY-1850

Test jdbcapi/SURTest_ij.sql fails on IBM WCTME 5.7 Foundation (jdkJ2ME Foundation Specification v1.0)

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major 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
    • Labels:
      None
    • Environment:
      Windows

      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 ***

        Activity

        Hide
        Myrna van Lunteren added a comment -

        fixed in trunk by commit http://svn.apache.org/viewvc?view=rev&revision=476588:

        • added the required ij.dataSource settings
        • added sedding of first CONNECTION line, to avoid extra master

        M java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/SURTest_ij_app.properties
        AM java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/SURTest_ij_sed.properties

        Show
        Myrna van Lunteren added a comment - fixed in trunk by commit http://svn.apache.org/viewvc?view=rev&revision=476588: added the required ij.dataSource settings added sedding of first CONNECTION line, to avoid extra master M java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/SURTest_ij_app.properties AM java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/SURTest_ij_sed.properties
        Hide
        Myrna van Lunteren added a comment -
        Show
        Myrna van Lunteren added a comment - merged to 10.2 with http://svn.apache.org/viewvc?view=rev&revision=476591
        Hide
        Myrna van Lunteren added a comment -

        Missed updating the file DerbyNetClient/SURTest_ij.out.
        (hurray for the tinderbox).

        fixed on trunk with:
        http://svn.apache.org/viewvc?view=rev&revision=476645:
        Sending java\testing\org\apache\derbyTesting\functionTests\master\DerbyNetClient\SURTest_ij.out

        fixed on 10.2 branch with:
        Sending java\testing\org\apache\derbyTesting\functionTests\master\DerbyNe
        tClient\SURTest_ij.out
        http://svn.apache.org/viewvc?view=rev&revision=476648

        Show
        Myrna van Lunteren added a comment - Missed updating the file DerbyNetClient/SURTest_ij.out. (hurray for the tinderbox). fixed on trunk with: http://svn.apache.org/viewvc?view=rev&revision=476645: Sending java\testing\org\apache\derbyTesting\functionTests\master\DerbyNetClient\SURTest_ij.out fixed on 10.2 branch with: Sending java\testing\org\apache\derbyTesting\functionTests\master\DerbyNe tClient\SURTest_ij.out http://svn.apache.org/viewvc?view=rev&revision=476648

          People

          • Assignee:
            Myrna van Lunteren
            Reporter:
            Rajesh Kartha
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development