aspose file tools*
The moose likes JDBC and the fly likes java.sql.SQLException: Missing IN or OUT parameter at index::2 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "java.sql.SQLException: Missing IN or OUT parameter at index::2" Watch "java.sql.SQLException: Missing IN or OUT parameter at index::2" New topic
Author

java.sql.SQLException: Missing IN or OUT parameter at index::2

Aruna Gopalakrishnan
Greenhorn

Joined: Feb 14, 2002
Posts: 8
Hi,
I am getting the following error when i am trying store a record into a table using PreparedStatement..
java.sql.SQLException: Missing IN or OUT parameter at index::2
What is meant by this error. if any body knows how to solve this issue, please let me know.
Thanks
Aruna Gopalakrishnan


Best Regards<br />Aruna G
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

it sounds like you didn't bind a value to your callable statement at index 2, the second question mark in your SQL statement.
If the problem runs deeper than this, you'll have to post a code snippet of the code that is causing you problems.
Jamie
 
Don't get me started about those stupid light bulbs.
 
subject: java.sql.SQLException: Missing IN or OUT parameter at index::2