From derby-user-return-1173-apmail-db-derby-user-archive=db.apache.org@db.apache.org Tue Apr 19 05:47:47 2005
Return-Path: <derby-user-return-1173-apmail-db-derby-user-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-derby-user-archive@www.apache.org
Received: (qmail 61613 invoked from network); 19 Apr 2005 05:47:47 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 19 Apr 2005 05:47:47 -0000
Received: (qmail 45420 invoked by uid 500); 19 Apr 2005 05:47:42 -0000
Delivered-To: apmail-db-derby-user-archive@db.apache.org
Received: (qmail 45396 invoked by uid 500); 19 Apr 2005 05:47:42 -0000
Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
list-help: <mailto:derby-user-help@db.apache.org>
list-unsubscribe: <mailto:derby-user-unsubscribe@db.apache.org>
List-Post: <mailto:derby-user@db.apache.org>
List-Id: <derby-user.db.apache.org>
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Delivered-To: mailing list derby-user@db.apache.org
Received: (qmail 45382 invoked by uid 99); 19 Apr 2005 05:47:42 -0000
X-ASF-Spam-Status: No, hits=0.4 required=10.0
	tests=DNS_FROM_RFC_ABUSE,RCVD_BY_IP,SPF_HELO_PASS,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (hermes.apache.org: domain of simonzmail@gmail.com designates 64.233.162.198 as permitted sender)
Received: from zproxy.gmail.com (HELO zproxy.gmail.com) (64.233.162.198)
  by apache.org (qpsmtpd/0.28) with ESMTP; Mon, 18 Apr 2005 22:47:40 -0700
Received: by zproxy.gmail.com with SMTP id 40so3577432nzk
        for <derby-user@db.apache.org>; Mon, 18 Apr 2005 22:47:38 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition;
        b=dP3FUteV79WV8ZCfdPz6YwuwqJmUjmcolfgrdFZK7WT58PK/opfzri2g1IGNL5rjFpnPdE73fGzZlFLv3KvSuLPPF/GUI4ViL7hKMstycIyDjmILJt20ygxSYXPSRFWYKPSWZYpLnnKyhmfNu1djH88a0NDolNv6OMkoMdmLpgQ=
Received: by 10.36.101.17 with SMTP id y17mr455117nzb;
        Mon, 18 Apr 2005 22:47:38 -0700 (PDT)
Received: by 10.36.89.19 with HTTP; Mon, 18 Apr 2005 22:47:38 -0700 (PDT)
Message-ID: <103b222c0504182247597c3bd0@mail.gmail.com>
Date: Tue, 19 Apr 2005 15:47:38 +1000
From: Simon <simonzmail@gmail.com>
Reply-To: Simon <simonzmail@gmail.com>
To: derby-user@db.apache.org
Subject: ODBC and Security Mechanism
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
X-Virus-Checked: Checked
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

Hello all,

I am trying to get access to a Derby Network Server working via the
ODBC client under Windows.

So -  I tried following all the instructions listed here:

http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0502scott/=
?ca=3Ddgr-phpw08PHPdatabaseApps

However when I try to connect it fails and I get errors like this in
the derby log:

  java.lang.ClassNotFoundException is caught when initializing
  EncryptionManager 'IBMJCE'

Researching this it seems that I need to install IBMJCE - but I don't
have access to that and even if I did I'd rather not have to install
it.    I looked at the code and it seems the ODBC client is passing
securityMechanism=3D9 (Encrpyted userid and password) to the server.  I
looked everywhere in the ODBC configuration and the installation of
the DB2 client, db2cli.ini etc. and couldn't find how to modify this
parameter.

So - the question is - does anyone know of a way to make the ODBC
client pass a different securityMechanism (as is easy to do with the
JDBC driver) so that I do not need IBMJCE?

Thanks for any help!

Simon.