I have two classes - AddressList and UserAccount. The AddressList class has a foreign-key to UserAccount. Technically, it's a one-to-one, but I've set it up as a many-to-one as per the docs, as it's a unique foreign-key - the address_list_id does not match the user_account_id in nearly all cases.

Here's the mapping:

<hibernate-mapping>
<class name="stresstest.hibernate.AddressList" table="address_list">
<id name="AddressListID" column="address_list_id" type="java.lang.Long">
<generator class="identity"/>
</id>
<many-to-one name="UserAccountID" class="stresstest.hibernate.UserAccount" column="user_account_id"/>
</class>
</hibernate-mapping>

<hibernate-mapping>
<class name="stresstest.hibernate.UserAccount" table="user_account">
<id name="ID" column="user_account_id" type="java.lang.Long">
<generator class="identity"/>
</id>
</class>
</hibernate-mapping>

And here's the getter/setter methods of the classes

public class AddressList
{
...
public void setUserAccountID(Long ua)
{
m_lUserAccountID = ua;
}
public Long getUserAccountID()
{
return m_lUserAccountID;
}
...
}

public class UserAccount
{
...
public void setID(Long id)
{
m_lUserAccountID = id;
}
public Long getID()
{
return m_lUserAccountID;
}

public void setUserAccountID(Long id)
{
setID(id);
}
public Long getUserAccountID()
{
return getID();
}
...
}

And here's the error:

Hibernate: select addresslis0_.address_list_id as address_1_1_, addresslis0_.user_account_id as user_acc2_1_, useraccoun1_.user_account_id as user_acc1_0_ from address_list addresslis0_ left outer join user_account useraccoun1_ on addresslis0_.user_account_id=useraccoun1_.user_account_id where addresslis0_.address_list_id=?

net.sf.hibernate.PropertyAccessException: IllegalArgumentException occurred while calling setter of stresstest.hibernate.AddressList.UserAccountID

If I remove the many-to-one mapping in AddressList and replace it with a <property.../>, the problem disappears. That is a bit confusing - the UserAccountID is still there, and still needs to be set; why an exception just because it's a many to one?

My initial inclination was that their was a disconnect in the parameter of the setter - long vs Long (or maybe int vs Long) but playing around, and making sure I was using type="java.lang.Long" didn't fix the problem.

It would be nice if Hibernate said what type of parameter it was trying to give to the setter.

uhm... wheres you one-to-many?

I still dont understand why you want to use one-to-many ..

oopss sorry... read wrong...

the many-to-one will give you an instance of UserAccount in your case.

try changing


to (change m_lUserAccountID from long to UserAccount)




hope it helps[/code]

Duh - thanks - that makes perfect sense.

Like I said, it would be a great debugging feature if Hibernate would tell you the type of object it was trying to set....

Thanks again.
David.