Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2005
    Posts
    85

    Unanswered: DB2 JDBC connection issue

    Hi,

    I am trying to connect DB2 7.1 through JDBC. Using db2Java.zip and db2jcc.jar from the DB2 installation directory.

    Using Type 3 driver and the following :

    DriverClasses: COM.ibm.db2.jdbc.net.DB2Driver

    URLs: jdbc:db2://host_name:6789/db_name

    I am getting the exception :

    Caused by: COM.ibm.db2.jdbc.DB2Exception: [IBM][JDBC Driver] CLI0616E Error opening socket. SQLSTATE=08S01
    at COM.ibm.db2.jdbc.net.SQLExceptionGenerator.socketE xception(SQLExceptionGenerator.java:574)
    at COM.ibm.db2.jdbc.net.DB2Connection.create(DB2Conne ction.java:244)
    at COM.ibm.db2.jdbc.net.DB2Connection.<init>(DB2Conne ction.java:193)
    at COM.ibm.db2.jdbc.net.DB2Driver.connect(DB2Driver.j ava:198)
    at java.sql.DriverManager.getConnection(DriverManager .java:512)
    at java.sql.DriverManager.getConnection(DriverManager .java:171)

    Please advice,

    Thanks,
    MiraJ

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Code:
    >db2 ? CLI0616E
    
    
    CLI0616E Error opening socket.
    
    Explanation:
    
    Cannot open the socket to server, server may be down.
    
    User Response:
    
    Ensure JDBC server is up, and rerun your program.

  3. #3
    Join Date
    Nov 2004
    Posts
    374

    jdbc

    check that jdbc server has been started
    db2jstrt 6789 and check the process db2jd
    Best Regards, Guy Przytula
    DB2/ORA/SQL Services
    DB2 DBA & Advanced DBA Certified
    DB2 Dprop Certified
    http://users.skynet.be/przytula/dbss.html

Posting Permissions

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