db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sunitha Kambhampati (JIRA)" <derby-...@db.apache.org>
Subject [jira] Updated: (DERBY-1830) optimizerOverrides.sql fails with wctme5.7 with CNFE java.sql.DriverManager.
Date Tue, 19 Sep 2006 22:39:22 GMT
     [ 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

        

Mime
View raw message