wood burning stoves 2.0*
The moose likes JDBC and the fly likes java.sql.SQLException: ORA-01006: bind variable does not exist Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "java.sql.SQLException: ORA-01006: bind variable does not exist" Watch "java.sql.SQLException: ORA-01006: bind variable does not exist" New topic
Author

java.sql.SQLException: ORA-01006: bind variable does not exist

Eva Chow
Greenhorn

Joined: Oct 08, 2012
Posts: 5
Hi,

I am learning JDBC. I copied an example from a web site, but when I ran it, I got the error java.sql.SQLException: ORA-01006: bind variable does not exist.
After looking at the code myself, I noticed that the line "ResultSet rs = stmt.executeQuery(sql);" is causing the problem. But I cannot tell what is wrong with this statement.


Here is the code.

Greg Charles
Sheriff

Joined: Oct 01, 2001
Posts: 2833
    
  11

Hi Eva,

Welcome to JavaRanch!

The problem comes when you reuse your prepared statement as an ordinary statement. You should close stmt, and then create a new statement with Connection.createStatement() to execute your static SQL.
Eva Chow
Greenhorn

Joined: Oct 08, 2012
Posts: 5
Thanks. I took your suggestion and it's working now.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: java.sql.SQLException: ORA-01006: bind variable does not exist
 
Similar Threads
JDBC: What is the concrete class that implements the jdbc interfaces
Need help with my first JDBC program
Not to execute console based jdbc application
How to create SQL server2005 database on remote machine using jdbc?
Servlet is not working