Hi there!

I have two tables, one containing the master item and one containing versions for this item. The version table holds a reference to the master table called 'itemid'.

Within nhibernate (0.9.0.0), I created a simple collection mapping



and implemented the corresponding properties into the Item class.

When I run my program, I receive the error message that the attribute 'version0_.itemid' cannot be found. This error message is correct as the attribute is called 'itemid' instead. Why does nhibernate try to locate the attribute under the wrong name? How can I correct this or is this a known issue?

cheers,

Stephan

version0_ is just a NHibernate-created alias for the table, look in the FROM clause of the generated SQL to see where it comes from. This means that your problem is either a typo or wrong table or something like that.

Hi sergey,

thanks for your reply! As I'm a newbie, could you give me a hint on how to display the SQL query that is raised by the CriteriaImpl.List() invocation?

As version0_ is an alias, did I miss to enter the table name ('ItemVersion') somewhere?

Thanks,

Stephan