Java Database Connectivity (JDBC)

Hi,

Iam trying to connect DB2 using JDBC driver 4... my Database resides in another machine.. that DB2 iam trying to connect from my machine ... i got an error in that process...

this is my code for jdbc connection for db2..

package dbconnection;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class DBConnection {

public static void main(String[] args) {

Connection con = null;

try {
Class.forName("com.ibm.db2.jcc.DB2Driver").newInstance();
con = DriverManager.getConnection( "jdbc:db2://localhost:50000/dbname","username","password");
System.out.println("Connection is Established!!");

} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
} catch (IllegalAccessException e) {
e.printStackTrace();
} catch (InstantiationException e) {
e.printStackTrace();
}
}
}


but iam getting the exception after some time like this below...........


com.ibm.db2.jcc.c.DisconnectException: [ibm][db2][jcc][t4][2043][11550] Exception java.net.ConnectException: Error opening socket to server /192.168.8.76 on port 50,000 with message: Connection timed out: connect.
at com.ibm.db2.jcc.b.yb.a(yb.java:375)
at com.ibm.db2.jcc.b.yb.<init>(yb.java:76)
at com.ibm.db2.jcc.b.a.v(a.java:254)
at com.ibm.db2.jcc.b.b.a(b.java:1669)
at com.ibm.db2.jcc.c.p.a(p.java:350)
at com.ibm.db2.jcc.c.p.<init>(p.java:404)
at com.ibm.db2.jcc.b.b.<init>(b.java:256)
at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:163)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at JDBC.JDBCDriverInformation.main(JDBCDriverInformation.java:19)
Caused by: java.net.ConnectException: Connection timed out: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:305)
at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:171)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:158)
at java.net.Socket.connect(Socket.java:452)
at com.ibm.db2.jcc.b.bb.run(bb.java:34)
at java.security.AccessController.doPrivileged(Native Method)
at com.ibm.db2.jcc.b.yb.a(yb.java:369)
... 10 more



Database is running perfectly in another machine... but i couldn't under stand whts the prblm... can anyone help me abt this prblm...

Edited by: shivaram on 31 Jul, 2008 2:36 AM