GeeCON Prague 2014*
The moose likes JDBC and the fly likes Prepared statment executeQuery() error. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Bookmark "Prepared statment executeQuery() error." Watch "Prepared statment executeQuery() error." New topic
Author

Prepared statment executeQuery() error.

Karthik Krishna
Greenhorn

Joined: Sep 02, 2008
Posts: 11
Hi,

I have the following query in a class, and when this class hits the line ps.executeQuery() I get an exception which says " ORA-01006: bind variable does not exist "

I have been trying to work towards different solutions but i do not understand why the ps.executeQuery fails ? does it have anything to do with the nested queries ? Can I have an inline query and the " ps.setString(1, monthYear);ps.setString(2, monthYear);ps.setString(3, monthYear); " can still substitute the values in the inside query ?

Could some one help me out ?


Pass on the knowledge!!
Jeanne Boyarsky
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 30598
    
154

I've added code tags to make it more readable.

I only see 3 "?" bind variables in the query. How does the fourth one fit in?


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Karthik Krishna
Greenhorn

Joined: Sep 02, 2008
Posts: 11
Sorry Jeanne

I am just mimicking a situation which I am encountering and for a few reasons I cannot copy paste the code in here so I am just replicating the issue in here.
You could just comment out the following from line 77 through 80.


# if (!fId.equals("91"))
# {
# ps.setString(4, fId);
# }

And another tiny correction line 38 is missing a bracket.
 
GeeCON Prague 2014
 
subject: Prepared statment executeQuery() error.