Sorry I think looking at your code deeply it must be a @ManyToOne :)
On Wed, Mar 25, 2009 at 4:45 PM, Kannan Ekanath <kannan.ekan...@gmail.com>wrote:
> That is because you are tagging getSuperior with a @Column. That is wrong.
> you must say whether it is OneToOne or OneToMany :) Even if it is a relation
> with itself
>
>
> On Tue, Mar 24, 2009 at 8:16 PM, emmettwalsh <emmettwa...@gmail.com>wrote:
>
>>
>> Hi, can anyone help me with this seemingly simple relationship Im trying
>> to
>> model
>>
>> Basically I have a User class/object - which maps to a User table. I want
>> each user to contain a reference to a superior User and also a reference
>> to
>> a List of subordinate users.
>>
>> When I load a user from the database I want all this information contained
>> in the User object without having to do any extra queries, but unsure if
>> its
>> possible, here is what I have so far. Can anyone tell me if I am on thr
>> right track ...
>>
>>
>> @Entity
>> @Table(name = "user")
>> public class User implements Serializable {
>>
>> private Long id;
>> private String username;
>>
>> private User superior;
>> private Set<User> subordinates = new HashSet<User>();
>>
>> @OneToMany(mappedBy="user",cascade=CascadeType.ALL)
>> public Set<User> getSubordinates() {
>> return subordinates;
>> }
>>
>>
>> @Column(nullable=true)
>> public User getSuperior() {
>> return superior;
>> }
>>
>>
>> the annotations created a tinyblob for some reason for the superior field
>>
>> mysql> desc user;
>> +----------+-------------+------+-----+---------+----------------+
>> | Field | Type | Null | Key | Default | Extra
>> |
>> +----------+-------------+------+-----+---------+----------------+
>> | id | bigint(20) | NO | PRI | NULL | auto_increment
>> |
>> | superior | tinyblob | YES | | NULL |
>> |
>> | username | varchar(50) | NO | UNI | NULL | |
>> +----------+-------------+------+-----+---------+----------------+
>> 3 rows in set (0.00 sec)
>>
>>
>> --
>> View this message in context:
>> http://www.nabble.com/Hibernate-help-tp22688812s2369p22688812.html
>> Sent from the AppFuse - User mailing list archive at Nabble.com.
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: users-unsubscr...@appfuse.dev.java.net
>> For additional commands, e-mail: users-h...@appfuse.dev.java.net
>>
>>
>
>
> --
> Regards,
> Kannan Ekanath
>
--
Regards,
Kannan Ekanath
