File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Prepared Statement  Error Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Prepared Statement  Error" Watch "Prepared Statement  Error" New topic

Prepared Statement Error

Madhavan Sundararajan

Joined: Jan 06, 2004
Posts: 3
Can I use a prepared statement to execute "select" queries? I get an error when I try to use it using JDBC..Here is the following error
SQL Exception from class SqlArrayTest executeStashQuery method java.sql.SQLException: ORA-01008: not all variables bound
Here is my query
Pls clarify at the earliest
Wayne L Johnson
Ranch Hand

Joined: Sep 03, 2003
Posts: 399
Assuming that "STOREID" is an integer value, you need to make sure you call ".setInt(1, xxx);" on the prepared statement, where "xxx" is the int value you are searching on. This has to be done before you call "executeQuery()" on the prepared statement.
When you set up a prepared statement, the question marks (?) represent parameters that you will specify at execution time. For every parameter [?] in the query, you must call the appropriate setXXX() method. The error message you're getting seems to indicate that your parameter wasn't bound to a value, meaning you hadn't called "setInt()" before executing the query.
If this isn't your problem, please show us your code fragment.
[ February 18, 2004: Message edited by: Wayne L Johnson ]
I agree. Here's the link:
subject: Prepared Statement Error
It's not a secret anymore!