Call Stored Procedures hibernate annotations

2008-11-28 Thread piltrafeta
I'm using hibernate annotations and i'd like to use a stored procedure which returns a resultset. I kow to do it whit hbm files but i'd like directly by createSQLQuery. Maybe something like this is possible: List list = session.createSQLQuery("call PK_TRUCK_APPOINT_ORDER.FN_TRABA_CHKCTR_resulset(

Re: @OneToMany/@ManyToOne, Bidirectional, Composite Key

2008-11-24 Thread piltrafeta
Hi Fay! I'm still blocked.. do you have any idea? Thanks! On Thu, Nov 20, 2008 at 6:24 PM, piltrafeta <[EMAIL PROTECTED]> wrote: > Hi Fay! > > Thank you for your explanation, it's exactly what i want to do. But i don't > know exactly how to set pactId as F

Re: @OneToMany/@ManyToOne, Bidirectional, Composite Key

2008-11-20 Thread piltrafeta
; > > The workaround is not to use IdClass. Instead, to have consId alone as the > primary key in the child table and pactId as the join column (foreign key > column) in the child table. Hope this is helpful. > > Fay > > > --- On Wed, 11/19/08, piltrafeta <[EMAIL >

Re: @OneToMany/@ManyToOne, Bidirectional, Composite Key

2008-11-19 Thread piltrafeta
he related entity that maps this > bidirectional relation. Could you change mappedBy to "activity" and try > again? > > Regards, > Fay > > > > > > --- On Tue, 11/18/08, piltrafeta <[EMAIL PROTECTED]> wrote: > >> From: piltrafeta <[EMAIL

Re: @OneToMany/@ManyToOne, Bidirectional, Composite Key

2008-11-18 Thread piltrafeta
Hi! I'm having a similar problem for a while, maybe you can help me... My classes are like this : @Entity @Table(name = "ASSIGNED_ACTIVITIES") @IdClass(AssignedActivityPk.class) public class AssignedActivity implements IsSerializable { @Id @Column (name = "CONS_ID", nullable=fals