[
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
