java DB2 program error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • anaik100
    New Member
    • Mar 2006
    • 2

    #1

    java DB2 program error

    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)
Working...