Database cannot to started
--------------------------
Key: DERBY-5676
URL: https://issues.apache.org/jira/browse/DERBY-5676
Project: Derby
Issue Type: Bug
Components: Tools
Affects Versions: 10.5.3.0
Environment: Operating System: Z/OS version
These are some of the OS properties.
0SYSTEM PROPERTIES:
java.vendor=IBM Corporation
os.name=z/OS
java.vm.specification.vendor=Sun Microsystems Inc.
java.runtime.version=pmz3160_26sr1-20111114_01 (SR1)
user.language=en
java.version=1.6.0
user.timezone=America/New_York
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
sun.cpu.endian=big
ibm.system.encoding=IBM-1047
os.arch=s390
java.vm.name=IBM J9 VM
com.ibm.oti.shared.enabled=false
com.ibm.vm.bitmode=32
file.encoding=ISO8859-1
Reporter: Ambili
Priority: Blocker
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.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
