File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and Relational Databases and the fly likes Invalid Operation while accessing  the query Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Meteor in Action this week in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Invalid Operation while accessing  the query" Watch "Invalid Operation while accessing  the query" New topic
Author

Invalid Operation while accessing the query

Phaneendra Gugggilam
Greenhorn

Joined: Sep 23, 2008
Posts: 14
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

Joined: Dec 06, 2005
Posts: 1321

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


Saifuddin..
[Blog][Linkedin] How To Ask Questions On JavaRanch My OpenSource
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Invalid Operation while accessing the query