It’s the same…I had just renamed it to queueItems in the post to make it understand better but missed to replace in Collection.
Joshi, What is the relationship between LirChecks and QueueItems? Judes On Tue, Apr 14, 2009 at 2:49 PM, JoshiJPA <[email protected]>wrote: > > Hi, > I have a simple OneToMany relationship. > User --> Queue --> QueueItems > A user has a colletion of Queues and each Queue has a colletion of > QueueItems. > > Now, > - User and Queue are joined by a Join table (User_Queue table), but > - Queue and QueueItems are joined by foreign key queueId. Also 'queueId' > is not the primary key of QueueItems. > > So my object structure goes like this > ------------------------------------------------------ > @Entity > @Table(name = "User") > public class User implements Serializable { > . > . > . > @OneToMany(fetch=FetchType.EAGER) > @OrderBy("siteNumber,queueId ASC") > @JoinTable( > name="User_Queue ", > joinColumns= > @JoinColumn(name="USER_NAME", > referencedColumnName="USER_NAME"), > inverseJoinColumns= > @JoinColumn(name="QUEUE_ID", > referencedColumnName="QUEUE_ID") > ) > private Collection<Queue> queues; > > } > ---------------------------------------------------- > @Entity > @Table(name = "T_EVAL_QUEUES") > public class Queue implements Serializable { > . > . > . > @OneToMany(fetch=FetchType.EAGER) > @ElementJoinColumn(name="QUEUE_ID", referencedColumnName="QUEUE_ID") > private Collection<LirChecks> lirChecks; > > } > ------------------------------------------------------ > > @Entity > @Table(name = "Queue_Items") > public class QueueItems implements Serializable { > . > . > . > @Column (name = "QUEUE_ID") > private Integer queueId; > } > > > Now when I just try to fetch the queues of User then its working fine, but > when I try to fetch the queueItems then its giving me an exception. Below is > the exception trace. > > <openjpa-1.2.1-SNAPSHOT-r422266:686069 nonfatal general error> > org.apache.openjpa.persistence.PersistenceException: null > > > I have spent whole day yesterday on this to fix it but in vain. > Please advice. > > -- > View this message in context: > http://n2.nabble.com/OneToMany-PersistenceException-tp2634657p2634657.html > Sent from the OpenJPA Users mailing list archive at Nabble.com. > > -- View this message in context: http://n2.nabble.com/OneToMany-PersistenceException-tp2634657p2634823.html Sent from the OpenJPA Users mailing list archive at Nabble.com.
