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 Java.sql.SQLException invalid indentifier exception 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 "Java.sql.SQLException invalid indentifier exception" Watch "Java.sql.SQLException invalid indentifier exception" New topic

Java.sql.SQLException invalid indentifier exception

Yuta Lolap
Ranch Hand

Joined: Jun 03, 2012
Posts: 83

Hey all,

Please can you help me?I am getting the following error.

java.sql.SQLException: [Oracle][ODBC][Ora]ORA-00904: "CUST001": invalid identifier

I am working on a monthly billing system for general stores. I enter the ITEMID and click the button. The ITEMID is stored in a variable and searched for item details from the ITEMS table which are then entered into PURCHASE table along with a previously retrieved CUSTOMERID in this case the customerid is CUST001.

Following is the code of the button click event.
Ashwini Kashyap
Ranch Hand

Joined: Aug 30, 2012
Posts: 90
String query1 = "Select * from items where itemcode =" +itemcodepass;

I suppose above statement is the root cause.
All you need to do is, try putting itemcodepass in quotes like:
String query1 = "Select * from items where itemcode =" + "\' ''+ itemcodepass + "\' '';

Ashwini Kashyap

Rob Spoor

Joined: Oct 27, 2005
Posts: 19843

Or even better, use PreparedStatement.

How To Ask Questions How To Answer Questions
I agree. Here's the link:
subject: Java.sql.SQLException invalid indentifier exception