oracle SQL 错误：904，SQLState：42000 ORA-00904：：标识符无效
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/39297701/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
SQL Error: 904, SQLState: 42000 ORA-00904: : invalid identifier
提问by sam_evang
Can below scenario of duplicate alias lead to an error when executed from JDBC or hibernate:
从 JDBC 或 hibernate 执行时，以下重复别名的情况是否会导致错误：
SQL Error: 904, SQLState: 42000 ORA-00904: : invalid identifier
SQL 错误：904，SQLState：42000 ORA-00904：：标识符无效
select * From table_master VW
LEFT OUTER JOIN TABLE(test_func(1, 300)) vw
ON VW.table_key = vw.function_key
Facing this in production only. It works fine in test environment.
仅在生产中面临这一点。它在测试环境中运行良好。
回答by Davel_AG
In my case the DB field didn't exist, and it was returning SQL Error: 904, SQLState: 42000 ORA-00904: : invalid identifier
在我的例子中，DB 字段不存在，它返回 SQL Error: 904, SQLState: 42000 ORA-00904:: invalid identifier
After Creating the field, of course it worked,
创建字段后，当然它起作用了，
Double check those fields and make sure they are matching...
仔细检查这些字段并确保它们匹配...
Hope it may give you a clue to find the issue
希望它可以为您提供查找问题的线索
回答by kolle_86
In my case I missed @ManyToOne(fetch = FetchType.EAGER)on that @JoinColumn
就我而言，我错过@ManyToOne(fetch = FetchType.EAGER)了@JoinColumn
