Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2003
    Posts
    3

    Unanswered: Accessing DB2 (Server-to-Server)

    I developed a small Java based utility to do some DB related processing. The utility works fine when I run it locally (on a PC) and access a database on my laptop. However, when I configure the utility to run locally but access a database on a Unix workstation. I get the following error.

    COM.ibm.db2.jdbc.DB2Exception: [IBM][JDBC Driver] CLI0621E Unsupported JDBC Server configuration.
    at COM.ibm.db2.jdbc.net.SQLExceptionGenerator.check_r eturn_code(Unknown Source)
    at COM.ibm.db2.jdbc.net.DB2Connection.SQLConnect(Unkn own Source)
    at COM.ibm.db2.jdbc.net.DB2Connection.SQLConnect(Unkn own Source)
    at COM.ibm.db2.jdbc.net.DB2Connection.create(Unknown Source)
    at COM.ibm.db2.jdbc.net.DB2Connection.<init>(Unknown Source)
    at COM.ibm.db2.jdbc.net.DB2Driver.connect(Unknown Source)
    at java.sql.DriverManager.getConnection(DriverManager .java:543)
    at java.sql.DriverManager.getConnection(DriverManager .java:194)
    at com.wb.rpttrk.DBUtil.GetConnection(DBUtil.java:671 )
    at com.wb.rpttrk.DBUtil.Demo(DBUtil.java:737)
    at com.wb.rpttrk.DBUtil.main(DBUtil.java:140)
    java.lang.NullPointerException
    at com.wb.rpttrk.DBUtil.Execute(DBUtil.java:689)
    at com.wb.rpttrk.DBUtil.Demo(DBUtil.java:739)
    at com.wb.rpttrk.DBUtil.main(DBUtil.java:140)



    Is there something special that I need to do for server to server communications? Any thought, comments and tips would be appreciated.

  2. #2
    Join Date
    Aug 2002
    Location
    St. Louis
    Posts
    16
    It sounds like you have a mismatch between drivers on the server and your workstation. If the server is configured for jdbc2 then your client should use jdbc2 as well.

  3. #3
    Join Date
    Dec 2003
    Posts
    3
    How can I determine which version is running on my the server?

  4. #4
    Join Date
    Aug 2002
    Location
    St. Louis
    Posts
    16
    Originally posted by timmo
    How can I determine which version is running on my the server?
    I work in a Windows environment (UDB 7.2) so there may be differences.

    In windows there's a file ..\sqllib\java12\inuse which indicates jdbc 1 or 2. The db2java.zip file actually in use is in ..\sqllib\java

  5. #5
    Join Date
    Dec 2003
    Posts
    3
    Thanks Jay,

    Your comments were insightful and helpled me out... .. . I now have connectivity.

Posting Permissions

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