I have two tables
- account table with account_id SERIAL (from sequence) PK
- user_info with id SERIAL (from another sequence) PK AND
with account_id NOT NULL FK referencing account.account_id

I want these table to be related one-to-one through unique FK of user_info table.
I'm using Hibernate 2.1 property-ref feature to get right property association like this:
Account.hbm.xml
--------------------
<one-to-one
name="userInfo"
class="com.simpy.model.UserInfo"
cascade="all"
outer-join="auto"
constrained="false"
property-ref="accountId"
/>

and in UserInfo.hbm.xml I did this
-----------------------------------------
<property
name="accountId"
type="integer"
update="true"
insert="true"
column="account_id"
not-null="false"
unique="true"
/>

<one-to-one
name="account"
class="com.simpy.model.Account"
/>

thus making the association bidirectional.

I also tried this, according to the hibernate documentation on one-to-one association
(hibernate-2.1/doc/reference/html_single/index.html#or-mapping-s1-9)

<property
name="accountId"
type="integer"
update="true"
insert="true"
column="account_id"
not-null="true"
unique="true"
/>

<many-to-one
name="accountId"
class="com.simpy.model.Account"
column="account_id"
unique="true"
update="false"
insert="false"
/>
but neither works

When saving Account object (object for account table) Hibernate
tries to insert a row into user_info without setting
user_info.account_id to point to just inserted account.
The account_id column of user_info table is left empy
----
Account acct = new Account(...);
UserInfo uinfo = new UserInfo(...);
uinfo.setAccount(acct);
acct.setUserInfo(uinfo);

ses.save(account);
-----

If I change UserInfo.hbm.xml, setting accountId property to be not null which is the right thing from the database standpoint
<property
name="accountId"
type="integer"
update="true"
insert="true"
column="account_id"
not-null="true"
unique="true"
/>
I get exception
not-null property references a null or transient value: net.sf.hibernate.persister.EntityPersister.accountId

How to resolve this and tell hibernate to populate FK of user_info table the appropriate way and not just leave it blank?

Thanks

In User:



in Account:



This is what is recommended in the manual.

I'm also having problems with one-to-one mappings. I've tried the one-to-one mapping that you suggested above. I'm getting the following error :

SEVERE: Error parsing XML: XML InputStream(36)
org.xml.sax.SAXParseException: Attribute "property-ref" must be declared for element type "one-to-one".

I will use a one-to-many mapping till I find a solution for this.

Regards,
Jairaj

use Hibernate 2.1

Thanks,
Jairaj