Hi,
We are having some issues with derby database on Z/OS.
The install is created on a HFS file system. And we create DB using this command
java -cp . -jar derbyrun.jar ij databaseAuth.sql
and databaseAuth.sql content is given below.
connect 'jdbc:derby:
/HO43/Vantagegmi/webclientdb/VantageDb';create=true;dataEncryption=true;bootPassword=Password;encryptionAlgorithm=AES/CBC/NoPadding;';
--------------------------------------------------------------------------------
-- CREATE USER_CREDENTIALS TABLE WITH PRIMARY KEY OF USERNAME
-- STEP 2
--------------------------------------------------------------------------------
CREATE TABLE USER_CREDENTIALS
(
USERNAME VARCHAR(30) NOT NULL,
PASSWORD VARCHAR(30) NOT NULL,
PRIMARY KEY (USERNAME)
);
--------------------------------------------------------------------------------
-- INSERT USER INTO USER_CREDENTIALS TABLE
-- STEP 3
--------------------------------------------------------------------------------
INSERT INTO USER_CREDENTIALS VALUES('APP', 'Password');
EXIT;
Create was successful. But when we try to connect to DB again it fails to start
with error.
----------------------------------------------------------------
2012-03-15 19:12:32.335 GMT:
Booting Derby version The Apache Software Foundation - Apache Derby - 10.5.3.0
- (802917): instance a816c00e-0136-17c6-951f-0000001a40a0
on database directory /HO43/Vantagegmi/webclientdb/VantageDb
------------ BEGIN SHUTDOWN ERROR STACK -------------
ERROR XSLA6: Cannot recover the database.
at
org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at
org.apache.derby.impl.store.raw.log.LogToFile.recover(Unknown Source)
at org.apache.derby.impl.store.raw.RawStore.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.store.access.RAMAccessManager.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.bootStore(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.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.impl.jdbc.EmbedConnection30.<init>(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedConnection40.<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:379)
at java.sql.DriverManager.getConnection(DriverManager.java:354)
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)
at org.apache.derby.iapi.tools.run.main(Unknown Source)
Caused by: java.lang.NullPointerException
at
org.apache.derby.impl.store.raw.log.Scan.getNextRecordForward(Unknown Source)
at
org.apache.derby.impl.store.raw.log.Scan.getNextRecord(Unknown Source)
at org.apache.derby.impl.store.raw.log.FileLogger.redo(Unknown
Source)
The java version we are running is
Java Version
=========
Java Virtual Machine created. Version information follows:
java version "1.6.0"
Java(TM) SE Runtime Environment (build pmz3160_26sr1-20111114_01 (SR1))
IBM J9 VM (build 2.6, JRE 1.6.0 z/OS s390-31 20111113_94967 (JIT enabled, AOT
enabled)
J9VM - R26_Java626_SR1_20111113_1649_B94967
JIT - r11_20111028_21230
GC - R26_Java626_SR1_20111113_1649_B94967
J9CL - 20111113_94967)
The os system properties are attached here.
Is this an already existing issue? Can someone help me to resolve this issue.
It happens when the tomcat server starts to use the database. But for testing
when I just used cmd line script , it fails there also.
I would really appreciate any help to resolve this issue.
Regards
Ambili
0SYSTEM PROPERTIES:
java.vendor=IBM Corporation
catalina.base=/HO43/Vantagegmi/runtime/apache-tomcat-6.0.20
catalina.useNaming=true
os.name=z/OS
sun.boot.class.path=/tfsjava/J6.0/lib/s390/default/jclSC160/vm.jar:/tfsjava/J6.0/lib/annotation.jar:/tfsjava/J6.0/lib/beans.jar:
/tfsjava/J6.0/lib/java.util.jar:/tfsjava/J6.0/lib/jndi.jar:/tfsjava/J6.0/lib/logging.jar:/tfsjava/J6.0/lib/security.jar:/tfsjava/J6.
0/lib/sql.jar:/tfsjava/J6.0/lib/ibmorb.jar:/tfsjava/J6.0/lib/ibmorbapi.jar:/tfsjava/J6.0/lib/ibmcfw.jar:/tfsjava/J6.0/lib/rt.jar:/tf
sjava/J6.0/lib/charsets.jar:/tfsjava/J6.0/lib/resources.jar:/tfsjava/J6.0/lib/ibmpkcs.jar:/tfsjava/J6.0/lib/ibmcertpathfw.jar:/tfsja
va/J6.0/lib/ibmjgssfw.jar:/tfsjava/J6.0/lib/ibmjssefw.jar:/tfsjava/J6.0/lib/ibmsaslfw.jar:/tfsjava/J6.0/lib/ibmjcefw.jar:/tfsjava/J6
.0/lib/ibmjgssprovider.jar:/tfsjava/J6.0/lib/ibmjsseprovider2.jar:/tfsjava/J6.0/lib/ibmcertpathprovider.jar:/tfsjava/J6.0/lib/manage
ment-agent.jar:/tfsjava/J6.0/lib/xml.jar:/tfsjava/J6.0/lib/jlm.jar:/tfsjava/J6.0/lib/javascript.jar:/tfsjava/J6.0/lib/RACF.jar
sun.java2d.fontpath=
java.vm.specification.vendor=Sun Microsystems Inc.
java.runtime.version=pmz3160_26sr1-20111114_01 (SR1)
jzos.launcher=true
user.name=SAMS
shared.loader=
java.compiler=j9jit26
os.encoding=ISO8859_1
tomcat.util.buf.StringCache.byte.enabled=true
com.ibm.util.extralibs.properties=
com.ibm.jcl.checkClassPath=
java.naming.factory.initial=org.apache.naming.java.javaURLContextFactory
user.language=en
com.ibm.oti.vm.bootstrap.library.path=/tfsjava/J6.0/lib/s390/default:/tfsjava/J6.0/lib/s390
sun.boot.library.path=/tfsjava/J6.0/lib/s390/default:/tfsjava/J6.0/lib/s390
java.version=1.6.0
user.timezone=America/New_York
com.ibm.system.agent.path=/tfsjava/J6.0/lib/s390
sun.arch.data.model=32
com.ibm.zero.version=2
java.endorsed.dirs=/HO43/Vantagegmi/runtime/apache-tomcat-6.0.20/common/endorsed
com.ibm.oti.vm.library.version=26
sun.jnu.encoding=IBM-1047
jxe.current.romimage.version=17
package.access=sun.,org.apache.catalina.,org.apache.coyote.,org.apache.tomcat.,org.apache.jasper.,sun.beans.
file.separator=/
java.specification.name=Java Platform API Specification
java.class.version=50.0
user.country=US
java.home=/tfsjava/J6.0
java.vm.info=JRE 1.6.0 z/OS s390-31 20111113_94967 (JIT enabled, AOT
enabled)
J9VM - R26_Java626_SR1_20111113_1649_B94967
JIT - r11_20111028_21230
GC - R26_Java626_SR1_20111113_1649_B94967
J9CL - 20111113_94967
os.version=01.13.00
ibm.serversocket.recover=true
java.awt.fonts=
path.separator=:
java.vm.version=2.6
java.util.prefs.PreferencesFactory=java.util.prefs.FileSystemPreferencesFactory
user.variant=
java.awt.printerjob=sun.print.PSPrinterJob
sun.io.unicode.encoding=UnicodeBig
awt.toolkit=sun.awt.X11.XToolkit
ibm.signalhandling.sigint=true
java.assistive=ON
package.definition=sun.,java.,org.apache.catalina.,org.apache.coyote.,org.apache.tomcat.,org.apache.jasper.
java.naming.factory.url.pkgs=org.apache.naming
user.home=/HO43/tmp
com.ibm.cpu.endian=big
java.specification.vendor=Sun Microsystems Inc.
ibm.signalhandling.sigchain=false
sun.security.policy.utf8=false
java.library.path=/tfsjava/J6.0/lib/s390/default:/tfsjava/J6.0/lib/s390:/tfsjava/J6.0/lib/s390/default:/lib:/usr/lib:/tfsjava/J6
.0/bin:/tfsjava/J6.0/bin/classic::/tfsjava/J6.0/lib/s390/default:/tfsjava/J6.0/lib/s390
java.vendor.url=http://www.ibm.com/
java.vm.vendor=IBM Corporation
platform.notASCII=true
common.loader=${catalina.home}/lib,${catalina.home}/lib/*.jar
java.fullversion=JRE 1.6.0 IBM J9 2.6 z/OS s390-31 20111113_94967 (JIT
enabled, AOT enabled)
J9VM - R26_Java626_SR1_20111113_1649_B94967
JIT - r11_20111028_21230
GC - R26_Java626_SR1_20111113_1649_B94967
J9CL - 20111113_94967
java.runtime.name=Java(TM) SE Runtime Environment
java.class.path=/tfsjava/J6.0/lib/tools.jar:/HO43/Vantagegmi/runtime/apache-tomcat-6.0.20/bin/bootstrap.jar:/HO43/Vantagegmi/run
time/apache-tomcat-6.0.20/bin/commons-logging-api.jar:
java.vm.specification.name=Java Virtual Machine Specification
java.vm.specification.version=1.0
catalina.home=/HO43/Vantagegmi/runtime/apache-tomcat-6.0.20
sun.cpu.endian=big
java.awt.headless=false
java.io.tmpdir=/HO43/Vantagegmi/runtime/apache-tomcat-6.0.20/temp
java.jcl.version=20111112_01
server.loader=
ibm.system.encoding=IBM-1047
os.arch=s390
java.awt.graphicsenv=sun.awt.X11GraphicsEnvironment
ibm.signalhandling.rs=false
java.ext.dirs=/tfsjava/J6.0/lib/ext
user.dir=/HO43/tmp
line.separator=
0 java.vm.name=IBM J9 VM
com.ibm.oti.shared.enabled=false
com.ibm.vm.bitmode=32
jxe.lowest.romimage.version=17
file.encoding=ISO8859-1
com.ibm.oti.jcl.build=20111113_94967
java.specification.version=1.6
com.ibm.oti.configuration=scar
vantage.log.dir=/HO43/Vantagegmi/runtime/apache-tomcat-6.0.20/logs
