Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 805
  • Last Modified:

JDBC Connection Error

I've installed this scenario:

Server -> Linux Suse 6.4 with DB2 7.1
Client -> 1.- W2k with DB2 AdminClient
          2.- Linux workstations with SunOne Studio 4.1 & DB Visualizer 3.2 (workstations with Sun JDK 1.4.x)

On w2k Db2cc works perfectly and it connect fine with the server.I have created a database named DB2Test with two Tables.

Using ODBC,I can connect with DBTest and y can see the tables.

The problem appears when I try a JDBC Connection from SunOne Studio or DB Visualizer using db2java.zip (COM.ibm.db2.jdbc.net.DB2Driver) using this connection string :

jdbc:db2://my_server_name:6688:db2test

I've get the following error :

COM.ibm.db2.jdbc.DB2Exception: [IBM][JDBC Driver] CLI0615E  Error receiving from socket, server is not responding. SQLSTATE=08S01
[IBM][JDBC Driver] CLI0615E  Error receiving from socket, server is not responding. SQLSTATE=08S01

The server work correctly (i can connect with db2cc) and I've running db2jd on port 6688

What's the problem?

Thanks.

0
ivitalg
Asked:
ivitalg
2 Solutions
 
elppCommented:
The connection string should be:
jdbc:db2://my_server_name:6688/db2test
0
 
mglxxxCommented:
If the connection URL you gave is wrong due
to a typo: do you have the same version of
DB2 installed on W2k and Linux? For the
'net' driver to work the db2java.zip need to be
the same version both on client and server.

One thing to try would to copy the db2java.zip from
the Linux box to the W2k box and try using that
on the the W2k box.
0

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now