Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2002
    Posts
    1

    Unanswered: java.sql.SQLException: [IBM][JDBC Driver] CLI0647E Error allocating DB2 environment

    Hi,
    I am using a servlet which is loading the driver class for DB2 and I get the following error.

    java.sql.SQLException: [IBM][JDBC Driver] CLI0647E Error allocating DB2 environment handle, rc=-1.
    at COM.ibm.db2.jdbc.app.DB2Driver.<init>(DB2Driver.ja va:254)
    at java.lang.Class.newInstance0(Native Method)
    ....................

    Can someone help me with this?
    Thanks.

  2. #2
    Join Date
    Nov 2002
    Posts
    2
    Hi,

    I had this problem on a Solaris 7 system. We fixed the problem by executing the db2profile script in the user's login script. The db2profile script can probably be found in the installation directory's sqllib directory. This script sets up several environment variables required by the DB2 client software.

    Be advised that you must also comment any statements that deal with the IFS environment variable as this will replace certain characters in your PATH with ':'.

    Hope this helps,
    Tom

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •