[ 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
