CODEWITHSUNDEEP
javajdbcdb2connection
santosh
santosh

Reputation: 425

How can I connect to db2 database remotely

I am using following java application to connect db2 database for localhost and code is:

String jdbcClassName="com.ibm.db2.jcc.DB2Driver";
String url="jdbc:db2://localhost:50000/sample";
String user="admin";
String password="admin";
try {
    //Load class into memory
    Class.forName(jdbcClassName);
    //Establish connection
    connection = DriverManager.getConnection(url, user, password);
    stmt = connection.createStatement();
}
catch (SQLException e) {
    e.printStackTrace();
}

The problem is that when application and db2 is running on the same machine, then it is working, but if db2 database is on another machine then it is not working. I am using ip in my url which is:

String url="jdbc:db2://192.168.1.68:50000/sample";

And it's giving the following error:

com.ibm.db2.jcc.am.DisconnectNonTransientConnectionException: [jcc][t4][2043][11550][3.59.81] Exception java.net.ConnectException: Error opening socket to server /192.168.1.64 on port 50,000 with message: Connection timed out: connect. ERRORCODE=-4499, SQLSTATE=08001

How can I connect to the database remotely?

Upvotes: 0

Views: 1299

Answers (1)

maddy
maddy

Reputation: 358

Check if your private or public network firewall is on ?? If it is on then instead of doing it off make an inbound rule and then try to connect it with DB2 database from another system.

Upvotes: 0

Related Questions