Invalid Operation while accessing the query

[Phaneendra Gugggilam]

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]

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