Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-5431

If 10.7 or greater derbyclient.jar is in the classpath before an older release's server jars, derby fails to boot with NoSuchFieldError for JVMInfo.JAVA_SQL_TYPES_BOOLEAN

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Critical
        • Resolution: Fixed
        • Affects Version/s: 10.7.1.1, 10.8.1.2, 10.9.1.0
        • Fix Version/s: 10.8.2.2, 10.9.1.0
        • Component/s: JDBC
        • Labels:
          None
        • Issue & fix info:
          High Value Fix
        • Bug behavior facts:
          Crash, Regression

          Description

          I noticed if 10.8 derbyclient.jar is before the 10.5 server jars, DERBY fails to boot with the error below. I think this field was removed in 10.7 so most like affects 10.7 as well. The root cause is DERBY-1046, but I am filing a separate issue for this specific case. This issue is currently blocking testing with 10.8 client and 10.5 server.

          $ java -Dij.exceptionTrace=true org.apache.derby.tools.ij
          ij version 10.5
          ij> connect 'jdbc:derby:wombat;create=true';
          ERROR XJ041: Failed to create database 'wombat', see the next exception for details.
          java.sql.SQLException: Failed to create database 'wombat', see the next exception for details.
          at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
          at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
          at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source)
          at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(Unknown Source)
          at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
          at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Source)
          at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
          at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source)
          at java.sql.DriverManager.getConnection(DriverManager.java:322)
          at java.sql.DriverManager.getConnection(DriverManager.java:297)
          at org.apache.derby.impl.tools.ij.ij.dynamicConnection(Unknown Source)
          at org.apache.derby.impl.tools.ij.ij.ConnectStatement(Unknown Source)
          at org.apache.derby.impl.tools.ij.ij.ijStatement(Unknown Source)
          at org.apache.derby.impl.tools.ij.utilMain.runScriptGuts(Unknown Source)
          at org.apache.derby.impl.tools.ij.utilMain.go(Unknown Source)
          at org.apache.derby.impl.tools.ij.Main.go(Unknown Source)
          at org.apache.derby.impl.tools.ij.Main.mainCore(Unknown Source)
          at org.apache.derby.impl.tools.ij.Main.main(Unknown Source)
          at org.apache.derby.tools.ij.main(Unknown Source)
          Caused by: java.sql.SQLException: Failed to create database 'wombat', see the next exception for details.
          at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
          at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
          ... 19 more
          Caused by: java.sql.SQLException: Startup failed due to an exception. See next exception for details.
          at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
          at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
          at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
          at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
          at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source)
          at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
          at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
          at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
          ... 16 more
          Caused by: java.sql.SQLException: Java exception: 'org/apache/derby/iapi/services/info/JVMInfo.JAVA_SQL_TYPES_BOOLEAN: java.lang.NoSuchFieldError'.
          at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
          at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
          at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
          at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
          at org.apache.derby.impl.jdbc.Util.javaException(Unknown Source)
          at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
          ... 19 more
          Caused by: java.lang.NoSuchFieldError: org/apache/derby/iapi/services/info/JVMInfo.JAVA_SQL_TYPES_BOOLEAN
          at org.apache.derby.catalog.types.BaseTypeIdImpl.setTypeIdSpecificInstanceVariables(Unknown Source)
          at org.apache.derby.catalog.types.BaseTypeIdImpl.<init>(Unknown Source)
          at org.apache.derby.iapi.types.TypeId.create(Unknown Source)
          at org.apache.derby.iapi.types.TypeId.<clinit>(Unknown Source)
          at java.lang.J9VMInternals.initializeImpl(Native Method)
          at java.lang.J9VMInternals.initialize(J9VMInternals.java:200)
          at org.apache.derby.iapi.types.DataValueFactoryImpl.boot(Unknown Source)
          at org.apache.derby.iapi.types.J2SEDataValueFactory.boot(Unknown Source)
          at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source)
          at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source)
          at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown Source)
          at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown Source)
          at org.apache.derby.impl.db.BasicDatabase.boot(Unknown Source)
          at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source)
          at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source)
          at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Unknown Source)
          at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(Unknown Source)
          at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Unknown Source)
          ... 16 more
          ERROR XBM01: Startup failed due to an exception. See next exception for details.
          java.sql.SQLException: Startup failed due to an exception. See next exception for details.
          at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
          at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
          at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source)
          at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
          at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
          at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
          at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(Unknown Source)
          at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
          at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Source)
          at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
          at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source)
          at java.sql.DriverManager.getConnection(DriverManager.java:322)
          at java.sql.DriverManager.getConnection(DriverManager.java:297)
          at org.apache.derby.impl.tools.ij.ij.dynamicConnection(Unknown Source)
          at org.apache.derby.impl.tools.ij.ij.ConnectStatement(Unknown Source)
          at org.apache.derby.impl.tools.ij.ij.ijStatement(Unknown Source)
          at org.apache.derby.impl.tools.ij.utilMain.runScriptGuts(Unknown Source)
          at org.apache.derby.impl.tools.ij.utilMain.go(Unknown Source)
          at org.apache.derby.impl.tools.ij.Main.go(Unknown Source)
          at org.apache.derby.impl.tools.ij.Main.mainCore(Unknown Source)
          at org.apache.derby.impl.tools.ij.Main.main(Unknown Source)
          at org.apache.derby.tools.ij.main(Unknown Source)
          Caused by: java.sql.SQLException: Startup failed due to an exception. See next exception for details.
          at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
          at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
          ... 22 more
          Caused by: java.sql.SQLException: Java exception: 'org/apache/derby/iapi/services/info/JVMInfo.JAVA_SQL_TYPES_BOOLEAN: java.lang.NoSuchFieldError'.
          at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
          at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
          at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
          at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
          at org.apache.derby.impl.jdbc.Util.javaException(Unknown Source)
          at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
          ... 19 more
          Caused by: java.lang.NoSuchFieldError: org/apache/derby/iapi/services/info/JVMInfo.JAVA_SQL_TYPES_BOOLEAN
          at org.apache.derby.catalog.types.BaseTypeIdImpl.setTypeIdSpecificInstanceVariables(Unknown Source)
          at org.apache.derby.catalog.types.BaseTypeIdImpl.<init>(Unknown Source)
          at org.apache.derby.iapi.types.TypeId.create(Unknown Source)
          at org.apache.derby.iapi.types.TypeId.<clinit>(Unknown Source)
          at java.lang.J9VMInternals.initializeImpl(Native Method)
          at java.lang.J9VMInternals.initialize(J9VMInternals.java:200)
          at org.apache.derby.iapi.types.DataValueFactoryImpl.boot(Unknown Source)
          at org.apache.derby.iapi.types.J2SEDataValueFactory.boot(Unknown Source)
          at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source)
          at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source)
          at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown Source)
          at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown Source)
          at org.apache.derby.impl.db.BasicDatabase.boot(Unknown Source)
          at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source)
          at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source)
          at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Unknown Source)
          at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(Unknown Source)
          at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Unknown Source)
          ... 16 more
          ERROR XJ001: Java exception: 'org/apache/derby/iapi/services/info/JVMInfo.JAVA_SQL_TYPES_BOOLEAN: java.lang.NoSuchFieldError'.
          java.sql.SQLException: Java exception: 'org/apache/derby/iapi/services/info/JVMInfo.JAVA_SQL_TYPES_BOOLEAN: java.lang.NoSuchFieldError'.
          at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
          at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
          at org.apache.derby.impl.jdbc.Util.javaException(Unknown Source)
          at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
          at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
          at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
          at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
          at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(Unknown Source)
          at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
          at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Source)
          at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
          at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source)
          at java.sql.DriverManager.getConnection(DriverManager.java:322)
          at java.sql.DriverManager.getConnection(DriverManager.java:297)
          at org.apache.derby.impl.tools.ij.ij.dynamicConnection(Unknown Source)
          at org.apache.derby.impl.tools.ij.ij.ConnectStatement(Unknown Source)
          at org.apache.derby.impl.tools.ij.ij.ijStatement(Unknown Source)
          at org.apache.derby.impl.tools.ij.utilMain.runScriptGuts(Unknown Source)
          at org.apache.derby.impl.tools.ij.utilMain.go(Unknown Source)
          at org.apache.derby.impl.tools.ij.Main.go(Unknown Source)
          at org.apache.derby.impl.tools.ij.Main.mainCore(Unknown Source)
          at org.apache.derby.impl.tools.ij.Main.main(Unknown Source)
          at org.apache.derby.tools.ij.main(Unknown Source)
          Caused by: java.sql.SQLException: Java exception: 'org/apache/derby/iapi/services/info/JVMInfo.JAVA_SQL_TYPES_BOOLEAN: java.lang.NoSuchFieldError'.
          at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
          at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
          ... 23 more
          Caused by: java.lang.NoSuchFieldError: org/apache/derby/iapi/services/info/JVMInfo.JAVA_SQL_TYPES_BOOLEAN
          at org.apache.derby.catalog.types.BaseTypeIdImpl.setTypeIdSpecificInstanceVariables(Unknown Source)
          at org.apache.derby.catalog.types.BaseTypeIdImpl.<init>(Unknown Source)
          at org.apache.derby.iapi.types.TypeId.create(Unknown Source)
          at org.apache.derby.iapi.types.TypeId.<clinit>(Unknown Source)
          at java.lang.J9VMInternals.initializeImpl(Native Method)
          at java.lang.J9VMInternals.initialize(J9VMInternals.java:200)
          at org.apache.derby.iapi.types.DataValueFactoryImpl.boot(Unknown Source)
          at org.apache.derby.iapi.types.J2SEDataValueFactory.boot(Unknown Source)
          at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source)
          at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source)
          at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown Source)
          at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown Source)
          at org.apache.derby.impl.db.BasicDatabase.boot(Unknown Source)
          at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source)
          at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source)
          at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Unknown Source)
          at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(Unknown Source)
          at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Unknown Source)
          ... 16 more
          ij>

            Issue Links

            is related to

            Bug - A problem which impairs or prevents the functions of the product. DERBY-1046 JVMInfo is duplicated in derbyclient.jar

            • Minor - Minor loss of function, or other problem where easy workaround is present.
            • Closed

              Activity

              Ascending order - Click to sort in descending order
              Hide
              Permalink
              rhillegas Rick Hillegas added a comment -

              This issue was discussed on derby-dev in the following thread: http://old.nabble.com/More.-Trouble-with-JVMInfo-to32526102.html

              Show
              rhillegas Rick Hillegas added a comment - This issue was discussed on derby-dev in the following thread: http://old.nabble.com/More.-Trouble-with-JVMInfo-to32526102.html
              Hide
              Permalink
              knutanders Knut Anders Hatlen added a comment -

              [bulk update] Close all resolved issues that haven't been updated for more than one year.

              Show
              knutanders Knut Anders Hatlen added a comment - [bulk update] Close all resolved issues that haven't been updated for more than one year.

                People

                • Assignee:
                  kmarsden Kathey Marsden
                  Reporter:
                  kmarsden Kathey Marsden
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  1 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Development