Win a copy of Event Streams in Action this week in the Java in General forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Devaka Cooray
  • Liutauras Vilda
  • Jeanne Boyarsky
  • Bear Bibeault
Sheriffs:
  • Paul Clapham
  • Knute Snortum
  • Rob Spoor
Saloon Keepers:
  • Tim Moores
  • Ron McLeod
  • Piet Souris
  • Stephan van Hulst
  • Carey Brown
Bartenders:
  • Tim Holloway
  • Frits Walraven
  • Ganesh Patekar

Prepared statment executeQuery() error.

 
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ?
 
author & internet detective
Posts: 39396
763
Eclipse IDE VI Editor Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
 
Karthik Krishna
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!