db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From T E Schmitz <mail...@numerixtechnology.de>
Subject Re: 1. onDelete 2. 1:n association
Date Fri, 30 Jul 2004 10:24:39 GMT
Hello Artur,

Artur Z wrote:
> I tried to use torque onDelete attribute on MSSQL but it did't wokred
> db was throwing an exception about constraint violation
> maybe I did something wrong

This sounds more like a problem with your schema.
What do you want to do onDelete? onDelete=none or onDelete=cascade?

You seem to be trying to delete DB records that have dependent records 
linking to them. If onDelete=none, then an attempt to delete this record 
will cause a constraint violation.

Look at Torque's debug output, take the SQL statement and execute it "by 
hand". You should also look at the SQL code that was produced from the 
schema and check whether that is what you wanted.



Tarlika Elisabeth Schmitz

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

View raw message