Hi there
I have am using hibernate annotation. I would like to create a read-only calculated field which comprises of the difference between the end and start dates, which are both mapped fields in my annotation.

After reviewing the docs, I tried to do this:




This does NOT work - after running the query, I receive this exception:
Caused by: org.hibernate.AnnotationException: java.util.Date collection not yet supported: com.prod.repository.Sessionduration


Any idea as to how to corerctly define and use the @formula annotation??

Thanks
E.


Hibernate version:
3.1
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:

I find this error hard to believe.
Debug you code to find the offending declaration.

Thank you for your informative reply.
I am grateful for the time you took out to assist me.

It seems that *EVERY* variable I have tried to use with the @formula annotation has given me this exception - ints, shorts, whatever. I have tried putting SQL statements in the formula or just place column numbers - the result is the same.


ANy idea?


Any other informative replies will be extremely welcome!

E.

the only way I can see that happen is if you add @OneTOMany or @ManyToMany on formula.
Use your debugger to see what happen in HA