Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <26169011.1158705562792.JavaMail.jira@brutus>
Date: Tue, 19 Sep 2006 15:39:22 -0700 (PDT)
From: "Sunitha Kambhampati (JIRA)" <derby-dev@db.apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Updated: (DERBY-1830) optimizerOverrides.sql fails with
 wctme5.7 with CNFE  java.sql.DriverManager.
In-Reply-To: <9995767.1157672003690.JavaMail.jira@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

     [ http://issues.apache.org/jira/browse/DERBY-1830?page=all ]

Sunitha Kambhampati updated DERBY-1830:
---------------------------------------

    Attachment: derby1830.stat.txt
                derby1830.diff.txt

The testcase added for derby-1660 in optimizerOverrides.sql uses jdbc:default:connection and does not work with wctme5.7 foundation causing the diff mentioned in this jira.    This testcase needs to be excluded and should run only in environments that have support for DriverManager.

This patch (derby1830.diff.txt) converts this particular testcase into a junit test.

1. Add a new Junit test in lang suite - VTITest.java
2. Conditionally add the test fixture bulkInsertVtiTest if JDBC.vmSupportsJDBC2() is true.
3. Since the problematic testcase is converted to junit test, remove this test from optimizerOverrides.sql and update the master files for embedded and server frameworks.

derbyall ran cleanly on jdk142/windows. 

I ran the _Suite in lang and the VTITest using junit directly using the below commands.
java -Dderby.system.home=$PWD junit.textui.TestRunner org.apache.derbyTesting.functionTests.tests.lang._Suite
java -Dderby.system.home=$PWD junit.textui.TestRunner org.apache.derbyTesting.functionTests.tests.lang.VTITest

The test passed OK for jdk142 vm.  

In wctme5.7, I ran the VTITest and the test is skipped as expected.
Note: Using wctme5.7 for the entire lang _Suite does not work - this is related to Derby-1785

My wctme5.7_foundation environment is having problems so I have not been able to run tests there.  I am trying to get my env problems resolved.

Meantime, I'd appreciate it if someone can try this patch out on a wctme5.7_foundation environment and post the results.

Please take a look at this patch.

Thanks.

> optimizerOverrides.sql fails with wctme5.7 with CNFE  java.sql.DriverManager.
> -----------------------------------------------------------------------------
>
>                 Key: DERBY-1830
>                 URL: http://issues.apache.org/jira/browse/DERBY-1830
>             Project: Derby
>          Issue Type: Bug
>          Components: Regression Test Failure
>    Affects Versions: 10.3.0.0
>            Reporter: Sunitha Kambhampati
>            Priority: Minor
>         Attachments: derby1830.diff.txt, derby1830.stat.txt
>
>
> Test failed with 10.3 jars  10.3.0.0 alpha - (439522).
> *** Start: optimizerOverrides jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2006-09-03 12:47:49 ***
> 1747a1748,1756
> > ERROR 38000: The exception 'java.sql.SQLException: The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.' was thrown while evaluating an expression.
> > ERROR 38000: The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.
> > ERROR XJ001: Java exception: ': java.lang.reflect.InvocationTargetException'.
> > ERROR XJ001: Java exception: 'java.sql.DriverManager: java.lang.NoClassDefFoundError'.
> > ij> select * from warehouse order by t1;
> > T1         
> > -----------
> > ij> -- cleanup
> > drop table warehouse;
> 1749,1764d1757
> < ij> select * from warehouse order by t1;
> < T1         
> < -----------
> < 1          
> < 2          
> < 3          
> < 4          
> < 5          
> < 6          
> < 7          
> < 8          
> < 9          
> < 10         
> < ij> -- cleanup
> < drop table warehouse;
> < 0 rows inserted/updated/deleted
> Test Failed.
> *** End:   optimizerOverrides jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2006-09-03 12:48:06 ***
> This particular testcase was added as part of  DERBY-1660. 

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira