No problem. I'm happy to hear that you are up and running. -Jeremy
On Wed, Mar 2, 2011 at 11:26 PM, Phill <ph...@bicispace.com> wrote: > Many thanks Jeremy, to my embarrassment I've discovered that lead wasn't > getting set properly on the other end of the association. I jumped to the > wrong conclusion about the id generation not working... sorry for taking up > your time with this. > > On 02/mar/2011, at 21.42, Jeremy Bauer wrote: > > > Hi Phill, > > > > I tried a similar configuration, but was unable to reproduce the failure. > > Since cascade is defined on the Lead-side of the relationship, I'm > assuming > > that you are persisting the Lead entity, right? I'm also assuming that > > you've set all bi-directional references in your code. ie > > answer.setLead(lead), lead.setAnswers(answers). If both of those > > assumptions are correct, the next step would be to provide an OpenJPA > trace > > using: > > > > <property name="openjpa.Log" value="DefaultLevel=TRACE"/> > > > > please enable parameter value trace as well using: > > > > <property name="openjpa.ConnectionFactoryProperties" > > value="PrintParameters=true"/> > > > > That may help us spot the problem. Or, if possible, please provide a > simple > > test that can be used to reproduce the problem. > > > > -Jeremy > > > > On Wed, Mar 2, 2011 at 11:08 AM, Phill <ph...@bicispace.com> wrote: > > > >> Yes it also uses a sequence generator. > >> > >> SurveyAnswer.java > >> > >> @SequenceGenerator(name = "Survey_Result_Id_Gen", sequenceName = > >> "survey_result_seq", allocationSize = 10) > >> > >> @Id > >> @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = > >> "Survey_Result_Id_Gen") > >> @Column(name = "result_id") > >> protected long id; > >> > >> > >> On 02/mar/2011, at 17.24, Jeremy Bauer wrote: > >> > >>> Thanks, Phill. Sorry, I forgot to ask - does SurveyAnswer also use the > >> same > >>> id generation strategy as Lead? In the meantime, I'll begin trying to > >>> reproduce the failure you are seeing. > >>> > >>> -Jeremy > >>> > >>> On Wed, Mar 2, 2011 at 9:26 AM, Phill <ph...@bicispace.com> wrote: > >>> > >>>> OpenJPA 2.1.0 and PostgreSQL 9 > >>>> I have separate DDL. > >>>> Phill > >>>> > >>>> > >>>> On 02/mar/2011, at 16.22, Jeremy Bauer wrote: > >>>> > >>>>> Hi Phill, > >>>>> > >>>>> What database and version of OpenJPA are you using? Also, does > OpenJPA > >>>>> generate the tables or do you have separate DDL? > >>>>> > >>>>> -Jeremy > >> > >