Derby
  1. Derby
  2. DERBY-6123

Optional tools documentation in the reference guide should mention that optional tools require derbytools.jar be in the CLASSPATH

    Details

    • Urgency:
      Normal
    • Issue & fix info:
      Newcomer

      Description

      The optional tools require derbytools.jar to run. This should be mentioned in the reference manual documentation.

      1. DERBY-6123.diff
        3 kB
        Kim Haase
      2. DERBY-6123.stat
        0.1 kB
        Kim Haase
      3. DERBY-6123.zip
        7 kB
        Kim Haase

        Issue Links

          Activity

          Hide
          Mike Matrigali added a comment -

          what kind of error do you get when it is not in classpath? Posting it here might at least give a search hit for someone running into issue.

          Show
          Mike Matrigali added a comment - what kind of error do you get when it is not in classpath? Posting it here might at least give a search hit for someone running into issue.
          Hide
          Mamta A. Satoor added a comment -

          I ran one of the existing junit tests lang.OptionalToolsTest without derbytools.jar in the CLASSPATH and got class not found exceptions. I think user can run into class not found for org.apache.derby.impl.tools.optional.ForeignDBViews or org.apache.derby.impl.tools.optional.DBMDWrapper depending on which optional tool they are using.

          sh-4.1$ time java -Dderby.tests.trace=true junit.textui.TestRunner org.apache.derbyTesting.functionTests.tests.lang.OptionalToolsTest
          .
          (emb)lang.OptionalToolsTest.test_01_dbmdWrapper used 1096 ms E.
          (emb)lang.OptionalToolsTest.test_02_foreignDBViews used 3147 ms F.
          (emb)lang.OptionalToolsTest.test_03_customTool used 287 ms .
          (emb)lang.OptionalToolsTest.test_04_customOptimizerTrace used 259 ms
          Time: 10.119
          There was 1 error:
          1) test_01_dbmdWrapper(org.apache.derbyTesting.functionTests.tests.lang.OptionalToolsTest)java.sql.SQLException: Table/View 'T' already exists in Schema 'TEST_DBO'.
          at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:101)
          at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java:327)
          at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java:424)
          at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(TransactionResourceImpl.java:353)
          at org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java:2396)
          at org.apache.derby.impl.jdbc.ConnectionChild.handleException(ConnectionChild.java:85)
          at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1438)
          at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(EmbedPreparedStatement.java:1695)
          at org.apache.derby.impl.jdbc.EmbedPreparedStatement.execute(EmbedPreparedStatement.java:1379)
          at org.apache.derbyTesting.functionTests.tests.lang.GeneratedColumnsHelper.goodStatement(GeneratedColumnsHelper.java:140)
          at org.apache.derbyTesting.functionTests.tests.lang.OptionalToolsTest.test_01_dbmdWrapper(OptionalToolsTest.java:138)
          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
          at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:48)
          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
          at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:117)
          at org.apache.derbyTesting.junit.BaseJDBCTestCase.runBareOverridable(BaseJDBCTestCase.java:439)
          at org.apache.derbyTesting.junit.BaseJDBCTestCase.runBare(BaseJDBCTestCase.java:456)
          at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
          at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
          at junit.extensions.TestSetup.run(TestSetup.java:25)
          at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
          at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
          at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
          at junit.extensions.TestSetup.run(TestSetup.java:25)
          at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
          at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
          at junit.extensions.TestSetup.run(TestSetup.java:25)
          at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
          at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
          at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
          at junit.extensions.TestSetup.run(TestSetup.java:25)
          at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
          at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
          at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
          at junit.extensions.TestSetup.run(TestSetup.java:25)
          at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
          at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
          at junit.extensions.TestSetup.run(TestSetup.java:25)
          at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
          at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
          at junit.extensions.TestSetup.run(TestSetup.java:25)
          at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
          at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
          at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
          at junit.extensions.TestSetup.run(TestSetup.java:25)
          Caused by: java.sql.SQLException: Table/View 'T' already exists in Schema 'TEST_DBO'.
          at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:42)
          at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(SQLExceptionFactory40.java:125)
          at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:71)
          ... 64 more
          Caused by: ERROR X0Y32: Table/View 'T' already exists in Schema 'TEST_DBO'.
          at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:363)
          at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.duplicateDescriptorException(DataDictionaryImpl.java:2050)
          at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.addDescriptor(DataDictionaryImpl.java:2041)
          at org.apache.derby.impl.sql.execute.CreateTableConstantAction.executeConstantAction(CreateTableConstantAction.java:238)
          at org.apache.derby.impl.sql.execute.MiscResultSet.open(MiscResultSet.java:61)
          at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(GenericPreparedStatement.java:453)
          at org.apache.derby.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java:334)
          at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1346)
          ... 58 more
          There was 1 failure:
          1) test_02_foreignDBViews(org.apache.derbyTesting.functionTests.tests.lang.OptionalToolsTest)junit.framework.ComparisonFailure: Unexpected SQL state. expected:<[38000]> but was:<[XJ001]>
          at org.apache.derbyTesting.junit.BaseJDBCTestCase.assertSQLState(BaseJDBCTestCase.java:875)
          at org.apache.derbyTesting.junit.BaseJDBCTestCase.assertSQLState(BaseJDBCTestCase.java:904)
          at org.apache.derbyTesting.junit.BaseJDBCTestCase.assertSQLState(BaseJDBCTestCase.java:939)
          at org.apache.derbyTesting.junit.BaseJDBCTestCase.assertStatementError(BaseJDBCTestCase.java:1294)
          at org.apache.derbyTesting.functionTests.tests.lang.GeneratedColumnsHelper.expectExecutionError(GeneratedColumnsHelper.java:214)
          at org.apache.derbyTesting.functionTests.tests.lang.OptionalToolsTest.test_02_foreignDBViews(OptionalToolsTest.java:253)
          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
          at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:48)
          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
          at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:117)
          at org.apache.derbyTesting.junit.BaseJDBCTestCase.runBareOverridable(BaseJDBCTestCase.java:439)
          at org.apache.derbyTesting.junit.BaseJDBCTestCase.runBare(BaseJDBCTestCase.java:456)
          at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
          at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
          at junit.extensions.TestSetup.run(TestSetup.java:25)
          at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
          at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
          at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
          at junit.extensions.TestSetup.run(TestSetup.java:25)
          at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
          at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
          at junit.extensions.TestSetup.run(TestSetup.java:25)
          at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
          at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
          at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
          at junit.extensions.TestSetup.run(TestSetup.java:25)
          at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
          at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
          at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
          at junit.extensions.TestSetup.run(TestSetup.java:25)
          at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
          at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
          at junit.extensions.TestSetup.run(TestSetup.java:25)
          at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
          at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
          at junit.extensions.TestSetup.run(TestSetup.java:25)
          at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
          at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
          at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
          at junit.extensions.TestSetup.run(TestSetup.java:25)
          Caused by: java.sql.SQLException: Java exception: 'org.apache.derby.impl.tools.optional.ForeignDBViews: java.lang.ClassNotFoundException'.
          at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:101)
          at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java:148)
          at org.apache.derby.impl.jdbc.Util.javaException(Util.java:370)
          at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java:436)
          at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java:431)
          at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(TransactionResourceImpl.java:353)
          at org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java:2396)
          at org.apache.derby.impl.jdbc.ConnectionChild.handleException(ConnectionChild.java:85)
          at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1438)
          at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(EmbedPreparedStatement.java:1695)
          at org.apache.derby.impl.jdbc.EmbedPreparedStatement.execute(EmbedPreparedStatement.java:1379)
          at org.apache.derbyTesting.junit.BaseJDBCTestCase.assertStatementError(BaseJDBCTestCase.java:1289)
          ... 56 more
          Caused by: java.sql.SQLException: Java exception: 'org.apache.derby.impl.tools.optional.ForeignDBViews: java.lang.ClassNotFoundException'.
          at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:42)
          at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(SQLExceptionFactory40.java:125)
          at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:71)
          ... 67 more
          Caused by: java.lang.ClassNotFoundException: org.apache.derby.impl.tools.optional.ForeignDBViews
          at org.apache.derby.impl.services.reflect.UpdateLoader.loadClass(UpdateLoader.java:193)
          at org.apache.derby.impl.services.reflect.DatabaseClasses.loadApplicationClass(DatabaseClasses.java:238)
          at org.apache.derby.catalog.Java5SystemProcedures.SYSCS_REGISTER_TOOL(Java5SystemProcedures.java:103)
          at org.apache.derby.exe.ac953a00d1x013fx7797x1333x00002e7b6a930.g0(Unknown Source)
          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
          at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:48)
          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
          at org.apache.derby.impl.services.reflect.ReflectMethod.invoke(ReflectMethod.java:46)
          at org.apache.derby.impl.sql.execute.CallStatementResultSet.open(CallStatementResultSet.java:75)
          at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(GenericPreparedStatement.java:453)
          at org.apache.derby.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java:334)
          at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1346)
          ... 59 more

          FAILURES!!!
          Tests run: 4, Failures: 1, Errors: 1

          real 0m11.326s
          user 0m0.015s
          sys 0m0.062s
          sh-4.1$

          Show
          Mamta A. Satoor added a comment - I ran one of the existing junit tests lang.OptionalToolsTest without derbytools.jar in the CLASSPATH and got class not found exceptions. I think user can run into class not found for org.apache.derby.impl.tools.optional.ForeignDBViews or org.apache.derby.impl.tools.optional.DBMDWrapper depending on which optional tool they are using. sh-4.1$ time java -Dderby.tests.trace=true junit.textui.TestRunner org.apache.derbyTesting.functionTests.tests.lang.OptionalToolsTest . (emb)lang.OptionalToolsTest.test_01_dbmdWrapper used 1096 ms E. (emb)lang.OptionalToolsTest.test_02_foreignDBViews used 3147 ms F. (emb)lang.OptionalToolsTest.test_03_customTool used 287 ms . (emb)lang.OptionalToolsTest.test_04_customOptimizerTrace used 259 ms Time: 10.119 There was 1 error: 1) test_01_dbmdWrapper(org.apache.derbyTesting.functionTests.tests.lang.OptionalToolsTest)java.sql.SQLException: Table/View 'T' already exists in Schema 'TEST_DBO'. at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:101) at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java:327) at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java:424) at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(TransactionResourceImpl.java:353) at org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java:2396) at org.apache.derby.impl.jdbc.ConnectionChild.handleException(ConnectionChild.java:85) at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1438) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(EmbedPreparedStatement.java:1695) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.execute(EmbedPreparedStatement.java:1379) at org.apache.derbyTesting.functionTests.tests.lang.GeneratedColumnsHelper.goodStatement(GeneratedColumnsHelper.java:140) at org.apache.derbyTesting.functionTests.tests.lang.OptionalToolsTest.test_01_dbmdWrapper(OptionalToolsTest.java:138) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:48) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:117) at org.apache.derbyTesting.junit.BaseJDBCTestCase.runBareOverridable(BaseJDBCTestCase.java:439) at org.apache.derbyTesting.junit.BaseJDBCTestCase.runBare(BaseJDBCTestCase.java:456) at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24) at junit.extensions.TestSetup$1.protect(TestSetup.java:21) at junit.extensions.TestSetup.run(TestSetup.java:25) at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57) at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24) at junit.extensions.TestSetup$1.protect(TestSetup.java:21) at junit.extensions.TestSetup.run(TestSetup.java:25) at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24) at junit.extensions.TestSetup$1.protect(TestSetup.java:21) at junit.extensions.TestSetup.run(TestSetup.java:25) at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57) at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24) at junit.extensions.TestSetup$1.protect(TestSetup.java:21) at junit.extensions.TestSetup.run(TestSetup.java:25) at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57) at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24) at junit.extensions.TestSetup$1.protect(TestSetup.java:21) at junit.extensions.TestSetup.run(TestSetup.java:25) at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24) at junit.extensions.TestSetup$1.protect(TestSetup.java:21) at junit.extensions.TestSetup.run(TestSetup.java:25) at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24) at junit.extensions.TestSetup$1.protect(TestSetup.java:21) at junit.extensions.TestSetup.run(TestSetup.java:25) at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57) at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24) at junit.extensions.TestSetup$1.protect(TestSetup.java:21) at junit.extensions.TestSetup.run(TestSetup.java:25) Caused by: java.sql.SQLException: Table/View 'T' already exists in Schema 'TEST_DBO'. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:42) at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(SQLExceptionFactory40.java:125) at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:71) ... 64 more Caused by: ERROR X0Y32: Table/View 'T' already exists in Schema 'TEST_DBO'. at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:363) at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.duplicateDescriptorException(DataDictionaryImpl.java:2050) at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.addDescriptor(DataDictionaryImpl.java:2041) at org.apache.derby.impl.sql.execute.CreateTableConstantAction.executeConstantAction(CreateTableConstantAction.java:238) at org.apache.derby.impl.sql.execute.MiscResultSet.open(MiscResultSet.java:61) at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(GenericPreparedStatement.java:453) at org.apache.derby.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java:334) at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1346) ... 58 more There was 1 failure: 1) test_02_foreignDBViews(org.apache.derbyTesting.functionTests.tests.lang.OptionalToolsTest)junit.framework.ComparisonFailure: Unexpected SQL state. expected:< [38000] > but was:< [XJ001] > at org.apache.derbyTesting.junit.BaseJDBCTestCase.assertSQLState(BaseJDBCTestCase.java:875) at org.apache.derbyTesting.junit.BaseJDBCTestCase.assertSQLState(BaseJDBCTestCase.java:904) at org.apache.derbyTesting.junit.BaseJDBCTestCase.assertSQLState(BaseJDBCTestCase.java:939) at org.apache.derbyTesting.junit.BaseJDBCTestCase.assertStatementError(BaseJDBCTestCase.java:1294) at org.apache.derbyTesting.functionTests.tests.lang.GeneratedColumnsHelper.expectExecutionError(GeneratedColumnsHelper.java:214) at org.apache.derbyTesting.functionTests.tests.lang.OptionalToolsTest.test_02_foreignDBViews(OptionalToolsTest.java:253) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:48) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:117) at org.apache.derbyTesting.junit.BaseJDBCTestCase.runBareOverridable(BaseJDBCTestCase.java:439) at org.apache.derbyTesting.junit.BaseJDBCTestCase.runBare(BaseJDBCTestCase.java:456) at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24) at junit.extensions.TestSetup$1.protect(TestSetup.java:21) at junit.extensions.TestSetup.run(TestSetup.java:25) at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57) at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24) at junit.extensions.TestSetup$1.protect(TestSetup.java:21) at junit.extensions.TestSetup.run(TestSetup.java:25) at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24) at junit.extensions.TestSetup$1.protect(TestSetup.java:21) at junit.extensions.TestSetup.run(TestSetup.java:25) at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57) at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24) at junit.extensions.TestSetup$1.protect(TestSetup.java:21) at junit.extensions.TestSetup.run(TestSetup.java:25) at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57) at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24) at junit.extensions.TestSetup$1.protect(TestSetup.java:21) at junit.extensions.TestSetup.run(TestSetup.java:25) at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24) at junit.extensions.TestSetup$1.protect(TestSetup.java:21) at junit.extensions.TestSetup.run(TestSetup.java:25) at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24) at junit.extensions.TestSetup$1.protect(TestSetup.java:21) at junit.extensions.TestSetup.run(TestSetup.java:25) at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57) at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24) at junit.extensions.TestSetup$1.protect(TestSetup.java:21) at junit.extensions.TestSetup.run(TestSetup.java:25) Caused by: java.sql.SQLException: Java exception: 'org.apache.derby.impl.tools.optional.ForeignDBViews: java.lang.ClassNotFoundException'. at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:101) at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java:148) at org.apache.derby.impl.jdbc.Util.javaException(Util.java:370) at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java:436) at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java:431) at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(TransactionResourceImpl.java:353) at org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java:2396) at org.apache.derby.impl.jdbc.ConnectionChild.handleException(ConnectionChild.java:85) at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1438) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(EmbedPreparedStatement.java:1695) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.execute(EmbedPreparedStatement.java:1379) at org.apache.derbyTesting.junit.BaseJDBCTestCase.assertStatementError(BaseJDBCTestCase.java:1289) ... 56 more Caused by: java.sql.SQLException: Java exception: 'org.apache.derby.impl.tools.optional.ForeignDBViews: java.lang.ClassNotFoundException'. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:42) at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(SQLExceptionFactory40.java:125) at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:71) ... 67 more Caused by: java.lang.ClassNotFoundException: org.apache.derby.impl.tools.optional.ForeignDBViews at org.apache.derby.impl.services.reflect.UpdateLoader.loadClass(UpdateLoader.java:193) at org.apache.derby.impl.services.reflect.DatabaseClasses.loadApplicationClass(DatabaseClasses.java:238) at org.apache.derby.catalog.Java5SystemProcedures.SYSCS_REGISTER_TOOL(Java5SystemProcedures.java:103) at org.apache.derby.exe.ac953a00d1x013fx7797x1333x00002e7b6a930.g0(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:48) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at org.apache.derby.impl.services.reflect.ReflectMethod.invoke(ReflectMethod.java:46) at org.apache.derby.impl.sql.execute.CallStatementResultSet.open(CallStatementResultSet.java:75) at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(GenericPreparedStatement.java:453) at org.apache.derby.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java:334) at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1346) ... 59 more FAILURES!!! Tests run: 4, Failures: 1, Errors: 1 real 0m11.326s user 0m0.015s sys 0m0.062s sh-4.1$
          Hide
          Rick Hillegas added a comment -

          Based on my 2013-06-13 comments on DERBY-6256, maybe the right thing to do is to move the foreign views and metadata wrapper tools into the engine jar.

          Show
          Rick Hillegas added a comment - Based on my 2013-06-13 comments on DERBY-6256 , maybe the right thing to do is to move the foreign views and metadata wrapper tools into the engine jar.
          Hide
          Kim Haase added a comment -

          It looks as if no action is being taken currently on moving these tools into the engine jar. So it makes sense to add the classpath information to the following topics: "SYSCS_UTIL.SYSCS_REGISTER_TOOL system procedure" (http://db.apache.org/derby/docs/10.10/ref/rrefregistertoolproc.html), "Using the databaseMetaData optional tool" (http://db.apache.org/derby/docs/10.10/tools/rtoolsoptdbmetadata.html), and "Using the foreignViews optional tool" (http://db.apache.org/derby/docs/10.10/tools/rtoolsoptforeignviews.html).

          Show
          Kim Haase added a comment - It looks as if no action is being taken currently on moving these tools into the engine jar. So it makes sense to add the classpath information to the following topics: "SYSCS_UTIL.SYSCS_REGISTER_TOOL system procedure" ( http://db.apache.org/derby/docs/10.10/ref/rrefregistertoolproc.html ), "Using the databaseMetaData optional tool" ( http://db.apache.org/derby/docs/10.10/tools/rtoolsoptdbmetadata.html ), and "Using the foreignViews optional tool" ( http://db.apache.org/derby/docs/10.10/tools/rtoolsoptforeignviews.html ).
          Hide
          Kim Haase added a comment -

          Attaching DERBY-6123.diff, DERBY-6123.stat, and DERBY-6123.zip, with changes to the following:

          M src/ref/rrefregistertoolproc.dita
          M src/tools/rtoolsoptforeignviews.dita
          M src/tools/rtoolsoptdbmetadata.dita

          Thanks in advance, Kathey, for reviewing this patch.

          Show
          Kim Haase added a comment - Attaching DERBY-6123 .diff, DERBY-6123 .stat, and DERBY-6123 .zip, with changes to the following: M src/ref/rrefregistertoolproc.dita M src/tools/rtoolsoptforeignviews.dita M src/tools/rtoolsoptdbmetadata.dita Thanks in advance, Kathey, for reviewing this patch.
          Hide
          Kathey Marsden added a comment -

          Thanks Kim, the changes look good to me.

          Show
          Kathey Marsden added a comment - Thanks Kim, the changes look good to me.
          Hide
          ASF subversion and git services added a comment -

          Commit 1526633 from Kim Haase in branch 'docs/trunk'
          [ https://svn.apache.org/r1526633 ]

          DERBY-6123 Optional tools documentation in the reference guide should mention that optional tools require derbytools.jar be in the CLASSPATH

          Added sentences to a Reference Manual topic and two Tools Guide topics.

          Patch: DERBY-6123.diff

          Show
          ASF subversion and git services added a comment - Commit 1526633 from Kim Haase in branch 'docs/trunk' [ https://svn.apache.org/r1526633 ] DERBY-6123 Optional tools documentation in the reference guide should mention that optional tools require derbytools.jar be in the CLASSPATH Added sentences to a Reference Manual topic and two Tools Guide topics. Patch: DERBY-6123 .diff
          Hide
          ASF subversion and git services added a comment -

          Commit 1526633 from Kim Haase in branch 'docs/trunk'
          [ https://svn.apache.org/r1526633 ]

          DERBY-6123 Optional tools documentation in the reference guide should mention that optional tools require derbytools.jar be in the CLASSPATH

          Added sentences to a Reference Manual topic and two Tools Guide topics.

          Patch: DERBY-6123.diff

          Show
          ASF subversion and git services added a comment - Commit 1526633 from Kim Haase in branch 'docs/trunk' [ https://svn.apache.org/r1526633 ] DERBY-6123 Optional tools documentation in the reference guide should mention that optional tools require derbytools.jar be in the CLASSPATH Added sentences to a Reference Manual topic and two Tools Guide topics. Patch: DERBY-6123 .diff
          Hide
          ASF subversion and git services added a comment -

          Commit 1526639 from Kim Haase in branch 'docs/branches/10.10'
          [ https://svn.apache.org/r1526639 ]

          DERBY-6123 Optional tools documentation in the reference guide should mention that optional tools require derbytools.jar be in the CLASSPATH

          Merged patch DERBY-6123.diff to 10.10 doc branch from trunk revision 1526633.

          Show
          ASF subversion and git services added a comment - Commit 1526639 from Kim Haase in branch 'docs/branches/10.10' [ https://svn.apache.org/r1526639 ] DERBY-6123 Optional tools documentation in the reference guide should mention that optional tools require derbytools.jar be in the CLASSPATH Merged patch DERBY-6123 .diff to 10.10 doc branch from trunk revision 1526633.
          Hide
          ASF subversion and git services added a comment -

          Commit 1526639 from Kim Haase in branch 'docs/branches/10.10'
          [ https://svn.apache.org/r1526639 ]

          DERBY-6123 Optional tools documentation in the reference guide should mention that optional tools require derbytools.jar be in the CLASSPATH

          Merged patch DERBY-6123.diff to 10.10 doc branch from trunk revision 1526633.

          Show
          ASF subversion and git services added a comment - Commit 1526639 from Kim Haase in branch 'docs/branches/10.10' [ https://svn.apache.org/r1526639 ] DERBY-6123 Optional tools documentation in the reference guide should mention that optional tools require derbytools.jar be in the CLASSPATH Merged patch DERBY-6123 .diff to 10.10 doc branch from trunk revision 1526633.
          Hide
          Kim Haase added a comment -

          Thanks very much, Kathey.

          Committed patch DERBY-6123.diff to documentation trunk at revision 1526633.
          Merged to 10.10 doc branch at revision 1526639.

          Show
          Kim Haase added a comment - Thanks very much, Kathey. Committed patch DERBY-6123 .diff to documentation trunk at revision 1526633. Merged to 10.10 doc branch at revision 1526639.
          Hide
          Kim Haase added a comment -

          Closing, since changes appeared in Latest Alpha Manuals some time ago.

          Show
          Kim Haase added a comment - Closing, since changes appeared in Latest Alpha Manuals some time ago.

            People

            • Assignee:
              Kim Haase
              Reporter:
              Kathey Marsden
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development