[DERBY-5676] Cannot connect to AES encrypted database with IBMJCECCA provider - ASF JIRA

Attach files

Attach Screenshot

Add vote

Voters

Watch issue

Watchers

Create sub-task

Link

Clone

Update Comment Author

Replace String in Comment

Update Comment Visibility

Delete Comments

XML

Word

Printable

JSON

Details

Type: Bug
Status: Open
Priority: Blocker
Resolution: Unresolved
Affects Version/s: 10.5.3.0
Fix Version/s: None
Component/s: Services
Labels:
- derby_triage10_10
Environment:

Hide
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


Show
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

Urgency:
Normal

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.

Attachments

scripts.tar
02/Apr/12 21:02
50 kB
Ambili
scriptinascii.zip
03/Apr/12 03:42
7 kB
Ambili
derby.log
28/Mar/12 20:23
22 kB
Ambili
db.tar
28/Mar/12 22:53
1.75 MB
Katherine Marsden
db.tar
02/Apr/12 21:06
3.49 MB
Ambili
db.pax.Z
28/Mar/12 21:54
1.78 MB
Ambili

Activity

Comment

This comment will be Viewable by All Users Viewable by All Users

Cancel

People

Assignee:: Unassigned

Reporter:: Ambili

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 28/Mar/12 20:22

Updated:: 18/Sep/12 15:08

Agile

View on Board

Cannot connect to AES encrypted database with IBMJCECCA provider

Details

Description

Attachments

Attachments

Activity

People

Dates

Agile

Slack

Issue deployment