Hi

I'm running the following line of code...



I have a @Transient field in the Rating class I would like to cast the User.username into. In sql I would have used select rating.*, user.username AS 'username' but when I inspect the object returned the usename String is it's own object along with the rating object where the username is null.

Hope this makes sense - any help massively appreciated...

No bites?

This must be an extremely common requirement I could, maybe, put it more simply

- if you join two tables how do you take a column out of one table and stick it in a transient (non peristed column) in the other tables mapped bean?

Franzen, I would solve this differently. Inside the rating mapping file; add a property called "username". Then define that property as:


(I'm guessing at your database structure from the example you gave, so the query inside the formula attribute might no be entirely correct).

At runtime, this will cause hibernate to generate a subselect for the username property. Given that your query is fairly simple; this should work without negatively effecting performance.