Exception while setMaxResults() - ORA-00918 error (HibernatePersistence for EJB 3.0 entity beans)
posted 8 years ago
Earlier we were using Toplink for JPA. And now we are migrating to hibernatePersistence implementation for JPA.
There are some queries where we were using setMaxResults(). Now this is giving error with the hibernatePersistence. it gives "ORA-00918 error".
If we comment the setMaxResults(), it starts working fine.
Please tell me the possible cause of the error and how to get around it.