db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thomas Fischer <fisc...@seitenbau.net>
Subject Re: Saving two related objects
Date Fri, 17 Feb 2006 15:11:01 GMT
I had just a 5 seconds glance on this, so maybe I'm completely wrong. Have
you tried  to set the attribute javaType="object" in the foreign key's
column definition in the schema.xml ?

   Thomas

Matteo Barbieri <m.barbieri@ste-energy.com> schrieb am 17.02.2006 15:29:22:

> 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
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message