File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes XML and Related Technologies and the fly likes Urgent !!! Prepared Statement Problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Engineering » XML and Related Technologies
Reply locked New topic

Urgent !!! Prepared Statement Problem

Shanmugam Muthukumarasamy
Ranch Hand

Joined: Jan 11, 2003
Posts: 83
Hi All,
In my application, at runtime, I am getting the following exception:
Description: Class: FdpMbrDatesData Method: executeQuery() : SQLException
java.sql.SQLException: ORA-01008: not all variables bound
I am not able to guess what is the problem with the following portion of the code.
pstmt = rO_conn.prepareStatement(lS_SQLStatement);

pstmt = this.setBindParams(pstmt);

int ii_position = 1;
//set timestamp of query; Take stamp before query as this is the most conservative view
super.setSQLDateTimeStamp(new java.util.Date());
rs = pstmt.executeQuery();

While crossing the "pstmt.executeQuery()" it is throwing the above exception.
It is very Urgent...If any body have any idea please let me know.
Thanks in advance,

SJCP 1.4<br />SCWCD 1.4<br />SCEA
Balaji Loganathan
author and deputy

Joined: Jul 13, 2001
Posts: 3150
Please post ur in JDBC forumsomeone there will sure help you.

Spritle Software Blogs
It is sorta covered in the JavaRanch Style Guide.
subject: Urgent !!! Prepared Statement Problem
jQuery in Action, 3rd edition