Hibernate version: 3.1.2

Full stack trace of any exception that occurs:
Caused by: org.hibernate.MappingException: Could not determine type for: de.innovalan.jpelas.domain.impl.User, for columns: [org.hibernate.mapping.Formula( (SELECT p.created_by FROM Post p, Thread t WHERE p.thread_id = thread_id ORDER BY p.created_at DESC LIMIT 1) )]
at org.hibernate.mapping.SimpleValue.getType(SimpleValue.java:266)
at org.hibernate.mapping.SimpleValue.isValid(SimpleValue.java:253)
at org.hibernate.mapping.Property.isValid(Property.java:185)
at org.hibernate.mapping.PersistentClass.validate(PersistentClass.java:395)
...

In the Entity "Post" the property "createdBy" of type "User" is mapped to "created_by". The primary key of "User" is an int.

I'm trying to use a Formula for a field in a Class "Thread":
@Formula("(SELECT p.created_by FROM Post p, Thread t WHERE p.thread_id = thread_id ORDER BY p.created_at DESC LIMIT 1)")
private User lastPostBy;

This should give me the User that created the Post that has the highest value in "created_at".

I even tried
@Formula("FROM User u where u.user_id = (SELECT p.created_by FROM Post p, Thread t WHERE p.thread_id = thread_id ORDER BY p.created_at DESC LIMIT 1)")
with no success.

Is mapping with Formulas only available to "build-in basic"-types? Or am I missing the clue to how to use it with custom types?

Thanks in advance!

Sven

PS: "User" is mapped properly as I can load it with the Sessions load()-method.

I found out that I would have to use @ManyToOne with this. But many-to-one can only be configured to use a formula when configuring via mapping.xml-configfile, as @ManyToOne does not support @Formula. See here: http://opensource2.atlassian.com/projec ... se/ANN-210
Is there any known workaround?

I just found out, that this thread is a dupe to: http://forum.hibernate.org/viewtopic.php?t=953425

Just ignore this. :)