blocks|key|2972613|text|ORA-00904-invalid+identifier错误通常由区分大小写的问题引起。通常，Oracle表和列不区分大小写，不能包含标点符号和空格。但是，如果您使用双引号来创建带引号的标识符，则必须始终使用双引号和正确的大小写来引用该标识符。例如：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2972614|create+table+bad_design("goodLuckSelectingThisColumn++"+number);|code-block|syntax|javascript|2972615|entityMap^0|0|S|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|P|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|D|@]|E|$]]]|L|$]]

<code>ORA-00904-invalid identifier</code> errors are frequently caused by case-sensitivity issues. Normally, Oracle tables and columns are not case sensitive and cannot contain punctuation marks and spaces. But if you use double quotes to create a quoted identifier, that identifier must always be referenced with double quotes and with the correct case. For example:
<pre><code>create table bad_design(&quot;goodLuckSelectingThisColumn &quot; number);
</code></pre>

blocks|key|269649|text|如果执行用户对查询中涉及的对象没有适当的权限，则Oracle将抛出ORA-00904。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|269650|entityMap^0|X|9|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

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

blocks|key|3186506|text|当我不小心定义了两个具有相同持久化数据库表的实体时，就会发生这种情况。在其中一个表中，有问题的列确实存在，而在另一个表中则不存在。当试图持久化一个对象(其类型引用了错误的底层数据库表)时，会发生此错误。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3186507|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

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.

blocks|key|271761|text|将列名写在双引号之间，如"columnName“。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|271762|如果错误消息显示的大小写与您编写的字符大小写不同，则很可能是您的sql客户端为您执行了自动大小写转换。使用双引号可以绕过这一点。(这适用于Squirrell+Client+3.0)。|271763|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

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).

blocks|key|271785|text|这是因为该列的其中一个DB是用“创建的，这使得它的名称区分大小写。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|271786|Oracle表列名称:+GoodRec配置单元无法识别大小写:抛出的错误是-由:+java.sql.SQLSyntaxErrorException:+ORA-00904："GOODREC"：无效标识符|271787|解决方案:将Oracle列名重命名为全部大写。|271788|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

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.

blocks|key|3186535|text|检查字段的列注释在java类中的位置例如，考虑一个名为学生的表，其中有3列(+name，Roll_No，Marks)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3186536|然后确保在Getter方法而不是Setter方法之前添加了列的注释。它将解决您问题列@(名称=“名称”，长度=+100)|offset|length|style|BOLD|3186537|**@Column(name+=+"NAME",+length+=+100)
public+String+getName()+{**
++++return+name;
}

++++public+void+setName(String+name)+{
++++this.name=+name;
}|code-block|syntax|javascript|3186538|entityMap^0|0|U|U|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@$D|Q|E|R|F|G]]|9|@]|A|$]]|$1|H|3|I|5|J|7|S|8|@]|9|@]|A|$K|L]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

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)

<pre><code>**@Column(name = "NAME", length = 100)
public String getName() {**
 return name;
}

 public void setName(String name) {
 this.name= name;
}
</code></pre>

blocks|key|3186292|text|您是否比较过Prod和Dev中的表定义？|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3186293|当您在SQL+Developer中运行它时，您是否使用相同的用户在Prod+(与应用程序相同的数据库)中运行查询？|3186294|如果您(使用alter命令)添加了一些附加列，并且这些更改尚未升级到prod，则可能会出现此问题。|3186295|你能发布表的定义和你的实际查询吗？|3186296|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|L|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|M|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

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?

blocks|key|273356|text|看起来Oracle在很多情况下都抛出了这个错误。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|273357|对我来说，它被抛出了，因为我试图限定连接部分的using子句中使用的列。这两种方法都不起作用：|offset|length|style|CODE|273358|select+table1.x+--+doesn't+work
from+table1
join+table2+using+(x);

select+t1.x+--+doesn't+work
from+table1+t1
join+table2+t2+using(x);|code-block|syntax|javascript|273359|这是因为我们可以在不使用表名和别名的情况下限定using子句中的列。正确的方法应该是：|273360|select+x
from+table1
join+table2+using+(x);

select+x
from+table1+t1
join+table2+t2+using(x);|273361|entityMap^0|0|N|5|0|0|N|5|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@$D|U|E|V|F|G]]|9|@]|A|$]]|$1|H|3|I|5|J|7|W|8|@]|9|@]|A|$K|L]]|$1|M|3|N|5|6|7|X|8|@$D|Y|E|Z|F|G]]|9|@]|A|$]]|$1|O|3|P|5|J|7|10|8|@]|9|@]|A|$K|L]]|$1|Q|3|-4|5|6|7|11|8|@]|9|@]|A|$]]]|R|$]]

Seems like Oracle is throwing this error in many cases.
For me it was thrown, because I tried to qualify a column that was used in <code>using</code> clause in the join part. None of there two will work:
<pre><code>select table1.x -- doesn't work
from table1
join table2 using (x);

select t1.x -- doesn't work
from table1 t1
join table2 t2 using(x);
</code></pre>
It's because we can qualify the column from <code>using</code> clause with neither table name nor alias. The correct way would be:
<pre><code>select x
from table1
join table2 using (x);

select x
from table1 t1
join table2 t2 using(x);
</code></pre>

blocks|key|3186678|text|我看到这个错误的原因与上面给出的原因略有不同：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3186679|我使用了一个liquibase脚本来修改我已经存在的(Oracle)表。一切看起来都很好，但是我的代码中的插入失败了。只有当我看到SQL+Developer的自动完成功能给我加上引号时，我才发现在创建时列名后面附加了一个空格。|3186680|令人不快的liquibase行看起来像这样(+'MY_FIELD‘结束引号前的单个空格)：|3186681|<addColumn+tableName="MY_TABLE">
++++<column+name="MY_FIELD+"+type="tinyint"+defaultValueNumeric="3">
++++++++<constraints+nullable="false"/>
++++</column>
</addColumn>|code-block|syntax|javascript|3186682|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|O|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|P|8|@]|9|@]|A|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

I was seeing this error for a slightly different reason to those given above:
I'd used a liquibase script to modify my already-existing (Oracle) table. Everything looked fine but the inserts in my code were failing. Only when I saw that I was being offered enclosing quotes by SQL Developer's auto-completion did I see that a space had been appended to the column name at creation.
The offending liquibase changeSet line looked like this (single space before the 'MY_FIELD' closing quote):
<pre><code>&lt;addColumn tableName=&quot;MY_TABLE&quot;&gt;
 &lt;column name=&quot;MY_FIELD &quot; type=&quot;tinyint&quot; defaultValueNumeric=&quot;3&quot;&gt;
 &lt;constraints nullable=&quot;false&quot;/&gt;
 &lt;/column&gt;
&lt;/addColumn&gt;
</code></pre>

blocks|key|273261|text|我使用Toad+for+Oracle，如果该表的所有者不是您登录时所用的用户名，并且您有权读取该表，则您可能仍需要将原始表所有者添加到表名中。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|273262|例如，假设表所有者的名称是'OWNER1‘，而您以'USER1’的身份登录。此查询可能会显示ORA-00904错误：|273263|select+*+from+table_name+where+x='test';|code-block|syntax|javascript|273264|使用表所有者作为table_name的前缀消除了错误，并给出了结果：|273265|select+*+from+|273266|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|Q|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|R|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|S|8|@]|9|@]|A|$G|H]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

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:

<pre><code>select * from table_name where x='test';
</code></pre>

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

<pre><code>select * from 
</code></pre>

blocks|key|273349|text|这是由于entity中定义的列名与表的列名(在SQL+db中)之间的不匹配|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|273350|java.sql.SQLException:+ORA-00904："table_name"."column_name"：无效标识e.g.java.sql.SQLException:+ORA-00904：“学生”.“NAME”：无效标识|273351|问题可以类似于Student.java(实体文件)。|273352|您提到的列名仅为"+name“。|273353|但是在学生表中，列名是"NMAE“|273354|entityMap^0|Y|3|0|0|39|0|0|Q|0|0|G|0|0|H|0^^$0|@$1|2|3|4|5|6|7|P|8|@$9|Q|A|R|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|S|8|@$9|T|A|U|B|C]]|D|@]|E|$]]|$1|H|3|I|5|6|7|V|8|@$9|W|A|X|B|C]]|D|@]|E|$]]|$1|J|3|K|5|6|7|Y|8|@$9|Z|A|10|B|C]]|D|@]|E|$]]|$1|L|3|M|5|6|7|11|8|@$9|12|A|13|B|C]]|D|@]|E|$]]|$1|N|3|-4|5|6|7|14|8|@]|D|@]|E|$]]]|O|$]]

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;

blocks|key|3186667|text|检查Oracle中的同义词声明。我调用了一个PL/SQL函数，如下所示，它给出了java.sql.SQLSyntaxErrorException:+ORA-00904:无效标识符|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3186668|select+oracle_my_pkg.notify_list_function+from+dual|code-block|syntax|javascript|3186669|在声明了oracle_my_pkg的公共同义词之后，错误消息消失了|3186670|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Check for synonym declaration in Oracle. I was calling an PL/SQL function as below and it was giving java.sql.SQLSyntaxErrorException: ORA-00904: invalid identifier
<pre><code>select oracle_my_pkg.notify_list_function from dual
</code></pre>
after declaring a public synonym for oracle_my_pkg the error message was gone

blocks|key|275083|text|检查用于登录数据库的用户名凭据。(persistence.xml+??)。主要的问题是，用于登录数据库的用户名\密码对对象(在本例中为table_name)是不可见的。(尝试使用数据源中提供的相同用户名\密码登录到sql+developer+)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|275084|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

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)

blocks|key|275318|text|创建一个新表。但不要给出“(双引号)”中的值，这看起来是唯一的解决方案|type|unstyled|depth|inlineStyleRanges|entityRanges|data|275319|create+table+bad_design(goodLuckSelectingThisColumn++number);|code-block|syntax|javascript|275320|安装，安装|275321|create+table+bad_design("goodLuckSelectingThisColumn++"+number);|275322|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

create a new table.
but don't give the values in &quot;(double quotes)
that's look like only solution
<pre><code>create table bad_design(goodLuckSelectingThisColumn number);
</code></pre>
insted of
<pre><code>create table bad_design(&quot;goodLuckSelectingThisColumn &quot; number);
</code></pre>

I see an error while executing hibernate sql query.

<blockquote>
 java.sql.SQLException: ORA-00904: "table_name"."column_name": invalid identifier
</blockquote>

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?

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

数据库

我在执行hibernate sql查询时看到一个错误。 java.sql.SQLException: ORA-00904：“table_name”，“column_name”标识无效当我在sqldeveloper中打开该表时，该列已经存在。错误仅发生在PROD中，而不是DEV中。我应该检查什么？

问为什么我有ORA-00904，即使有列存在？
EN

回答 14

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问为什么我有ORA-00904，即使有列存在？EN

回答 14

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问为什么我有ORA-00904，即使有列存在？
EN