Hibernate Community • View topic - How to setup simple one-to-one primary key relationship

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

How to setup simple one-to-one primary key relationship

Page 1 of 1

[ 4 posts ]

Previous topic | Next topic

Author

Message

weazelb0y

Post subject: How to setup simple one-to-one primary key relationship

Posted: Mon Feb 02, 2004 3:33 pm

Beginner

Joined: Thu Nov 20, 2003 1:30 pm
Posts: 27

Currently, I do not have a relationship setup. I just use a Long, but I want to change it to use a relationship. The documentation is a little foggy as to what is needed and where it goes when a one-to-one relationship is the primary key.

Here is what I currently have, the commented part is what I've been trying to get the relationship working. I get the error 'param named "property" is required for foreign id generation strategy' though. Any help is appreciated, thanks.

Code:

<class name="com.lsr.eclipse.framework.core.model.PanelRedeemAddress" table="panel_redeem_address">
<id column="panel_id" name="id" type="java.lang.Long">
<generator class="assigned"/>
</id>

<!--
<id column="panel_id" name="panel" type="com.lsr.eclipse.framework.core.model.Panel">
<generator class="foreign"/>
</id>
<one-to-one name="panel" class="com.lsr.eclipse.framework.core.model.Panel" constrained="true"/>
-->

<property column="street1" length="50" name="street1" not-null="true" type="java.lang.String"/>
<property column="street2" length="50" name="street2" type="java.lang.String"/>
<property column="city" length="25" name="city" not-null="true" type="java.lang.String"/>
<property column="state" length="4" name="state" not-null="true" type="java.lang.String"/>
<property column="zipcode" length="15" name="zipcode" not-null="true" type="java.lang.String"/>
<property column="phone" length="25" name="phone" type="java.lang.String"/>
</class>

Top

michael

Post subject:

Posted: Mon Feb 02, 2004 3:37 pm

Hibernate Team

Joined: Tue Sep 09, 2003 2:10 pm
Posts: 3246
Location: Passau, Germany

type="com.lsr.eclipse.framework.core.model.Panel" in the id property is crap, stick to long here.

Use Foreign id generation, and name the id property of your referenced class in the generator tag.

Top

weazelb0y

Post subject:

Posted: Mon Feb 02, 2004 4:04 pm

Beginner

Joined: Thu Nov 20, 2003 1:30 pm
Posts: 27

Great, thanks for the quick reply! I have it working, one more question (I'm getting greedy and curious) Is it possible to use the reference to load the object, instead of the Long?

Code:

// Load PanelRedeemAddress
PanelRedeemAddress panelRedeemAddress = (PanelRedeemAddress) session.load(PanelRedeemAddress.class, panel.getId());

just use panel, instead of panel.getId()

Code:

<class name="com.lsr.eclipse.framework.core.model.PanelRedeemAddress" table="panel_redeem_address">
<id column="panel_id" name="id" type="java.lang.Long"> 
<generator class="foreign">
<param name="property">panel</param>
</generator>
</id> 
<one-to-one name="panel" class="com.lsr.eclipse.framework.core.model.Panel" constrained="true"/> 
<property column="street1" length="50" name="street1" not-null="true" type="java.lang.String"/>
<property column="street2" length="50" name="street2" type="java.lang.String"/>
<property column="city" length="25" name="city" not-null="true" type="java.lang.String"/>
<property column="state" length="4" name="state" not-null="true" type="java.lang.String"/>
<property column="zipcode" length="15" name="zipcode" not-null="true" type="java.lang.String"/>
<property column="phone" length="25" name="phone" type="java.lang.String"/>
</class>

Top

michael

Post subject:

Posted: Mon Feb 02, 2004 4:11 pm

Hibernate Team

Joined: Tue Sep 09, 2003 2:10 pm
Posts: 3246
Location: Passau, Germany

If you have a Panel, you should have an association to PanelRedeemAddress I suppose. Then you can just to panel.getRedeemAddress() to get the adress.

If you dont map it, you can still do a query like:

Code:

session.createQuery("from PanelRedeemAddress p where p.panel = :panel").setParameter("panel", panel).uniqueResult()

Top

Page 1 of 1

[ 4 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum