Thanks Peter.

Do you remember if you upgraded to 10.8.2.2 or 10.8.1.2? We do have a test environment with 10.8.1.2, and are seeing similar results. I do agree that it seems to be a strange coexistence with Derby and J9. The IBM Classic JVM doesn't seem to have this issue, although IBM seems to have eliminated it in V7R1M0.

Mon Mar 19 12:46:40 EDT 2012 : Apache Derby Network Server - 10.8.1.2 - (1095077) started and ready to accept connections on port 11527
Mon Mar 19 12:46:44 EDT 2012 : Connection number: 1.
----------------------------------------------------------------
Mon Mar 19 12:46:45 EDT 2012:
Shutting down instance a816c00e-0136-2bda-791f-ffffcab24f1a on database directory /database with class loader sun.misc.Launcher$AppClassLoader@376a376a 
Mon Mar 19 12:46:45 EDT 2012 Thread[DRDAConnThread_11,10,main] Cleanup action starting
java.lang.NullPointerException
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.stop(Unknown Source)
at org.apache.derby.impl.services.monitor.TopService.stop(Unknown Source)
at org.apache.derby.impl.services.monitor.TopService.shutdown(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.startProviderService(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndStartService(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentService(Unknown Source)
at org.apache.derby.iapi.services.monitor.Monitor.startPersistentService(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(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 org.apache.derby.impl.drda.Database.makeConnection(Unknown Source)
at org.apache.derby.impl.drda.DRDAConnThread.getConnFromDatabaseName(Unknown Source)
at org.apache.derby.impl.drda.DRDAConnThread.verifyUserIdPassword(Unknown Source)
at org.apache.derby.impl.drda.DRDAConnThread.parseSECCHK(Unknown Source)
at org.apache.derby.impl.drda.DRDAConnThread.parseDRDAConnection(Unknown Source)
at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown Source)
at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
Cleanup action completed
Mon Mar 19 12:46:45 EDT 2012 Thread[DRDAConnThread_11,10,main] Cleanup action starting
java.lang.NullPointerException
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.stop(Unknown Source)
at org.apache.derby.impl.services.monitor.TopService.stop(Unknown Source)
at org.apache.derby.impl.services.monitor.TopService.shutdown(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.startProviderService(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndStartService(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentService(Unknown Source)
at org.apache.derby.iapi.services.monitor.Monitor.startPersistentService(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(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 org.apache.derby.impl.drda.Database.makeConnection(Unknown Source)
at org.apache.derby.impl.drda.DRDAConnThread.getConnFromDatabaseName(Unknown Source)
at org.apache.derby.impl.drda.DRDAConnThread.verifyUserIdPassword(Unknown Source)
at org.apache.derby.impl.drda.DRDAConnThread.parseSECCHK(Unknown Source)
at org.apache.derby.impl.drda.DRDAConnThread.parseDRDAConnection(Unknown Source)
at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown Source)
at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
Cleanup action completed
Mon Mar 19 12:46:45 EDT 2012 Thread[DRDAConnThread_11,10,main] (DATABASE = /database), (DRDAID = {1}), Java exception: ': java.lang.NullPointerException'.
Mon Mar 19 12:46:47 EDT 2012 : Connection number: 2.
----------------------------------------------------------------
Mon Mar 19 12:46:47 EDT 2012: Shutting down Derby engine
Mon Mar 19 12:46:47 EDT 2012 : Unexpected exception:
 {0}
Mon Mar 19 12:46:47 EDT 2012 : null
java.lang.NullPointerException
at org.apache.derby.impl.services.monitor.TopService.getService(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.shutdown(Unknown Source)
at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source)
at org.apache.derby.impl.drda.NetworkServerControlImpl.blockingStart(Unknown Source)
at org.apache.derby.impl.drda.NetworkServerControlImpl.executeWork(Unknown Source)
at org.apache.derby.drda.NetworkServerControl.main(Unknown Source)
Mon Mar 19 12:46:47 EDT 2012 : Apache Derby Network Server - 10.8.1.2 - (1095077) shutdown


On Mon, Mar 19, 2012 at 12:12 PM, Peter Ondruška <peter.ondruska+derby@kaibo.eu> wrote:
I have seen the same problem and resolved by upgrading Derby to 10.8.
There must be something strange in J9 and Derby coexistence. This
happened very random.

On Mon, Mar 19, 2012 at 4:55 PM, Brandon L. Duncan
<brandonl.duncan@gmail.com> wrote:
> I was wondering if anyone came across this error before while attempting to
> establish a connection to Derby? The database seems to boot fine, but when a
> connection is attempted it just bombs out. It also is not
> always reproducible, as at times it will be fine, other times it errors with
> the exception below. The JVM is IBM's J9 implementation. I know Derby
> 10.4.2.0 is a wee bit old, but upgrading this instance would not be easy at
> this point.
>
> java version "1.6.0"
>
> Java(TM) SE Runtime Environment (build
> pap3260sr9ifix-20110211_02(SR9+IZ94423))
>
> IBM J9 VM (build 2.4, JRE 1.6.0 IBM J9 2.4 OS/400 ppc-32
> jvmap3260sr9-20101130 (JIT enabled, AOT enabled)
>
> J9VM - 20101124_069295
>
> JIT  - r9_20101028_17488ifx2
>
> GC   - 20101027_AA)
>
> JCL  - 20101119_01
>
>
> Derby Log:
>
> Apache Derby Network Server - 10.4.2.0 - (689064) started and ready to
> accept connections on port 1555 at 2012-03-15 13:27:29.860 GMT
> Connection number: 1.
>
> 2012-03-15 13:27:34.382 GMT:
> Shutting down instance a816c00e-0136-168a-b0de-ffffd934f54c
> ----------------------------------------------------------------
> 2012-03-15 13:27:34.384 GMT Thread[DRDAConnThread_11,5,main] Cleanup action
> starting
> java.lang.NullPointerException
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.stop(Unknown
> Source)
> at org.apache.derby.impl.services.monitor.TopService.stop(Unknown Source)
> at org.apache.derby.impl.services.monitor.TopService.shutdown(Unknown
> Source)
> at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Unknown
> Source)
> at
> org.apache.derby.impl.services.monitor.BaseMonitor.startProviderService(Unknown
> Source)
> at
> org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndStartService(Unknown
> Source)
> at
> org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentService(Unknown
> Source)
> at
> org.apache.derby.iapi.services.monitor.Monitor.startPersistentService(Unknown
> Source)
> at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(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 org.apache.derby.impl.drda.Database.makeConnection(Unknown Source)
> at org.apache.derby.impl.drda.DRDAConnThread.getConnFromDatabaseName(Unknown
> Source)
> at org.apache.derby.impl.drda.DRDAConnThread.verifyUserIdPassword(Unknown
> Source)
> at org.apache.derby.impl.drda.DRDAConnThread.parseSECCHK(Unknown Source)
> at org.apache.derby.impl.drda.DRDAConnThread.parseDRDAConnection(Unknown
> Source)
> at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown Source)
> at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
> Cleanup action completed
> 2012-03-15 13:27:34.385 GMT Thread[DRDAConnThread_11,5,main] Cleanup action
> starting
> java.lang.NullPointerException
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.stop(Unknown
> Source)
> at org.apache.derby.impl.services.monitor.TopService.stop(Unknown Source)
> at org.apache.derby.impl.services.monitor.TopService.shutdown(Unknown
> Source)
> at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Unknown
> Source)
> at
> org.apache.derby.impl.services.monitor.BaseMonitor.startProviderService(Unknown
> Source)
> at
> org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndStartService(Unknown
> Source)
> at
> org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentService(Unknown
> Source)
> at
> org.apache.derby.iapi.services.monitor.Monitor.startPersistentService(Unknown
> Source)
> at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(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 org.apache.derby.impl.drda.Database.makeConnection(Unknown Source)
> at org.apache.derby.impl.drda.DRDAConnThread.getConnFromDatabaseName(Unknown
> Source)
> at org.apache.derby.impl.drda.DRDAConnThread.verifyUserIdPassword(Unknown
> Source)
> at org.apache.derby.impl.drda.DRDAConnThread.parseSECCHK(Unknown Source)
> at org.apache.derby.impl.drda.DRDAConnThread.parseDRDAConnection(Unknown
> Source)
> at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown Source)
> at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
> Cleanup action completed
> 2012-03-15 13:27:34.388 GMT Thread[DRDAConnThread_11,5,main] (DATABASE =
> ../../database), (DRDAID = {1}), Java exception: ':
> java.lang.NullPointerException'.
> Connection number: 2.
>
> Thanks for any feedback.