Hibernate chokes with an error that appears to be completely unrelated (there's only a multi-column many-to-one association in PlayerStats):
Somehow Hibernate seems to be expecting a column here, but again the association is multi-column. Regarding this issue I stumbled across: http://docs.jboss.org/hibernate/core/3.3/reference/en/html/querysql.html#d0e13696
A paragraph here reads:
If the entity is mapped with a many-to-one to another entity it is required to also return this when performing the native query, otherwise a database specific "column not found" error will occur. The additional columns will automatically be returned when using the * notation...
Well, this is nice to know, but how do you avoid this error?
Here's the design: http://www.kawoolutions.com/media/hibernate-wrong-sql-playerstats.jpg
Please have a look at the PlayerStats table being connected to two other tables via a composite key of composite keys. Here's its class:
I have no idea what Hibernate is doing here. I really need some help on this.