DB2 JDBC connection issue

MiraJasmin · #1 (**permalink**) 01-06-06, 09:43

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

n_i · #2 (**permalink**) 01-06-06, 11:01

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.

przytula · #3 (**permalink**) 01-06-06, 12:11

check that jdbc server has been started
db2jstrt 6789 and check the process db2jd

Internet Services

Web Development

Digital Marketing

Consumer Tech