Witam,
mam nastepujacy problem: chce polaczy sie z baza danych db2. Funkcja odpowiadajaca za polaczenie wyglada w nastepujacy sposob:
private Connection startConnection() throws PerException, SQLException{
try{
String jdbcDriver = "com.ibm.db2.jcc.DB2Driver";
String jdbcURL = "jdbc:db2://192.168.2.95:50000/SAMPLE";
String username = "db2admin";
String password = "db2";
Class.forName(jdbcDriver);
System.out.println("Driver ok");
Connection con = DriverManager.getConnection( jdbcURL, username, password);
System.out.println("connection ok");
return con;
}
catch(ClassNotFoundException e){
throw new PerException("Class not found");
}
}
Niestety w rezultacie zamiast polaczenia otrzymuje nastepujacy blad:
com.ibm.db2.jcc.a.en: [jcc][t4][2043][11550][3.52.95] Ausnahmebedingung [Ljava.lang.Object;@1aaa14a: Fehler beim Öffnen des Sockets zu Server {1} an Port {2} mit Nachricht: {3}. ERRORCODE=-4499, SQLSTATE=08001
at com.ibm.db2.jcc.a.ad.a(ad.java:319)
at com.ibm.db2.jcc.a.ad.a(ad.java:337)
at com.ibm.db2.jcc.t4.xb.a(xb.java:375)
at com.ibm.db2.jcc.t4.xb.<init>(xb.java:76)
at com.ibm.db2.jcc.t4.a.x(a.java:263)
at com.ibm.db2.jcc.t4.b.a(b.java:1809)
at com.ibm.db2.jcc.a.ib.a(ib.java:503)
at com.ibm.db2.jcc.a.ib.<init>(ib.java:459)
at com.ibm.db2.jcc.t4.b.<init>(b.java:330)
at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:197)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at videostore.videostore.SQL.startConnection(SQL.java:122)
at videostore.videostore.SQL.loadArticle(SQL.java:145)
at videostore.videostore.SQL.<init>(SQL.java:38)
at videostore.videostore.VideoStore.<clinit>(VideoStore.java:18)
at videostore.videostore.Test.main(Test.java:29)
Caused by: java.net.ConnectException: Connection timed out: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(Unknown Source)
at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at com.ibm.db2.jcc.t4.y.run(y.java:34)
at java.security.AccessController.doPrivileged(Native Method)
at com.ibm.db2.jcc.t4.xb.a(xb.java:369)
... 14 more
i zupelnie nie mam pojecia gdzie moze byc problem :/
Z gory dzieki za pomoc :)