• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Invalid Operation while accessing the query

 
Phaneendra Gugggilam
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Root Exception type="stringArray"><values>com.ibm.db2.jcc.c.SqlException: Invalid operation: parameter 1 not set or registered


Caused by: com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -313, SQLSTATE: 07001, SQLERRMC: null
at com.ibm.db2.jcc.c.tf.e(tf.java:1680)
at com.ibm.db2.jcc.c.tf.a(tf.java:1260)
at com.ibm.db2.jcc.b.jb.o(jb.java:611)
at com.ibm.db2.jcc.b.jb.j(jb.java:264)
at com.ibm.db2.jcc.b.jb.c(jb.java:57)
at com.ibm.db2.jcc.b.w.c(w.java:42)
at com.ibm.db2.jcc.b.cc.g(cc.java:178)
at com.ibm.db2.jcc.c.tf.p(tf.java:1256)
at com.ibm.db2.jcc.c.uf.d(uf.java:2344)
at com.ibm.db2.jcc.c.uf.X(uf.java:508)
at com.ibm.db2.jcc.c.uf.executeQuery(uf.java:491)
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecuteQuery(WSJdbcPreparedStatement.java:690)
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeQuery(WSJdbcPreparedStatement.java:488)
 
Muhammad Saifuddin
Ranch Hand
Posts: 1324
Android Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Root Exception type="stringArray"><values>com.ibm.db2.jcc.c.SqlException: Invalid operation: parameter 1 not set or registered


it sounds like you have missed one parameter to passed in your prepared statement.. (just guess, as I don't have an experience in db2)

would you please share your code snippet here..
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic