db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "John H. Embretsen (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-3217) ErrorStreamTest failing on ibm j9 jvm
Date Thu, 22 Nov 2007 11:10:47 GMT

    [ https://issues.apache.org/jira/browse/DERBY-3217?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12544779
] 

John H. Embretsen commented on DERBY-3217:
------------------------------------------

As far as I can see, there is no documented way to shut down the Derby engine when you are
using a DataSource (I've only looked at EmbeddedSimpleDataSource (used for Java ME) and EmbeddedDataSource).


However, I found that it is actually possible, by first setting the databaseName to the empty
String, then setting the connection attribute "shutdown=true", and finally trying to obtain
a connection. The exception is the same as I get when shutting down the engine using DriverManager.

        // Create an EmbeddedSimpleDataSource, setDatabaseName, setCreateDatabase, getConnection...

        try {
	    derbyDs.setDatabaseName("");
	    derbyDs.setConnectionAttributes("shutdown=true");
	    System.out.println("Shutting down engine...?");
            derbyDs.getConnection();
        } catch (SQLException ex) {
		do {
		    System.err.println("----- SQLException -----");
		    System.err.println("SQLState:   " + ex.getSQLState());
		    System.err.println("Error code: " + ex.getErrorCode());
		    //ex.printStackTrace();
		    ex = ex.getNextException();
		} while (ex != null);
            }
        }


To restart the engine, create a new datasource object and set the correct databaseName, then
getConnection().
It seems that the engine is started on the first call to getConnection().

The test harness is a bit more complicated (less direct) in the way it sets DataSource properties,
but it should be possible to implement something like this there as well, if needed. 

> ErrorStreamTest failing on ibm j9 jvm
> -------------------------------------
>
>                 Key: DERBY-3217
>                 URL: https://issues.apache.org/jira/browse/DERBY-3217
>             Project: Derby
>          Issue Type: Bug
>          Components: Regression Test Failure
>    Affects Versions: 10.4.0.0
>         Environment: J9 - VM for the Java(TM) platform, Version 2.3
> (c) Copyright IBM Corp. 1991, 2006  All Rights Reserved
> Target: 20061023_08962_lHdSMR (Windows XP 5.1 build 2600 Service Pack 2 x86)
> JIT  - 20060629_1804ifx1_r8
>            Reporter: Mike Matrigali
>            Assignee: Vemund Østgaard
>
> Getting the following junit tests failures on just on the j9 jvm  platform running on
windows:
> There were 11 failures:
> 1) testDefault(org.apache.derbyTesting.functionTests.tests.engine.ErrorStreamTest)junit.framework.AssertionFailedError:
shutdown engine not implemened
> 	at org.apache.derbyTesting.junit.DataSourceConnector.shutEngine(DataSourceConnector.java:130)
> 	at org.apache.derbyTesting.junit.TestConfiguration.shutdownEngine(TestConfiguration.java:1091)
> 	at org.apache.derbyTesting.functionTests.tests.engine.ErrorStreamTest.testDefault(ErrorStreamTest.java:128)
> 	at java.lang.reflect.AccessibleObject.invokeV(AccessibleObject.java:205)
> 	at <unknown class>.<unknown method>(Unknown Source)
> 	at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:95)
> 2) testFile(org.apache.derbyTesting.functionTests.tests.engine.ErrorStreamTest)junit.framework.AssertionFailedError:
shutdown engine not implemened
> 	at org.apache.derbyTesting.junit.DataSourceConnector.shutEngine(DataSourceConnector.java:130)
> 	at org.apache.derbyTesting.junit.TestConfiguration.shutdownEngine(TestConfiguration.java:1091)
> 	at org.apache.derbyTesting.functionTests.tests.engine.ErrorStreamTest.testFile(ErrorStreamTest.java:141)
> 	at java.lang.reflect.AccessibleObject.invokeV(AccessibleObject.java:205)
> 	at <unknown class>.<unknown method>(Unknown Source)
> 	at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:95)
> 3) testWrongFile(org.apache.derbyTesting.functionTests.tests.engine.ErrorStreamTest)junit.framework.AssertionFailedError:
shutdown engine not implemened
> 	at org.apache.derbyTesting.junit.DataSourceConnector.shutEngine(DataSourceConnector.java:130)
> 	at org.apache.derbyTesting.junit.TestConfiguration.shutdownEngine(TestConfiguration.java:1091)
> 	at org.apache.derbyTesting.functionTests.tests.engine.ErrorStreamTest.testWrongFile(ErrorStreamTest.java:160)
> 	at java.lang.reflect.AccessibleObject.invokeV(AccessibleObject.java:205)
> 	at <unknown class>.<unknown method>(Unknown Source)
> 	at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:95)
> 4) testMethod(org.apache.derbyTesting.functionTests.tests.engine.ErrorStreamTest)junit.framework.AssertionFailedError:
shutdown engine not implemened
> 	at org.apache.derbyTesting.junit.DataSourceConnector.shutEngine(DataSourceConnector.java:130)
> 	at org.apache.derbyTesting.junit.TestConfiguration.shutdownEngine(TestConfiguration.java:1091)
> 	at org.apache.derbyTesting.functionTests.tests.engine.ErrorStreamTest.testMethod(ErrorStreamTest.java:179)
> 	at java.lang.reflect.AccessibleObject.invokeV(AccessibleObject.java:205)
> 	at <unknown class>.<unknown method>(Unknown Source)
> 	at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:95)
> 5) testWrongMethod(org.apache.derbyTesting.functionTests.tests.engine.ErrorStreamTest)junit.framework.AssertionFailedError:
shutdown engine not implemened
> 	at org.apache.derbyTesting.junit.DataSourceConnector.shutEngine(DataSourceConnector.java:130)
> 	at org.apache.derbyTesting.junit.TestConfiguration.shutdownEngine(TestConfiguration.java:1091)
> 	at org.apache.derbyTesting.functionTests.tests.engine.ErrorStreamTest.testWrongMethod(ErrorStreamTest.java:198)
> 	at java.lang.reflect.AccessibleObject.invokeV(AccessibleObject.java:205)
> 	at <unknown class>.<unknown method>(Unknown Source)
> 	at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:95)
> 6) testField(org.apache.derbyTesting.functionTests.tests.engine.ErrorStreamTest)junit.framework.AssertionFailedError:
shutdown engine not implemened
> 	at org.apache.derbyTesting.junit.DataSourceConnector.shutEngine(DataSourceConnector.java:130)
> 	at org.apache.derbyTesting.junit.TestConfiguration.shutdownEngine(TestConfiguration.java:1091)
> 	at org.apache.derbyTesting.functionTests.tests.engine.ErrorStreamTest.testField(ErrorStreamTest.java:217)
> 	at java.lang.reflect.AccessibleObject.invokeV(AccessibleObject.java:205)
> 	at <unknown class>.<unknown method>(Unknown Source)
> 	at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:95)
> 7) testWrongField(org.apache.derbyTesting.functionTests.tests.engine.ErrorStreamTest)junit.framework.AssertionFailedError:
shutdown engine not implemened
> 	at org.apache.derbyTesting.junit.DataSourceConnector.shutEngine(DataSourceConnector.java:130)
> 	at org.apache.derbyTesting.junit.TestConfiguration.shutdownEngine(TestConfiguration.java:1091)
> 	at org.apache.derbyTesting.functionTests.tests.engine.ErrorStreamTest.testWrongField(ErrorStreamTest.java:236)
> 	at java.lang.reflect.AccessibleObject.invokeV(AccessibleObject.java:205)
> 	at <unknown class>.<unknown method>(Unknown Source)
> 	at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:95)
> 8) testFileOverMethod(org.apache.derbyTesting.functionTests.tests.engine.ErrorStreamTest)junit.framework.AssertionFailedError:
shutdown engine not implemened
> 	at org.apache.derbyTesting.junit.DataSourceConnector.shutEngine(DataSourceConnector.java:130)
> 	at org.apache.derbyTesting.junit.TestConfiguration.shutdownEngine(TestConfiguration.java:1091)
> 	at org.apache.derbyTesting.functionTests.tests.engine.ErrorStreamTest.testFileOverMethod(ErrorStreamTest.java:257)
> 	at java.lang.reflect.AccessibleObject.invokeV(AccessibleObject.java:205)
> 	at <unknown class>.<unknown method>(Unknown Source)
> 	at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:95)
> 9) testFileOverField(org.apache.derbyTesting.functionTests.tests.engine.ErrorStreamTest)junit.framework.AssertionFailedError:
shutdown engine not implemened
> 	at org.apache.derbyTesting.junit.DataSourceConnector.shutEngine(DataSourceConnector.java:130)
> 	at org.apache.derbyTesting.junit.TestConfiguration.shutdownEngine(TestConfiguration.java:1091)
> 	at org.apache.derbyTesting.functionTests.tests.engine.ErrorStreamTest.testFileOverField(ErrorStreamTest.java:278)
> 	at java.lang.reflect.AccessibleObject.invokeV(AccessibleObject.java:205)
> 	at <unknown class>.<unknown method>(Unknown Source)
> 	at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:95)
> 10) testFileOverMethodAndField(org.apache.derbyTesting.functionTests.tests.engine.ErrorStreamTest)junit.framework.AssertionFailedError:
shutdown engine not implemened
> 	at org.apache.derbyTesting.junit.DataSourceConnector.shutEngine(DataSourceConnector.java:130)
> 	at org.apache.derbyTesting.junit.TestConfiguration.shutdownEngine(TestConfiguration.java:1091)
> 	at org.apache.derbyTesting.functionTests.tests.engine.ErrorStreamTest.testFileOverMethodAndField(ErrorStreamTest.java:302)
> 	at java.lang.reflect.AccessibleObject.invokeV(AccessibleObject.java:205)
> 	at <unknown class>.<unknown method>(Unknown Source)
> 	at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:95)
> 11) testMethodOverField(org.apache.derbyTesting.functionTests.tests.engine.ErrorStreamTest)junit.framework.AssertionFailedError:
shutdown engine not implemened
> 	at org.apache.derbyTesting.junit.DataSourceConnector.shutEngine(DataSourceConnector.java:130)
> 	at org.apache.derbyTesting.junit.TestConfiguration.shutdownEngine(TestConfiguration.java:1091)
> 	at org.apache.derbyTesting.functionTests.tests.engine.ErrorStreamTest.testMethodOverField(ErrorStreamTest.java:326)
> 	at java.lang.reflect.AccessibleObject.invokeV(AccessibleObject.java:205)
> 	at <unknown class>.<unknown method>(Unknown Source)
> 	at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:95)

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message