am trying to run a java db2 program. my db2 is in os/390.
below is the code
public class T4DB2Connect {
public static void main(String[] args) {
try {
// load the DB2 Driver
System.out.prin tln("1" );
Class.forName(" COM.ibm.db2os39 0.sqlj.jdbc.DB2 SQLJDriver");
// establish a connection to DB2
System.out.prin tln("2" );
Connection db2Conn = DriverManager.g etConnection("j dbc b2://host ip address/db name","user id","passwd") ;
System.out.prin tln("3" );
Statement st = db2Conn.createS tatement();
System.out.prin tln("4" );
String query =
"SELECT A.BJB_SCSJB_NM FROM CRYWTBT.TBSUC_J OBS A ,CRYWTBT.TBPRD_ JOBS B, CRYWTBT.TBJOB_F REQ C WHERE A.BJB_NM ='CLR606AM' AND A.BJB_NM=B.BJB_ NM AND B.BJB_NM=C.BJB_ NM";
ResultSet resultSet = st.executeQuery (query);
System.out.prin tln("Job " + "\tAverage Salary");
System.out.prin tln("-----" + "\t--------------");
while (resultSet.next ()) {
String jobType = resultSet.getSt ring(1);
System.out.prin tln(jobType );
}
resultSet.close ();
st.close();
db2Conn.close() ;
} catch (ClassNotFoundE xception cnfe) {
cnfe.printStack Trace();
} catch (SQLException sqle) {
sqle.printStack Trace();
}
}
}
the error is
1
2
com.ibm.db2.jcc .b.DisconnectEx ception: Execution failed due to a distribution pr
otocol error that caused deallocation of the conversation. A DRDA Data Stream S
yntax Error was detected. Reason: 0x3
at com.ibm.db2.jcc .a.ab.l(ab.java :1214)
at com.ibm.db2.jcc .a.ab.c(ab.java :363)
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:1 232)
at com.ibm.db2.jcc .a.b.b(b.java:1 147)
at com.ibm.db2.jcc .a.b.q(b.java:9 31)
at com.ibm.db2.jcc .a.b.a(b.java:7 02)
at com.ibm.db2.jcc .a.b.(b.java:30 5)
at com.ibm.db2.jcc .DB2Driver.conn ect(DB2Driver.j ava:162)
at java.sql.Driver Manager.getConn ection(DriverMa nager.java:512)
at java.sql.Driver Manager.getConn ection(DriverMa nager.java:171)
at T4DB2Connect.ma in(T4DB2Connect .java:16)
when i tried to change the jdbc connection to
Connection db2Conn = DriverManager.g etConnection("j dbc b2os390://host ip address/db name","user id","passwd") ;
the error
com.ibm.db2.jcc .b.SqlException : Deprecated DB2 OS/390 protocol not supported by
T4: jdbc b2os390://host ip address/db name
Use protocol jdbc b2:
at com.ibm.db2.jcc .DB2Driver.conn ect(DB2Driver.j ava:98)
at java.sql.Driver Manager.getConn ection(DriverMa nager.java:512)
at java.sql.Driver Manager.getConn ection(DriverMa nager.java:171)
at T4DB2Connect.ma in(T4DB2Connect .java:16)
below is the code
public class T4DB2Connect {
public static void main(String[] args) {
try {
// load the DB2 Driver
System.out.prin tln("1" );
Class.forName(" COM.ibm.db2os39 0.sqlj.jdbc.DB2 SQLJDriver");
// establish a connection to DB2
System.out.prin tln("2" );
Connection db2Conn = DriverManager.g etConnection("j dbc b2://host ip address/db name","user id","passwd") ;
System.out.prin tln("3" );
Statement st = db2Conn.createS tatement();
System.out.prin tln("4" );
String query =
"SELECT A.BJB_SCSJB_NM FROM CRYWTBT.TBSUC_J OBS A ,CRYWTBT.TBPRD_ JOBS B, CRYWTBT.TBJOB_F REQ C WHERE A.BJB_NM ='CLR606AM' AND A.BJB_NM=B.BJB_ NM AND B.BJB_NM=C.BJB_ NM";
ResultSet resultSet = st.executeQuery (query);
System.out.prin tln("Job " + "\tAverage Salary");
System.out.prin tln("-----" + "\t--------------");
while (resultSet.next ()) {
String jobType = resultSet.getSt ring(1);
System.out.prin tln(jobType );
}
resultSet.close ();
st.close();
db2Conn.close() ;
} catch (ClassNotFoundE xception cnfe) {
cnfe.printStack Trace();
} catch (SQLException sqle) {
sqle.printStack Trace();
}
}
}
the error is
1
2
com.ibm.db2.jcc .b.DisconnectEx ception: Execution failed due to a distribution pr
otocol error that caused deallocation of the conversation. A DRDA Data Stream S
yntax Error was detected. Reason: 0x3
at com.ibm.db2.jcc .a.ab.l(ab.java :1214)
at com.ibm.db2.jcc .a.ab.c(ab.java :363)
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:1 232)
at com.ibm.db2.jcc .a.b.b(b.java:1 147)
at com.ibm.db2.jcc .a.b.q(b.java:9 31)
at com.ibm.db2.jcc .a.b.a(b.java:7 02)
at com.ibm.db2.jcc .a.b.(b.java:30 5)
at com.ibm.db2.jcc .DB2Driver.conn ect(DB2Driver.j ava:162)
at java.sql.Driver Manager.getConn ection(DriverMa nager.java:512)
at java.sql.Driver Manager.getConn ection(DriverMa nager.java:171)
at T4DB2Connect.ma in(T4DB2Connect .java:16)
when i tried to change the jdbc connection to
Connection db2Conn = DriverManager.g etConnection("j dbc b2os390://host ip address/db name","user id","passwd") ;
the error
com.ibm.db2.jcc .b.SqlException : Deprecated DB2 OS/390 protocol not supported by
T4: jdbc b2os390://host ip address/db name
Use protocol jdbc b2:
at com.ibm.db2.jcc .DB2Driver.conn ect(DB2Driver.j ava:98)
at java.sql.Driver Manager.getConn ection(DriverMa nager.java:512)
at java.sql.Driver Manager.getConn ection(DriverMa nager.java:171)
at T4DB2Connect.ma in(T4DB2Connect .java:16)