but I have to have a superior column as that will hold the id to the
'parent' user ...?
emmettwalsh 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-tp22688812s2369p22706901.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
