Hallo, hab im Internet den Code gefunden und für mich angepasst.
Bekomm aber nur einen Fehler:
Exception in thread "main" com.ibm.db2.jcc.c.DisconnectException: [ibm][db2][jcc][t4][2043][11550] Ausnahmebedingung java.net.ConnectException: Fehler beim Öffnen des Sockets zu Server /172.20.11.67 an Port 50.001 mit Nachricht: Connection refused: connect.
at com.ibm.db2.jcc.a.xb.a(xb.java:396)
at com.ibm.db2.jcc.a.xb.<init>(xb.java:79)
at com.ibm.db2.jcc.a.a.x(a.java:266)
at com.ibm.db2.jcc.a.b.a(b.java:1781)
at com.ibm.db2.jcc.c.bb.a(bb.java:394)
at com.ibm.db2.jcc.c.bb.<init>(bb.java:354)
at com.ibm.db2.jcc.a.b.<init>(b.java:314)
at com.ibm.db2.jcc.DB2DataSource.getSimpleConnection(DB2DataSource.java:94)
at com.ibm.db2.jcc.DB2DataSource.getConnection(DB2DataSource.java:74)
at com.ibm.db2.jcc.DB2DataSource.getConnection(DB2DataSource.java:60)
at jdbcbd2.Main.main(Main.java:26)
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
at java.net.Socket.connect(Socket.java:519)
at com.ibm.db2.jcc.a.y.run(y.java:34)
at java.security.AccessController.doPrivileged(Native Method)
at com.ibm.db2.jcc.a.xb.a(xb.java:390)
... 10 more
Java Result: 1
Verstehe nicht warum ich mich nicht verbinden kann, es ist doch alles richtig eingetragen, Firewall ist aus.
Vielleicht einer ne Idee?
Gruß
Java:
package jdbcbd2;
import java.sql.Connection;
import com.ibm.db2.jcc.DB2DataSource;
public class Main
{
public static void main(String[] args) throws Exception {
DB2DataSource datasource = new DB2DataSource();
datasource.setServerName("172.20.11.67");
datasource.setUser("db2admin");
datasource.setPassword("12345");
datasource.setDriverType(4); //Type 4 pure Java JDBC Driver
datasource.setPortNumber(50001);
datasource.setDatabaseName("Mitarbei");
Connection connection = datasource.getConnection();
connection.close();
}
}
Bekomm aber nur einen Fehler:
Exception in thread "main" com.ibm.db2.jcc.c.DisconnectException: [ibm][db2][jcc][t4][2043][11550] Ausnahmebedingung java.net.ConnectException: Fehler beim Öffnen des Sockets zu Server /172.20.11.67 an Port 50.001 mit Nachricht: Connection refused: connect.
at com.ibm.db2.jcc.a.xb.a(xb.java:396)
at com.ibm.db2.jcc.a.xb.<init>(xb.java:79)
at com.ibm.db2.jcc.a.a.x(a.java:266)
at com.ibm.db2.jcc.a.b.a(b.java:1781)
at com.ibm.db2.jcc.c.bb.a(bb.java:394)
at com.ibm.db2.jcc.c.bb.<init>(bb.java:354)
at com.ibm.db2.jcc.a.b.<init>(b.java:314)
at com.ibm.db2.jcc.DB2DataSource.getSimpleConnection(DB2DataSource.java:94)
at com.ibm.db2.jcc.DB2DataSource.getConnection(DB2DataSource.java:74)
at com.ibm.db2.jcc.DB2DataSource.getConnection(DB2DataSource.java:60)
at jdbcbd2.Main.main(Main.java:26)
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
at java.net.Socket.connect(Socket.java:519)
at com.ibm.db2.jcc.a.y.run(y.java:34)
at java.security.AccessController.doPrivileged(Native Method)
at com.ibm.db2.jcc.a.xb.a(xb.java:390)
... 10 more
Java Result: 1
Verstehe nicht warum ich mich nicht verbinden kann, es ist doch alles richtig eingetragen, Firewall ist aus.
Vielleicht einer ne Idee?
Gruß