Native Oracle Query and Hibernate Error

Thread view:

puneet.bansal@wipro.com - 11 Jun 2007 16:06 GMT

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

Reply to this Message

puneet.bansal@wipro.com - 11 Jun 2007 16:30 GMT

On Jun 11, 10:06 am, puneet.ban...@wipro.com wrote:

> 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
[quoted text clipped - 6 lines]
> Thanks.
> Puneet

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

Puneet

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...