Greg Monroe ha scritto:
>If you have a forgeign key field, there should be a method >like setTable2Key(ObjectKey) in it. You should use this to >set the relationship. E.g.: > >second.setFirstKey( first.getPrimaryKey() ) > > > Doesn't work, same error org.apache.torque.TorqueException: java.sql.SQLException: Cannot add or update a child row: a foreign key constraint fails >I'm not sure where you're finding a Torque method with >the signature setFirstClass( First value )? > > > If First is the name of a class an Second the name of another class with a foreign key to First, I have the method setFirst(First value) in the Second class. > > >>-----Original Message----- >>From: Matteo Barbieri [mailto:[EMAIL PROTECTED] >>Sent: Friday, February 17, 2006 9:29 AM >>To: Apache Torque Users List >>Subject: Re: Saving two related objects >> >> >>After some more tests I found that when I save the second >>object, Torque tries to save it with 0 as foreign key, even >>if second.FkFirstClass() gives me the correct id of first. >> >>So what do I do? >> >>Bye >> >>Matteo Barbieri ha scritto: >> >> >> >>>Hi, >>>maybe it's a stupid question, but I got an error that I >>> >>> >>don't know why >> >> >>>it happens. >>> >>>I have two tables that are related by foreign key. >>> >>>I have to create one istance of both objects and to save them. >>> >>>I do something like this: >>> >>>FirstClass first = new FirstClass(); >>>SecondClass second = new SecondClass(); >>> >>>first.save(); >>> >>>second.setFirstClass(first); >>>second.save(); >>> >>>the first object is saved correctly, but then I got an SQLException: >>> >>>java.sql.SQLException: Cannot add or update a child row: a >>> >>> >>foreign key >> >> >>>constraint fails >>> >>>I've tried to print both objects before every saving and the second >>>object has the correct foreign key. >>> >>>Any idea? >>> >>>Thanks >>> >>> >>> >>> >>> >>-- >>Matteo Barbieri >> >> >> -- Matteo Barbieri --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
