Why do I have ORA-00904 even when the column is present

Question

I see an error   while executing hibernate sql query      java sql SQLException  ORA-00904   table name   column name   invalid identifier   When I open up the table in sqldeveloper  the column is present    The error is only happening in PROD  not in DEV    What should I check

User · Answer

I use Toad for Oracle and if the table is owned by another username than the one you logged in as and you have access to read the table, you still may need to add the original table owner to the table name.

For example, lets say the table owner's name is 'OWNER1' and you are logged in as 'USER1'. This query may give you a ORA-00904 error:

select * from table_name where x='test';

Prefixing the table_name with the table owner eliminated the error and gives results:

select * from

User · Answer

It is because one of the DBs the column was created with   which makes its name case-sensitive   Oracle Table Column Name   GoodRec Hive cannot recognize case sensitivity   ERROR thrown was -  Caused by  java sql SQLSyntaxErrorException  ORA-00904   GOODREC   invalid identifier  Solution   Rename Oracle column name to all caps

User · Answer

Oracle will throw ORA-00904 if executing user does not have proper permissions on objects involved in the query

User · Answer

Have you compared the table definitions in Prod and Dev    And when you are running it in SQL Developer  are you running the query in Prod  same database as the application  and with the same user   If there are some additional columns that you are adding  using an alter command  and these changes are not yet promoted to prod  this issue is possible   Can you post the definition of the table and your actual Query

User · Answer

Write the column name in between DOUBLE quote as in  columnName    If the error message shows a different character case than what you wrote  it is very likely that your sql client performed an automatic case conversion for you  Use double quote to bypass that   This works on Squirrell Client 3 0

User · Answer

Its due to mismatch between column name defined in entity and the column name of table  in SQL db   java sql SQLException  ORA-00904   quot table name quot   quot column name quot   invalid identifier e g java sql SQLException  ORA-00904   quot STUDENT quot   quot NAME quot   invalid identifier issue can be like in Student java entity file    You have mentioned column name as  quot NAME quot  only  But in STUDENT table  column name is lets say  quot NMAE quot

User · Answer

check the position of Column annotation in java class for the field For Example consider one table with name STUDENT with 3 column Name Roll No Marks    Then make sure you have added below annotation of column before Getter Method instead of Setter method  It will solve ur problem  Column name    Name   length   100      Column name    NAME   length   100  public String getName           return name         public void setName String name        this name  name

User · Answer

It could be a case-sensitivity issue   Normally tables and columns are not case sensitive  but they will be if you use quotation marks   For example   create table bad design  goodLuckSelectingThisColumn  number

User · Answer

This happened to me when I accidentally defined two entities with the same persistent database table  In one of the tables the column in question did exist  in the other not  When attempting to persist an object  of the type referring to the wrong underlying database table   this error occurred

User · Answer

Check the username credential used to login to the database   persistence xml      The problem mostly is  the username password used to login to the database  does not have visiblity to the object  table name in this case     try logging in to sql developer  using the same username password available in your data source

[oracle] Why do I have ORA-00904 even when the column is present?

Examples related to oracle

Examples related to oracle10g

Examples related to ora-00904