You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Ambili (Created) (JIRA)" <ji...@apache.org> on 2012/03/28 22:23:25 UTC
[jira] [Created] (DERBY-5676) Database cannot to started
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
[jira] [Commented] (DERBY-5676) Database cannot to started
Posted by "Stan Bradbury (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5676?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13271987#comment-13271987 ]
Stan Bradbury commented on DERBY-5676:
--------------------------------------
I don't see where the issue of whether this file system mount utilizes network software or not. I am focusing on the corruption aspect alone, not encryption plays a part. I found the followin reference at:
http://publib.boulder.ibm.com/infocenter/zos/basics/index.jsp?topic=/com.ibm.zos.zconcepts/zconcepts_177.htm
TITLE: z/OS concepts:
Some of these are network mounts
You can use the following file system types with z/OS UNIX:
zSeries® File System (zFS), which is a file system that stores files in VSAM linear data sets.
Hierarchical file system (HFS), a mountable file system, which is being phased out by zFS.
z/OS Network File System (z/OS NFS), which allows a z/OS system to access a remote UNIX (z/OS or non-z/OS) file system over TCP/IP, as if it were part of the local z/OS directory tree.
Temporary file system (TFS), which is a temporary, in-memory physical file system that supports in-storage mountable file systems.
> 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
> Attachments: db.pax.Z, db.tar, db.tar, derby.log, scriptinascii.zip, scripts.tar
>
>
> 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: /HO4/test/testDb;create=true;dataEncryption=true;bootPassword=Password;encryptionAlgorithm=AES/CBC/NoPadding;';
> --------------------------------------------------------------------------------
> -- CREATE TESTTABLE TABLE WITH PRIMARY KEY OF USERNAME
> -- STEP 2
> --------------------------------------------------------------------------------
> CREATE TABLE TESTTABLE
> (
> USERNAME VARCHAR(30) NOT NULL,
> PASSWORD VARCHAR(30) NOT NULL,
> PRIMARY KEY (USERNAME)
> );
> --------------------------------------------------------------------------------
> -- INSERT USER INTO TESTTABLE TABLE
> -- STEP 3
> --------------------------------------------------------------------------------
> INSERT INTO TESTTABLE VALUES('<adminuser>', '<adminpass>');
> 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
[jira] [Commented] (DERBY-5676) Database cannot to started
Posted by "Myrna van Lunteren (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5676?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13245380#comment-13245380 ]
Myrna van Lunteren commented on DERBY-5676:
-------------------------------------------
I thought I had seen before that you said this worked on another system, but couldn't find that comment again.
How many z/OS systems do you have access to? Is this one the only one where you see this failure?
Kathey has tried your script on a z/OS system (with a slightly different jvm version) and it worked fine there too.
It seems indicated that there is a difference between this system and the other one, or things would work the same way. We need to find that difference to move forward.
Things I can think of that might be relevant:
- permissions/rights for the user running the script
- file permissions (read/write) after creation of the database between the two systems
- type file system
- jvm version
- OS version
- path settings for the user running the script
- other derby installations present?
Double checking these settings are the same on the two systems would be helpful.
HTH
Myrna
> 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
> Attachments: db.pax.Z, db.tar, db.tar, derby.log, scriptinascii.zip, scripts.tar
>
>
> 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
[jira] [Commented] (DERBY-5676) Database cannot to started
Posted by "Kathey Marsden (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5676?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13255011#comment-13255011 ]
Kathey Marsden commented on DERBY-5676:
---------------------------------------
I got some information on checking the hardware and also disabling z196 specific optimization if needed.
uname -Iarns shows a four digit number:
2817 is z196
2097 is z10
2094 is z9
-Xjit:disableZGryphon disables z196 specific JIT optimizations.
I don't actually think this is jit as it is not iterative but just putting that info here for completeness.
> 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
> Attachments: db.pax.Z, db.tar, db.tar, derby.log, scriptinascii.zip, scripts.tar
>
>
> 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
[jira] [Commented] (DERBY-5676) Database cannot to started
Posted by "Ambili (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5676?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13244947#comment-13244947 ]
Ambili commented on DERBY-5676:
-------------------------------
Mike,
The issue is not with ebcidic format since the same script work on other system.
The script ran is RunScript.sh which creates a DB at the user given path and does a backup of the db and then query the DB. You can check the script.out file in the attached zip to get the output of ij command.
regards
Ambili
> 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
> Attachments: db.pax.Z, db.tar, db.tar, derby.log, scriptinascii.zip, scripts.tar
>
>
> 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
[jira] [Updated] (DERBY-5676) Database cannot to started
Posted by "Ambili (Updated) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5676?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ambili updated DERBY-5676:
--------------------------
Attachment: db.tar
The db.tar contains VantageDb and VantageDb1. This is the output of the RunScript.sh from the scripts.tar
VantageDb1 is the backed up DB after the creation
VantageDb is the DB after DBQuery.sh is ran
> 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
> Attachments: db.pax.Z, db.tar, db.tar, derby.log, scripts.tar
>
>
> 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
[jira] [Updated] (DERBY-5676) Database cannot to started
Posted by "Ambili (Updated) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5676?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ambili updated DERBY-5676:
--------------------------
Attachment: scripts.tar
> 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
> Attachments: db.pax.Z, db.tar, derby.log, scripts.tar
>
>
> 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
[jira] [Updated] (DERBY-5676) Cannot connect to AES encrypted
database with IBMJCECCA provider
Posted by "Knut Anders Hatlen (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5676?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Knut Anders Hatlen updated DERBY-5676:
--------------------------------------
Component/s: (was: Tools)
Services
Urgency: Normal (was: Urgent)
Labels: derby_triage10_10 (was: )
Summary: Cannot connect to AES encrypted database with IBMJCECCA provider (was: Database cannot to started)
Adjusted fields for the 10.10 bug triage:
- Clarified summary
- Reset urgency to Normal
- Changed component from Tools to Services
> Cannot connect to AES encrypted database with IBMJCECCA provider
> ----------------------------------------------------------------
>
> Key: DERBY-5676
> URL: https://issues.apache.org/jira/browse/DERBY-5676
> Project: Derby
> Issue Type: Bug
> Components: Services
> 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
> Labels: derby_triage10_10
> Attachments: db.pax.Z, db.tar, db.tar, derby.log, scriptinascii.zip, scripts.tar
>
>
> 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: /HO4/test/testDb;create=true;dataEncryption=true;bootPassword=Password;encryptionAlgorithm=AES/CBC/NoPadding;';
> --------------------------------------------------------------------------------
> -- CREATE TESTTABLE TABLE WITH PRIMARY KEY OF USERNAME
> -- STEP 2
> --------------------------------------------------------------------------------
> CREATE TABLE TESTTABLE
> (
> USERNAME VARCHAR(30) NOT NULL,
> PASSWORD VARCHAR(30) NOT NULL,
> PRIMARY KEY (USERNAME)
> );
> --------------------------------------------------------------------------------
> -- INSERT USER INTO TESTTABLE TABLE
> -- STEP 3
> --------------------------------------------------------------------------------
> INSERT INTO TESTTABLE VALUES('<adminuser>', '<adminpass>');
> 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
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (DERBY-5676) Database cannot to started
Posted by "Ambili (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5676?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ambili updated DERBY-5676:
--------------------------
Comment: was deleted
(was: Hi Mike,
Before creating DB, the /HO43/Vantagegmi/webclientdb/VantageDb did not exist. I have attached the scripts that we used to create and query the DB.
I will run the test with no encryption and let you know. We did not try any other encryption.
regards
Ambili)
> 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
> Attachments: db.pax.Z, db.tar, db.tar, derby.log, scriptinascii.zip, scripts.tar
>
>
> 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: /HO4/test/testDb;create=true;dataEncryption=true;bootPassword=Password;encryptionAlgorithm=AES/CBC/NoPadding;';
> --------------------------------------------------------------------------------
> -- CREATE TESTTABLE TABLE WITH PRIMARY KEY OF USERNAME
> -- STEP 2
> --------------------------------------------------------------------------------
> CREATE TABLE TESTTABLE
> (
> USERNAME VARCHAR(30) NOT NULL,
> PASSWORD VARCHAR(30) NOT NULL,
> PRIMARY KEY (USERNAME)
> );
> --------------------------------------------------------------------------------
> -- INSERT USER INTO TESTTABLE TABLE
> -- STEP 3
> --------------------------------------------------------------------------------
> INSERT INTO TESTTABLE VALUES('<adminuser>', '<adminpass>');
> 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
[jira] [Commented] (DERBY-5676) Database cannot to started
Posted by "Ambili (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5676?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13244949#comment-13244949 ]
Ambili commented on DERBY-5676:
-------------------------------
Mike,
The issue is not with ebcidic format since the same script work on other system.
The script ran is RunScript.sh which creates a DB at the user given path and does a backup of the db and then query the DB. You can check the script.out file in the attached zip to get the output of ij command.
regards
Ambili
> 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
> Attachments: db.pax.Z, db.tar, db.tar, derby.log, scriptinascii.zip, scripts.tar
>
>
> 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
[jira] [Commented] (DERBY-5676) Database cannot to started
Posted by "Ambili (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5676?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13402548#comment-13402548 ]
Ambili commented on DERBY-5676:
-------------------------------
is there any update on this issue? We were able to get this resolved by not using encryption.
Is there any workaround I can do to still use encruption but not have the error we were getting?
Ambili
> 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
> Attachments: db.pax.Z, db.tar, db.tar, derby.log, scriptinascii.zip, scripts.tar
>
>
> 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: /HO4/test/testDb;create=true;dataEncryption=true;bootPassword=Password;encryptionAlgorithm=AES/CBC/NoPadding;';
> --------------------------------------------------------------------------------
> -- CREATE TESTTABLE TABLE WITH PRIMARY KEY OF USERNAME
> -- STEP 2
> --------------------------------------------------------------------------------
> CREATE TABLE TESTTABLE
> (
> USERNAME VARCHAR(30) NOT NULL,
> PASSWORD VARCHAR(30) NOT NULL,
> PRIMARY KEY (USERNAME)
> );
> --------------------------------------------------------------------------------
> -- INSERT USER INTO TESTTABLE TABLE
> -- STEP 3
> --------------------------------------------------------------------------------
> INSERT INTO TESTTABLE VALUES('<adminuser>', '<adminpass>');
> 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
[jira] [Updated] (DERBY-5676) Database cannot to started
Posted by "Ambili (Updated) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5676?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ambili updated DERBY-5676:
--------------------------
Attachment: scriptinascii.zip
I am attaching the same scripts and output of the scripts in Ascii format for reading on windows
> 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
> Attachments: db.pax.Z, db.tar, db.tar, derby.log, scriptinascii.zip, scripts.tar
>
>
> 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
[jira] [Updated] (DERBY-5676) Database cannot to started
Posted by "Ambili (Updated) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5676?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ambili updated DERBY-5676:
--------------------------
Comment: was deleted
(was: Mike,
The issue is not with ebcidic format since the same script work on other system.
The script ran is RunScript.sh which creates a DB at the user given path and does a backup of the db and then query the DB. You can check the script.out file in the attached zip to get the output of ij command.
regards
Ambili)
> 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
> Attachments: db.pax.Z, db.tar, db.tar, derby.log, scriptinascii.zip, scripts.tar
>
>
> 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
[jira] [Commented] (DERBY-5676) Database cannot to started
Posted by "Kathey Marsden (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5676?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13252464#comment-13252464 ]
Kathey Marsden commented on DERBY-5676:
---------------------------------------
Ambili,
I have just been working on another issue, DERBY-5685 which seems to be specific to z196 and won't reproduce on my z10 system. Do you have z196 or z10?
> 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
> Attachments: db.pax.Z, db.tar, db.tar, derby.log, scriptinascii.zip, scripts.tar
>
>
> 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
[jira] [Updated] (DERBY-5676) Database cannot to started
Posted by "Ambili (Updated) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5676?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ambili updated DERBY-5676:
--------------------------
Attachment: derby.log
> 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
> Attachments: derby.log
>
>
> 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
[jira] [Commented] (DERBY-5676) Database cannot to started
Posted by "Mike Matrigali (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5676?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13242923#comment-13242923 ]
Mike Matrigali commented on DERBY-5676:
---------------------------------------
do you get same problems if you don't use encryption?
do you get same problem with other types of encryption?
Can you verify that /HO43/Vantagegmi/webclientdb/VantageDb directory does not exist before running the create script?
> 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
> Attachments: db.pax.Z, db.tar, derby.log
>
>
> 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
[jira] [Issue Comment Edited] (DERBY-5676) Database cannot to
started
Posted by "Ambili (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5676?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13240785#comment-13240785 ]
Ambili edited comment on DERBY-5676 at 5/5/12 8:45 PM:
-------------------------------------------------------
First i was trying to connect from tomcat. But later we tried creating a sample database ( attached here) and tried to connect using ij tool.
This is what is used to test the connection using ij tool. the Sql file to used in ij tool is
connect 'jdbc:derby:/HO43/test/testDb;dataEncryption=true;bootPassword=<password>;encryptionAlgorithm=AES/CBC/NoPadding;';
SELECT * FROM TESTTABLE;
And sorry about the typo in the old post. The create query is
connect 'jdbc:derby:/HO43/test/testDb;create=true;dataEncryption=true;bootPassword=<password>;encryptionAlgorithm=AES/CBC/NoPadding;';
was (Author: ambili):
First i was trying to connect from tomcat. But later we tried creating a sample database ( attached here) and tried to connect using ij tool.
This is what is used to test the connection using ij tool. the Sql file to used in ij tool is
connect 'jdbc:derby:/HO43/Vantagegmi/webclientdb/VantageDb;dataEncryption=true;bootPassword=<password>;encryptionAlgorithm=AES/CBC/NoPadding;';
SELECT * FROM USER_CREDENTIALS ;
And sorry about the typo in the old post. The create query is
connect 'jdbc:derby:/HO43/Vantagegmi/webclientdb/VantageDb;create=true;dataEncryption=true;bootPassword=<password>;encryptionAlgorithm=AES/CBC/NoPadding;';
> 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
> Attachments: db.pax.Z, db.tar, db.tar, derby.log, scriptinascii.zip, scripts.tar
>
>
> 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: /HO4/test/testDb;create=true;dataEncryption=true;bootPassword=Password;encryptionAlgorithm=AES/CBC/NoPadding;';
> --------------------------------------------------------------------------------
> -- CREATE TESTTABLE TABLE WITH PRIMARY KEY OF USERNAME
> -- STEP 2
> --------------------------------------------------------------------------------
> CREATE TABLE TESTTABLE
> (
> USERNAME VARCHAR(30) NOT NULL,
> PASSWORD VARCHAR(30) NOT NULL,
> PRIMARY KEY (USERNAME)
> );
> --------------------------------------------------------------------------------
> -- INSERT USER INTO TESTTABLE TABLE
> -- STEP 3
> --------------------------------------------------------------------------------
> INSERT INTO TESTTABLE VALUES('<adminuser>', '<adminpass>');
> 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
[jira] [Commented] (DERBY-5676) Database cannot to started
Posted by "Mike Matrigali (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5676?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13240777#comment-13240777 ]
Mike Matrigali commented on DERBY-5676:
---------------------------------------
maybe post your exact script to create db and to reconnect. Maybe some wierdness in the quoting, your post to the eye looks like it has wrong single quotes.
> 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
> Attachments: db.pax.Z, derby.log
>
>
> 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
[jira] [Commented] (DERBY-5676) Database cannot to started
Posted by "Kathey Marsden (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5676?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13242821#comment-13242821 ]
Kathey Marsden commented on DERBY-5676:
---------------------------------------
Thanks Ambili,
I am unable to reproduce here, so the issue must need your disk or configuration.
Could you please
1) attach the exact create and select scripts you use to reproduce.
2) Check with your system programer and see if there is any sort of caching that occurs with your disk configuration.
3) Try with a 10.8.2.2 debug build.
> 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
> Attachments: db.pax.Z, db.tar, derby.log
>
>
> 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
[jira] [Commented] (DERBY-5676) Database cannot to started
Posted by "Ambili (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5676?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13254809#comment-13254809 ]
Ambili commented on DERBY-5676:
-------------------------------
Hi Myrna,
This is a customer issue. I tried the same script on our Systems with different java version and even the same version that customer uses and I was not able to reproduce that.
It seems indicated that there is a difference between this system and the other one, or things would work the same way. We need to find that difference to move forward.
My comments to your questions.
- permissions/rights for the user running the script
==> We checked the permissions of the files and even set it to 777 and it did not help
- file permissions (read/write) after creation of the database between the two systems
==> If i remember correctly it remained 777
- type file system
==>HFS
- jvm version
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
os.version=01.13.00
- path settings for the user running the script
Not sure what you are asking here. is this the PATH environment variable?
- other derby installations present?
I don;t think so. But i can double check and let you know.
Double checking these settings are the same on the two systems would be helpful.
> 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
> Attachments: db.pax.Z, db.tar, db.tar, derby.log, scriptinascii.zip, scripts.tar
>
>
> 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
[jira] [Commented] (DERBY-5676) Database cannot to started
Posted by "Mike Matrigali (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5676?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13240775#comment-13240775 ]
Mike Matrigali commented on DERBY-5676:
---------------------------------------
can you show exact way you are trying to connect again?
Do you have same problem if you don't encrypt? am wondering if maybe you are mismatching encryption somehow.
> 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
> Attachments: db.pax.Z, derby.log
>
>
> 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
[jira] [Commented] (DERBY-5676) Database cannot to started
Posted by "Ambili (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5676?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13244637#comment-13244637 ]
Ambili commented on DERBY-5676:
-------------------------------
Hi Mike,
Before creating DB, the /HO43/Vantagegmi/webclientdb/VantageDb did not exist. I have attached the scripts that we used to create and query the DB.
I will run the test with no encryption and let you know. We did not try any other encryption.
regards
Ambili
> 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
> Attachments: db.pax.Z, db.tar, db.tar, derby.log, scripts.tar
>
>
> 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
[jira] [Issue Comment Edited] (DERBY-5676) Database cannot to
started
Posted by "Ambili (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5676?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13266589#comment-13266589 ]
Ambili edited comment on DERBY-5676 at 5/2/12 2:37 PM:
-------------------------------------------------------
hi Kathey,
Customer has z196.
But we are also running z196 and i cannot reproduce that issue. The change in our system is that we don;t have IBMJCECCA provider in java.security
regards
Ambili
was (Author: ambili):
Customer has z196.
> 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
> Attachments: db.pax.Z, db.tar, db.tar, derby.log, scriptinascii.zip, scripts.tar
>
>
> 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
[jira] [Updated] (DERBY-5676) Database cannot to started
Posted by "Ambili (Updated) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5676?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ambili updated DERBY-5676:
--------------------------
Attachment: db.pax.Z
The Pax file attached has the database that was getting corrupted. The derby.log is also in the pax. if you have access to Z/os. Download the file and do a
pax -rvf db.pax.Z to extract the file
> 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
> Attachments: db.pax.Z, derby.log
>
>
> 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
[jira] [Commented] (DERBY-5676) Database cannot to started
Posted by "Mike Matrigali (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5676?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13244817#comment-13244817 ]
Mike Matrigali commented on DERBY-5676:
---------------------------------------
i don't know how to read ebcdic format on my windows machine. Since we are having a hard time reproducing I wonder if ebcidic is key part of the problem, maybe something is getting confused between ij and the server.
> 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
> Attachments: db.pax.Z, db.tar, db.tar, derby.log, scripts.tar
>
>
> 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
[jira] [Commented] (DERBY-5676) Database cannot to started
Posted by "Ambili (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5676?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13240788#comment-13240788 ]
Ambili commented on DERBY-5676:
-------------------------------
When connecting from tomcat we use the context
<Resource name="jdbc/VantageDS"
type="javax.sql.DataSource"
driverClassName="org.apache.derby.jdbc.EmbeddedDriver"
maxIdle="2"
maxWait="5000"
url="jdbc:derby:/HO43/Vantagegmi/webclientdb/VantageDb;dataEncryption=true;bootPassword=Password;encryptionAlgorithm=AES/CBC/NoPadding"
maxActive="10"/>
> 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
> Attachments: db.pax.Z, derby.log
>
>
> 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
[jira] [Commented] (DERBY-5676) Database cannot to started
Posted by "Ambili (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5676?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13244948#comment-13244948 ]
Ambili commented on DERBY-5676:
-------------------------------
Mike,
The issue is not with ebcidic format since the same script work on other system.
The script ran is RunScript.sh which creates a DB at the user given path and does a backup of the db and then query the DB. You can check the script.out file in the attached zip to get the output of ij command.
regards
Ambili
> 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
> Attachments: db.pax.Z, db.tar, db.tar, derby.log, scriptinascii.zip, scripts.tar
>
>
> 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
[jira] [Commented] (DERBY-5676) Database cannot to started
Posted by "Ambili (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5676?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13254806#comment-13254806 ]
Ambili commented on DERBY-5676:
-------------------------------
Hi Kathey,
This is a customer issue. I cannot check it here. I will check with customer and let you know. I see that the in logs java system properties print os version like this.
os.version=01.13.00
> 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
> Attachments: db.pax.Z, db.tar, db.tar, derby.log, scriptinascii.zip, scripts.tar
>
>
> 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
[jira] [Updated] (DERBY-5676) Database cannot to started
Posted by "Ambili (Updated) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5676?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ambili updated DERBY-5676:
--------------------------
Description:
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.
was:
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.
> 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
> Attachments: db.pax.Z, derby.log
>
>
> 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
[jira] [Updated] (DERBY-5676) Database cannot to started
Posted by "Ambili (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5676?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ambili updated DERBY-5676:
--------------------------
Description:
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: /HO4/test/testDb;create=true;dataEncryption=true;bootPassword=Password;encryptionAlgorithm=AES/CBC/NoPadding;';
--------------------------------------------------------------------------------
-- CREATE TESTTABLE TABLE WITH PRIMARY KEY OF USERNAME
-- STEP 2
--------------------------------------------------------------------------------
CREATE TABLE TESTTABLE
(
USERNAME VARCHAR(30) NOT NULL,
PASSWORD VARCHAR(30) NOT NULL,
PRIMARY KEY (USERNAME)
);
--------------------------------------------------------------------------------
-- INSERT USER INTO TESTTABLE TABLE
-- STEP 3
--------------------------------------------------------------------------------
INSERT INTO TESTTABLE VALUES('<adminuser>', '<adminpass>');
EXIT;
Create was successful. But when we try to connect to DB again it fails to start with error.
was:
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.
> 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
> Attachments: db.pax.Z, db.tar, db.tar, derby.log, scriptinascii.zip, scripts.tar
>
>
> 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: /HO4/test/testDb;create=true;dataEncryption=true;bootPassword=Password;encryptionAlgorithm=AES/CBC/NoPadding;';
> --------------------------------------------------------------------------------
> -- CREATE TESTTABLE TABLE WITH PRIMARY KEY OF USERNAME
> -- STEP 2
> --------------------------------------------------------------------------------
> CREATE TABLE TESTTABLE
> (
> USERNAME VARCHAR(30) NOT NULL,
> PASSWORD VARCHAR(30) NOT NULL,
> PRIMARY KEY (USERNAME)
> );
> --------------------------------------------------------------------------------
> -- INSERT USER INTO TESTTABLE TABLE
> -- STEP 3
> --------------------------------------------------------------------------------
> INSERT INTO TESTTABLE VALUES('<adminuser>', '<adminpass>');
> 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
[jira] [Commented] (DERBY-5676) Database cannot to started
Posted by "Kathey Marsden (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5676?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13240798#comment-13240798 ]
Kathey Marsden commented on DERBY-5676:
---------------------------------------
Can you reproduce using ij to both create and reconnect?
> 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
> Attachments: db.pax.Z, derby.log
>
>
> 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
[jira] [Commented] (DERBY-5676) Database cannot to started
Posted by "Ambili (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5676?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13266589#comment-13266589 ]
Ambili commented on DERBY-5676:
-------------------------------
Customer has z196.
> 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
> Attachments: db.pax.Z, db.tar, db.tar, derby.log, scriptinascii.zip, scripts.tar
>
>
> 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
[jira] [Commented] (DERBY-5676) Database cannot to started
Posted by "Ambili (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5676?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13240785#comment-13240785 ]
Ambili commented on DERBY-5676:
-------------------------------
First i was trying to connect from tomcat. But later we tried creating a sample database ( attached here) and tried to connect using ij tool.
This is what is used to test the connection using ij tool. the Sql file to used in ij tool is
connect 'jdbc:derby:/HO43/Vantagegmi/webclientdb/VantageDb;dataEncryption=true;bootPassword=<password>;encryptionAlgorithm=AES/CBC/NoPadding;';
SELECT * FROM USER_CREDENTIALS ;
And sorry about the typo in the old post. The create query is
connect 'jdbc:derby:/HO43/Vantagegmi/webclientdb/VantageDb;create=true;dataEncryption=true;bootPassword=<password>;encryptionAlgorithm=AES/CBC/NoPadding;';
> 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
> Attachments: db.pax.Z, derby.log
>
>
> 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
[jira] [Updated] (DERBY-5676) Database cannot to started
Posted by "Kathey Marsden (Updated) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5676?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kathey Marsden updated DERBY-5676:
----------------------------------
Attachment: db.tar
Here is a tarred database which might be more convenient on other platforms. I see the NullPointerException on both z/os and windows connecting to this database.
> 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
> Attachments: db.pax.Z, db.tar, derby.log
>
>
> 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
[jira] [Commented] (DERBY-5676) Database cannot to started
Posted by "Ambili (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5676?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13240814#comment-13240814 ]
Ambili commented on DERBY-5676:
-------------------------------
kathey,
yes. We can reproduce that with ij tool. The script I posted are using ij. The first one to create Db, create a table and one record in that table.
The second script to query the database created , and select the row in the table USER_CREDENTIALS.
ambili
> 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
> Attachments: db.pax.Z, db.tar, derby.log
>
>
> 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
[jira] [Commented] (DERBY-5676) Database cannot to started
Posted by "Kathey Marsden (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5676?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13240761#comment-13240761 ]
Kathey Marsden commented on DERBY-5676:
---------------------------------------
Hello Ambili,
I tried your script on a z/os machine I have access to but not HFS, (changing the database name to a local db and removing the extraneous single quote) and was able to reconnect and recover.
Is it possible HFS has some extreme write caching? Can you post the resulting corrupt database?
> 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
> Attachments: derby.log
>
>
> 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
[jira] [Commented] (DERBY-5676) Database cannot to started
Posted by "Ambili (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5676?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13244618#comment-13244618 ]
Ambili commented on DERBY-5676:
-------------------------------
Hi Kathey,
I am attaching the scripts I used to create and query the db.
The output of RunScript.sh is in script.out. The CreateVantageDB.sh uses the databaseAuth_template.sql to create the DB and the DBQuery.sh query the database.
All the script files are in ebcdic format.
I will check with system programmer to see what sort of caching is enabled. Do you know how can this be checked against filesystem?
thanks
Ambili
> 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
> Attachments: db.pax.Z, db.tar, derby.log, scripts.tar
>
>
> 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
[jira] [Commented] (DERBY-5676) Database cannot to started
Posted by "Ambili (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5676?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13265158#comment-13265158 ]
Ambili commented on DERBY-5676:
-------------------------------
Hi,
Latest update on this issue. As Mike mentioned we turned off encryption at customer site and we were able to create and query database without any issues. But we tested it on our system with same java version it worked.
But the difference we see in both environment is that java.security file has
security.provider.2=com.ibm.crypto.hdwrCCA.provider.IBMJCECCA
coming before IBM JCE.
security.provider.3=com.ibm.crypto.provider.IBMJCE
In our enviornment we don;t have IBMJCECCA provider.
So we are thinking that that can be the reason for failure. If anyone tested derby with AES encryption where IBMJCECCA provider is used, please let me know.
regards
Ambili
> 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
> Attachments: db.pax.Z, db.tar, db.tar, derby.log, scriptinascii.zip, scripts.tar
>
>
> 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
[jira] [Commented] (DERBY-5676) Database cannot to started
Posted by "Ambili (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5676?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13240768#comment-13240768 ]
Ambili commented on DERBY-5676:
-------------------------------
Hi Kathey,
Thanks for trying it out. I have the script working on other machines where java version is different. I am not sure whether the issue is with File System settings. If you know any related information, please let me know. Appreciate your help.
thanks
Ambili
> 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
> Attachments: db.pax.Z, derby.log
>
>
> 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
[jira] [Commented] (DERBY-5676) Database cannot to started
Posted by "Bryan Pendleton (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5676?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13404681#comment-13404681 ]
Bryan Pendleton commented on DERBY-5676:
----------------------------------------
At the very least, it seems like we should document the incompatibility between IBMJCECCA
encryption provider and Derby's encryption requests.
Ideally, if we could understand the incompatibility more clearly, it would be nice to
modify Derby's encryption code to be compatible with the IBMJCECCA provider.
> 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
> Attachments: db.pax.Z, db.tar, db.tar, derby.log, scriptinascii.zip, scripts.tar
>
>
> 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: /HO4/test/testDb;create=true;dataEncryption=true;bootPassword=Password;encryptionAlgorithm=AES/CBC/NoPadding;';
> --------------------------------------------------------------------------------
> -- CREATE TESTTABLE TABLE WITH PRIMARY KEY OF USERNAME
> -- STEP 2
> --------------------------------------------------------------------------------
> CREATE TABLE TESTTABLE
> (
> USERNAME VARCHAR(30) NOT NULL,
> PASSWORD VARCHAR(30) NOT NULL,
> PRIMARY KEY (USERNAME)
> );
> --------------------------------------------------------------------------------
> -- INSERT USER INTO TESTTABLE TABLE
> -- STEP 3
> --------------------------------------------------------------------------------
> INSERT INTO TESTTABLE VALUES('<adminuser>', '<adminpass>');
> 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
[jira] [Commented] (DERBY-5676) Database cannot to started
Posted by "Ambili (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5676?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13240695#comment-13240695 ]
Ambili commented on DERBY-5676:
-------------------------------
Derby log attached. The File system on which the derby is created is HFS
> 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
> Attachments: derby.log
>
>
> 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
[jira] [Commented] (DERBY-5676) Database cannot to started
Posted by "Kathey Marsden (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5676?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13240779#comment-13240779 ]
Kathey Marsden commented on DERBY-5676:
---------------------------------------
Also please post the exact urls for the connection on create and then the attempted reconnect. I am wondering if there is some mismatch of encryption because of the few odd characters in the url.
> 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
> Attachments: db.pax.Z, derby.log
>
>
> 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