Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Apache Torque Users List" <torque-user@db.apache.org>
Received-SPF: neutral (asf.osuosl.org: local policy)
Message-ID: <43F59FDC.2050407@ste-energy.com>
Date: Fri, 17 Feb 2006 11:05:16 +0100
From: Matteo Barbieri <m.barbieri@ste-energy.com>
Organization: S.T.E. s.r.l.
User-Agent: Mozilla Thunderbird 1.0.7 (X11/20051013)
MIME-Version: 1.0
To: Apache Torque Users List <torque-user@db.apache.org>
Subject: Saving two related objects
OpenPGP: id=3890B783
Content-Type: text/plain; charset=ISO-8859-15
Content-Transfer-Encoding: 7bit

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
S.T.E. s.r.l.
m.barbieri@ste-energy.com


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