by Hi,
We are currently migrating an application from Oracle to DB2 running on
OS/390. It is my first time to connect remotely to a database on a
mainframe using JDBC.
Currently, I am using a type 4 JDBC DB2 drivers from Merant-Datadirect.
I am able to get a database connection but when I tried to execute a
simple "select" statement I always get this message :
java.sql.SQLException: [MERANT][DB2 JDBC Driver][DB2]PROGRAM NAME
DDB3.CD352AA.A.4A44424334444232 NOT FOUND IN PLAN DISTSERV
I even tried the .net DB2 driver from DB2 Connect/IBM but I get a
different message :
trying driver[className=COM.ibm.db2.jdbc.net.DB2Driver,DB2Driver:
JDBC 2.0 n010415] Server 153.2.18.133 port 6010 source DDB3
getConnection failed: COM.ibm.db2.jdbc.DB2Exception: [IBM][JDBC
Driver] CLI0615E Error receiving from socket, server is not
responding. SQLSTATE=08S01 COM.ibm.db2.jdbc.DB2Exception: [IBM][JDBC
Driver] CLI0615E Error receiving from socket, server is not
responding. SQLSTATE=08S01 at COM.ibm.db2.jdbc.net.SQLExceptionGener-
ator.throwReceiveError(SQLExceptionGenerator.java:457) at
COM.ibm.db2.jdbc.net.DB2Request.receive(DB2Request.java:703) at
COM.ibm.db2.jdbc.net.DB2Request.sendAndRecv(DB2Request.java:563) at
COM.ibm.db2.jdbc.net.DB2Connection.SQLConnect(DB2Connection.java:341)
at COM.ibm.db2.jdbc.net.DB2Connection.SQLConnect(DB2Connection.java:-
296) at
COM.ibm.db2.jdbc.net.DB2Connection.create(DB2Connection.java:281) at
COM.ibm.db2.jdbc.net.DB2Connection.<init>(DB2Connection.java:200) at
COM.ibm.db2.jdbc.net.DB2Driver.connect(DB2Driver.java:215) at
java.sql.DriverManager.getConnection(DriverManager.java:517) at
java.sql.DriverManager.getConnection(DriverManager.java:177) at
DB2Test.DBConnect.getConnection(DBConnect.java:54) at
DB2Test.DBConnect.main(DBConnect.java:63)
java.lang.NullPointerException at
DB2Test.DBConnect.main(DBConnect.java:64) Exception in thread "main"
I don't know if there is something worng or missing with my JDBC URL or
need to be done on the DB2/Mainframe side for me to connect through JDBC
and execute sql statements.
Thanks in advance.
--
www.MainFrameForum.com - USENET Gateway