Native Oracle Query and Hibernate Error

[puneet.bansal]

Has anybody run into an issue with Hibernate/JPA where an Oracle query
runs fine on SQL Plus but gives an error 'ORA-00900: invalid SQL
statement' when the same query is executed as a native query through
Hibernate/JPA? I can't figure out why the query would run on Oracle
client but fail when Hibernate tries to execute it.

Any ideas?

Thanks.
Puneet

 

[puneet.bansal]

Has anybody run into an issue with Hibernate/JPA where an Oracle query
runs fine on SQL Plus but gives an error 'ORA-00900: invalid SQL
statement' when the same query is executed as a native query through
Hibernate/JPA? I can't figure out why the query would run on Oracle
client but fail when Hibernate tries to execute it.

Any ideas?

Thanks.
Puneet

Alright, it was a silly mistake. I was using 'createNativeQuery'
instead of 'createNamedQuery'.

Puneet