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