This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes Oracle/OAS and the fly likes invalid identifier Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "invalid identifier" Watch "invalid identifier" New topic

invalid identifier

Joe Jose
Ranch Hand

Joined: Jan 14, 2004
Posts: 125

I have a strange problem. I have loaded an application in live server, but it shows some 'SQLException: ORA-00904 : invalid identifier 'in one of the java class files. The data in the test server is working fine. The same test files is loaded into the live server. Identifiers looks same . I cannt see any errors obviously. I am working with java,tomcat and Oracle.

The class files are same in test and live servers. Could you think of any other reasons for this error ?

Mark Spritzler

Joined: Feb 05, 2001
Posts: 17249

Maybe the database tables, indexes, constraints are different between the databases? Or are they pointing to the same database/schema?


Perfect World Programming, LLC - Two Laptop Bag - Tube Organizer
How to Ask Questions the Smart Way FAQ
Joe Jose
Ranch Hand

Joined: Jan 14, 2004
Posts: 125
I got it solved. There was no roles selecting for the user to access the table and the wrong table(old table) was selcting that user.

Thank you very much for the answer.
I agree. Here's the link:
subject: invalid identifier
Similar Threads
Same Class name & package name for 2 classes
ClassLoader Problem while Testing.
skeleton not creating
Running a RMI Application
dependent class problem