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>

              Attachments

                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

                    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: