wierd exception from hibernate

sweta · **Joined:** Fri Aug 12, 2005 11:18 am **Posts:** 2

select (max(cast(employer_num as bigint)) + 1) as NextNum from Employer where client_id = 97 and isNumeric(employer_num) = 1

this statement works in sql but hibernate is throwing exception like ( expected before).

any ideas

jdl · **Joined:** Thu May 26, 2005 2:08 pm **Posts:** 99

Are you trying to convert this to HQL or run it as a SQLQuery?

Also, pay special attention to the sections in the posting form that ask for your code, the SQL generated, and stack traces.

Quote:

Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

sweta · **Joined:** Fri Aug 12, 2005 11:18 am **Posts:** 2

I am new to hibernate and i am trying to run this as getHibernateTemplate().find()

sven · **Posted:** Fri Aug 12, 2005 11:41 am

Post your code as well as the exception.

Best regards
Sven

chiAndy · **Posted:** Fri Aug 12, 2005 1:07 pm

I would venture a guess that hibernate is probably trying to parse that to HQL.

http://www.hibernate.org/hib_docs/v3/reference/en/html/querysql.html#querysql-namedqueries

contains some information that might be helpful in this case. If you want just a single integer value returned, then using a named query might be the way to go.