db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ambili (Commented) (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-5676) Database cannot to started
Date Tue, 03 Apr 2012 03:46:34 GMT

    [ 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

        

Mime
View raw message