[JAVA/SQL] Problema connessione con DB2 sia con jdbc che con squirrelSQL!!! help

[doctorAle85]

Sto utilizzando jdbc su eclipse per connettermi ad un database con DB2.

Utilizzo i seguenti parametri
url: "jdbc:db2://localhost:50000/"
driver:"com.ibm.db2.jcc.DB2Driver"

Il problema si verifica quando devo creare la connessione!!!

L'errore è il seguente:
Exception in thread "main" com.ibm.db2.jcc.b.DisconnectException: A communication error has been detected. Communication protocol being used: Reply.fill(). Communication API being used: InputStream.read(). Location where the error was detected: insufficient data. Communication function detecting the error: *. Protocol specific error codes(s) TCP/IP SOCKETS
at com.ibm.db2.jcc.a.a.a(a.java:428)
at com.ibm.db2.jcc.a.ab.b(ab.java:202)
at com.ibm.db2.jcc.a.ab.c(ab.java:222)
at com.ibm.db2.jcc.a.ab.c(ab.java:337)
at com.ibm.db2.jcc.a.ab.v(ab.java:1447)
at com.ibm.db2.jcc.a.bb.a(bb.java:39)
at com.ibm.db2.jcc.a.b.e(b.java:1232)
at com.ibm.db2.jcc.a.b.b(b.java:1147)
at com.ibm.db2.jcc.a.b.q(b.java:931)
at com.ibm.db2.jcc.a.b.a(b.java:702)
at com.ibm.db2.jcc.a.b.<init>(b.java:305)
at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:162)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)

----------------

Se provo ad utilizzare SquirrelSQL mi genera questo errore, che in pratica è lo stesso:

com.ibm.db2.jcc.b.DisconnectException: [ibm][db2][jcc][t4][2030][11211] A communication error has been detected. Communication protocol being used: TCP/IP.
Communication API being used: SOCKETS. Location where the error was detected: Reply.fill().
Communication function detecting the error: InputStream.read(). Protocol specific error codes Insufficient data, * , 0. Message: null
at com.ibm.db2.jcc.c.a.a(a.java:385)
at com.ibm.db2.jcc.c.ab.b(ab.java:219)
at com.ibm.db2.jcc.c.ab.c(ab.java:237)
at com.ibm.db2.jcc.c.ab.c(ab.java:348)
at com.ibm.db2.jcc.c.ab.v(ab.java:1134)
at com.ibm.db2.jcc.c.bb.a(bb.java:42)
at com.ibm.db2.jcc.c.b.f(b.java:1362)
at com.ibm.db2.jcc.c.b.b(b.java:1254)
at com.ibm.db2.jcc.c.b.s(b.java:1024)
at com.ibm.db2.jcc.c.b.b(b.java:639)
at com.ibm.db2.jcc.c.b.a(b.java:625)
at com.ibm.db2.jcc.c.b.a(b.java:363)
at com.ibm.db2.jcc.c.b.<init>(b.java:299)
at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:166)
at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:133)
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.execute(OpenConnectionCommand.java:97)
at net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToAliasCommand$SheetHandler.run(ConnectToAliasCommand.java:280)
at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
at java.lang.Thread.run(Unknown Source)

[RaouL_BennetH]

Stai usando il Type 3 o 4 del driver ?

Ad ogni modo, non mi pare che "localhost" piaccia come url al DB2.