3:37 p.m.
Hi,
I'm trying to create a one to many bidirectional relationship but am having some
problems. Whenever I deploy the application in JBoss I get an error. I've searched
online, and in an EJB 3.0 book and as far as I know I am doing things correctly. Below
are my 2 classes, the tables and the error from JBoss. If anyone can point me in the
right direction it would be helpful. I am using JBoss version 4.0.4.GA. This is my first
EJB application, so I appoligize if this is a simple error. Thanks!
User.java
| package com.rim.pushMagic.entity;
|
| //The Users entity bean
|
| import javax.persistence.*;
|
| @Entity
| @Table(name="USERS")
| @SequenceGenerator(name="USERID_SEQUENCE_GEN",
sequenceName="USERID_SEQUENCE",
| initialValue=2, allocationSize=1)
| public class User implements java.io.Serializable
| {
|
| //Variables for the table columns.
| private int _userID;
| private UserRole userRole;
| private int _groupID;
| private String _name;
| private String _email;
| private String _password;
| private int _active;
|
| @Id
| @GeneratedValue(strategy=GenerationType.SEQUENCE,
generator="USERID_SEQUENCE_GEN")
| @Column(name="USERID")
| public int getUserID() { return _userID; }
| public void setUserID(int userID) { _userID = userID; }
|
| @ManyToOne
| @JoinColumn(name="ROLEID")
| public UserRole getUserRole() { return _serRole; }
| public void setUserRole(UserRole userRole) { this.userRole = userRole; }
|
| @Column(name="GROUPID")
| public int getGroupID() { return _groupID; }
| public void setGroupID(int groupID) { _groupID = groupID; }
|
| @Column(name="NAME")
| public String getName() { return _name; }
| public void setName(String name) { _name = name; }
|
| @Column(name="EMAIL")
| public String getEmail() { return _email; }
| public void setEmail(String email) { _email = email; }
|
| @Column(name="PASSWORD")
| public String getPassword() { return _password; }
| public void setPassword(String password) { _password = password; }
|
| @Column(name="ACTIVE")
| public int getActive() { return _active; }
| public void setActive(int active) { _active = active; }
| }
|
UserRole.java
| package com.rim.pushMagic.entity;
|
| //The UserRoles entity bean
|
| import javax.persistence.*;
| import java.util.ArrayList;
| import java.util.Collection;
|
|
| @Entity
| @Table(name="USERROLES")
|
| public class UserRole implements java.io.Serializable
| {
| private int _roleID;
| private String _roleName;
| private int _active;
| private Collection<User> _users = new ArrayList<User>();
|
|
| @Id
| @Column(name="ROLEID")
| public int getRoleID() { return _roleID; }
| public void setRoleID(int roleID) { _roleID = roleID; }
|
| @Column(name="ROLENAME")
| public String getRoleName() { return _roleName; }
| public void setRoleName(String roleName) { _roleName = roleName; }
|
| @Column(name="ACTIVE")
| public int getActive() { return _active; }
| public void setActive(int active) { _active = active; }
|
| @OneToMany(mappedBy="userRole")
| public Collection<User> getUsers() { return _users; }
| public void setUsers(Collection<User> users) { _users = users; }
| }
|
UserRoles.sql
| CREATE TABLE "USERROLES"
| ( "ROLEID" NUMBER(*,0) NOT NULL ENABLE,
| "ROLENAME" VARCHAR2(50 BYTE) NOT NULL ENABLE,
| "ACTIVE" NUMBER(*,0),
| CONSTRAINT "USERROLES_PK" PRIMARY KEY ("ROLEID") ENABLE
| ) ;
|
Users.sql
| CREATE TABLE "PUSHMAGIC"."USERS"
| ( "USERID" NUMBER(*,0) NOT NULL ENABLE,
| "ROLEID" NUMBER(*,0) NOT NULL ENABLE,
| "GROUPID" NUMBER(*,0) NOT NULL ENABLE,
| "NAME" VARCHAR2(100 BYTE),
| "EMAIL" VARCHAR2(100 BYTE),
| "ACTIVE" NUMBER(*,0) DEFAULT 1 NOT NULL ENABLE,
| "PASSWORD" VARCHAR2(100 BYTE) NOT NULL ENABLE,
| CONSTRAINT "USERS_PK" PRIMARY KEY ("USERID") ENABLE,
| CONSTRAINT "USERS_GROUPID_FK" FOREIGN KEY ("GROUPID")
| REFERENCES "PUSHMAGIC"."USERGROUPS" ("GROUPID")
ENABLE,
| CONSTRAINT "USERS_ROLEID_FK" FOREIGN KEY ("ROLEID")
| REFERENCES "PUSHMAGIC"."USERROLES" ("ROLEID") ENABLE
| ) ;
|
Here is the error from JBoss:
| ObjectName: persistence.units:jar=pushMagic.jar,unitName=pushMagic
| State: FAILED
| Reason: org.hibernate.AnnotationException: mappedBy reference an unknown prope
| rty: com.rim.pushMagic.entity.User.USERROLE in com.rim.pushMagic.entity.UserRole
| .USERROLE
| I Depend On:
| jboss.jca:service=ManagedConnectionFactory,name=PushMagicDS
| Depends On Me:
| jboss.j2ee:jar=pushMagic.jar,name=UserManagerBean,service=EJB3
|
| ObjectName: jboss.j2ee:jar=pushMagic.jar,name=UserManagerBean,service=EJB3
| State: NOTYETINSTALLED
| I Depend On:
| persistence.units:jar=pushMagic.jar,unitName=pushMagic
|
| --- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
| ObjectName: persistence.units:jar=pushMagic.jar,unitName=pushMagic
| State: FAILED
| Reason: org.hibernate.AnnotationException: mappedBy reference an unknown prope
| rty: com.rim.pushMagic.entity.User.USERROLE in com.rim.pushMagic.entity.UserRole
| .USERROLE
| I Depend On:
| jboss.jca:service=ManagedConnectionFactory,name=PushMagicDS
| Depends On Me:
| jboss.j2ee:jar=pushMagic.jar,name=UserManagerBean,service=EJB3
|
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3971118#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...