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:


In SQL I can do
" select T1.col1 - T2.col1 as value from Table1 T1, Table1 T2 where T1.name = 'd'"

I am trying to do the same with HQL only replacing it as

"Select T1.col1 - T2.col1 as value from com.entity.Table1 T1, com.entity.Table1 T2 where T1.name = 'd'"

Not getting it to work.

Is there any way i get the differnece b/w columns

Dinu

hql recognize arithmetic expression in select - you have another error in your mapping or POJO class