Re: Learning relationships - dazed and confused

[Craig L Russell]

Hi Randy,




Or both sides should be annotated @OneToOne.

Craig

On Nov 17, 2008, at 8:15 PM, [EMAIL PROTECTED] wrote:

Without looking into detail, the annotation on UserProperties.userId should be @ManyToOne, corresponding to the @OneToMany on the other side.

Hello all,



Here's my scenario:
I have two tables: UserInfo and UserProperties
Each UserInfo will have a collection of UserProperties

I'm trying to define UserInfo as:
@Entity
@Table(name="UserInfo")
public class UserInfo implements Serializable {
....
@Id
private Long id;

@OneToMany(fetch=FetchType.EAGER, cascade=CascadeType.ALL)
@JoinColumn(name="prop_id", referencedColumnName="userId")
private Collection<UserProperties> userProperties;

<etc>

And I have UserProperties defined like:
@Entity
@Table(name="userproperties")
public class UserProperties implements Serializable {

@Id
private Integer id;
        
@OneToOne(fetch=FetchType.LAZY)
@JoinColumn(name="user_id", referencedColumnName="id")
private Integer userId;

But I get errors while trying to deploy:






I'm basically lost at this point.

Thanks in advance!
Randy

I am trying to teach myself OpenJPA. I've done a bit of database relationships but I'm confused while trying to set up entity relationships for a particular situation. I'm hoping someone will be kind enough to point me in the right direction. <openjpa-1.0.2-r420667:627158 fatal user error> org.apache.openjpa.util.MetaDataException: The type of field "com.whitetail.sawhorse.data.UserProperties.userId" isn't supported by declared persistence strategy "OneToOne". Please choose a different strategy. I'm not sure how to set up the join type in UserProperties. Basically, I will have many UserInfo entities, each with a collection of UserProperties. The UserProperties will be joined to a single UserInfo; primarily because each UserInfo can have an arbitrary set of UserProperties. Is this possible? If so, can anyone offer any suggestions on how to set it up?

Craig L Russell
Architect, Sun Java Enterprise System http://db.apache.org/jdo
408 276-5638 mailto:[EMAIL PROTECTED]
P.S. A good JDO? O, Gasp!

smime.p7s
Description: S/MIME cryptographic signature