DB2 SQL error: SQLCODE: -551, SQLSTATE: 42501

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • 098765
    New Member
    • Aug 2007
    • 1

    #1

    DB2 SQL error: SQLCODE: -551, SQLSTATE: 42501

    Hi All,

    Since last couple of week i am trying to connect to QA box. But i am getting error. Strange thing is that i can connect to DEV box using same code. Please let me know what is the possible solution.

    I am able to get connection. I am able to create statement but whenever program goign to line execute it throws error as below:

    Here is my code:

    Connection dbconn = null;
    PreparedStateme nt pstmt = null;
    ResultSet rs = null;
    String sqlQuery = "select seqname from SYSIBM.SYSSEQUE NCES";
    Class.forName(" com.ibm.db2.jcc .DB2Driver");
    dbconn = DriverManager.g etConnection"jd bc:db2://host:port/dbname", "user",
    "passw");
    System.out.prin tln("Connection :"+dbconn);
    pstmt = dbconn.prepareS tatement(sqlQue ry);
    System.out.prin tln("Created stmt:"+pstmt);
    rs = pstmt.executeQu ery();
    System.out.prin tln("got resultset:"+rs) ;

    Error:

    com.ibm.db2.jcc .b.SqlException : DB2 SQL error: SQLCODE: -551, SQLSTATE: 42501, SQLERRMC: ACPUSER;EXECUTE ;NULLID.SYSSH20 0
    at com.ibm.db2.jcc .b.zc.e(zc.java :1606)
    at com.ibm.db2.jcc .b.zc.a(zc.java :1206)
    at com.ibm.db2.jcc .a.db.h(db.java :149)
    at com.ibm.db2.jcc .a.db.a(db.java :43)
    at com.ibm.db2.jcc .a.r.a(r.java:3 0)
    at com.ibm.db2.jcc .a.sb.g(sb.java :152)
    at com.ibm.db2.jcc .b.zc.n(zc.java :1186)
    at com.ibm.db2.jcc .b.ad.db(ad.jav a:1761)
    at com.ibm.db2.jcc .b.ad.d(ad.java :2203)
    at com.ibm.db2.jcc .b.ad.U(ad.java :489)
    at com.ibm.db2.jcc .b.ad.executeQu ery(ad.java:472 )
Working...