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 "John Sisson (JIRA)" <de...@db.apache.org> on 2005/05/04 06:49:12 UTC
[jira] Commented: (DERBY-65) Network Server user ID and password encryption requires IBMJCE
[ http://issues.apache.org/jira/browse/DERBY-65?page=comments#action_64446 ]
John Sisson commented on DERBY-65:
----------------------------------
The class org.apache.derby.impl.drda.EncryptionManager in the description of this issue should be org.apache.derby.impl.drda.DecryptionManager
http://svn.apache.org/repos/asf/incubator/derby/code/trunk/java/drda/org/apache/derby/impl/drda/DecryptionManager.java
> Network Server user ID and password encryption requires IBMJCE
> --------------------------------------------------------------
>
> Key: DERBY-65
> URL: http://issues.apache.org/jira/browse/DERBY-65
> Project: Derby
> Type: Bug
> Reporter: John Sisson
> Priority: Minor
>
> If you set securityMechanism=9 as a JCC (DB2 Universal Driver) property when connecting to Derby a java.lang.ClassNotFoundException is returned in an error because the code in the org.apache.derby.impl.drda.EncryptionManager constructor does the following:
> try {
> if (java.security.Security.getProvider ("IBMJCE") == null) // IBMJCE is not installed, install it.
> java.security.Security.addProvider ((java.security.Provider) Class.forName("IBMJCE").newInstance());
> <SNIP>
> }
> catch (java.lang.ClassNotFoundException e) {
> throw new SQLException ("java.lang.ClassNotFoundException is caught" +
> " when initializing EncryptionManager '" + e.getMessage() + "'");
> }
> Some improvements could also be made to related documentation:
> http://incubator.apache.org/derby/manuals/admin/hubprnt16.html should probably be improved to describe the valid values for all properties (e.g. securityMechanism ) or have links (or a comment) to other manuals that have further information on the properties.
> ==================================
> Here is how to reproduce the problem using the ij tool:
> D:\Derby_snapshots\svnversion_46005>java -cp .;.\lib\derby.jar;.\lib\derbynet.jar;.\lib\derbytools.jar;..\db2jcc\lib\db2jcc.jar;..\db2jcc\lib\db2jcc_license_c.jar -Dij.driver=com.ibm.db2.jcc.DB2Driver -Dij.user=wkpoint -Dij.password=wppass -Dij.protocol=jdbc:derby:net://localhost:1527/ org.apache.derby.tools.ij
> ij version 10.0 (C) Copyright IBM Corp. 1997, 2004.
> ij> connect 'testDB3;create=true:retrieveMessagesFromServerOnGetMessage=true;securityMechanism=9;';
> ERROR (no SQLState): java.lang.ClassNotFoundException is caught when initializing EncryptionManager 'IBMJCE'
> ij>
> ------------------ Java Information ------------------
> Java Version: 1.4.2_05
> Java Vendor: Sun Microsystems Inc.
> Java home: C:\Program Files\Java\j2re1.4.2_05
> Java classpath: .;.\lib\derby.jar;.\lib\derbynet.jar;.\lib\derbytools.jar;..\db2jcc\lib\db2jcc.jar;..\db2jcc\lib\db2jcc_license_c.j
> ar
> OS name: Windows XP
> OS architecture: x86
> OS version: 5.1
> Java user name: sissonj
> Java user home: C:\Documents and Settings\john
> Java user dir: D:\Derby_snapshots\svnversion_46005
> --------- Derby Information --------
> [D:\Derby_snapshots\svnversion_46005\lib\derby.jar] 10.0.2.0 - (46005)
> [D:\Derby_snapshots\svnversion_46005\lib\derbynet.jar] 10.0.2.0 - (46005)
> [D:\Derby_snapshots\svnversion_46005\lib\derbytools.jar] 10.0.2.0 - (46005)
> [D:\Derby_snapshots\db2jcc\lib\db2jcc.jar] 2.4 - (17)
> [D:\Derby_snapshots\db2jcc\lib\db2jcc_license_c.jar] 2.4 - (17)
> ------------------------------------------------------
> ----------------- Locale Information -----------------
> ------------------------------------------------------
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira