Return-Path: 
 <torque-user-return-5322-apmail-db-torque-user-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-torque-user-archive@www.apache.org
Received: (qmail 98975 invoked from network); 20 Sep 2004 08:37:43 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur-2.apache.org with SMTP; 20 Sep 2004 08:37:43 -0000
Received: (qmail 29741 invoked by uid 500); 20 Sep 2004 08:37:33 -0000
Delivered-To: apmail-db-torque-user-archive@db.apache.org
Received: (qmail 29715 invoked by uid 500); 20 Sep 2004 08:37:32 -0000
Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:torque-user-unsubscribe@db.apache.org>
List-Subscribe: <mailto:torque-user-subscribe@db.apache.org>
List-Help: <mailto:torque-user-help@db.apache.org>
List-Post: <mailto:torque-user@db.apache.org>
List-Id: "Apache Torque Users List" <torque-user.db.apache.org>
Reply-To: "Apache Torque Users List" <torque-user@db.apache.org>
Delivered-To: mailing list torque-user@db.apache.org
Received: (qmail 29702 invoked by uid 99); 20 Sep 2004 08:37:32 -0000
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=
X-Spam-Check-By: apache.org
Received-SPF: pass (hermes.apache.org: local policy)
Received: from [194.77.152.181] (HELO mail.hometree.net) (194.77.152.181)
  by apache.org (qpsmtpd/0.28) with ESMTP; Mon, 20 Sep 2004 01:37:31 -0700
Received: from tangens.hometree.net (IDENT:news@mail.hometree.net
 [194.77.152.181])
	by mail.hometree.net (8.12.10/8.12.10) with ESMTP id i8K8bSNx024336
	for <torque-user@db.apache.org>; Mon, 20 Sep 2004 10:37:28 +0200
Received: (from news@localhost)
	by tangens.hometree.net (8.12.10/8.12.8/Submit) id i8K8bRs2024335
	for torque-user@db.apache.org; Mon, 20 Sep 2004 10:37:27 +0200
To: torque-user@db.apache.org
Path: not-for-mail
From: "Henning P. Schmiedehausen" <hps@intermeta.de>
Newsgroups: hometree.jakarta.torque.user
Subject: Re: mySQL --> CASCADE DELETE
Date: Mon, 20 Sep 2004 08:37:27 +0000 (UTC)
Organization: INTERMETA - Gesellschaft fuer Mehrwertdienste mbH
Lines: 67
Message-ID: <cim4s7$neg$1@tangens.hometree.net>
References: <GCECKLAPFFOLOJGOMAHDKEKNGAAA.ben.bookey@gistec-online.de>
Reply-To: hps@intermeta.de
NNTP-Posting-Host: forge.intermeta.de
X-Trace: tangens.hometree.net 1095669447 24016 194.77.152.164 (20 Sep 2004
 08:37:27 GMT)
X-Complaints-To: news@intermeta.de
NNTP-Posting-Date: Mon, 20 Sep 2004 08:37:27 +0000 (UTC)
X-Copyright: (C) 1996-2003 Henning Schmiedehausen
User-Agent: nn/6.6.5
X-Virus-Checked: Checked
X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N

"Ben Bookey" <ben.bookey@gistec-online.de> writes:

Hi,

well, it won't make you happy, but that is how it works on
e.g. PostgreSQL.

Torque uses the onDelete="cascade" attribute only for the SQL
generation and relies on the database to do the actual cascade.

>Dear List,

>I am trying to create a cascade delete foreign key reference for mySQL
>database sql script, using Torque 3.0.2, but it doesnt generate the correct
>sql.

>I have taken a look at the mySQL template vm velocity files, but can not
>find any mention of "cascade delete".

I looked at the Torque 3.1 tree and cascades are only supported for
oracle, postgresql and sapdb (as far as I can see).

The MySQL support is pretty much on the 3.23 level when the database
engine had no cascading delete support. The problem with MySQL is,
that the supported language has been greatly extended in 4.x.

So yes. I think you're out of luck for MySQL > 3.23 ATM. Sorry. 

Patches welcome (but they must keep backwards compatiblity; so you
probably would need to introduce a new database type, e.g. mysql4,
based on mysql.

	Regards
		Henning

><foreign-key foreignTable="main" onDelete="cascade">
>  <reference
>		local="ID_main"
>		foreign="ID_main"/>
></foreign-key>


>Could anyone tell me if this is supported by Torque and the mysql db driver.

>regards

>Ben Bookey


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

-- 
Dipl.-Inf. (Univ.) Henning P. Schmiedehausen          INTERMETA GmbH
hps@intermeta.de        +49 9131 50 654 0   http://www.intermeta.de/

RedHat Certified Engineer -- Jakarta Turbine Development  -- hero for hire
   Linux, Java, perl, Solaris -- Consulting, Training, Development

"Fighting for one's political stand is an honorable action, but re-
 fusing to acknowledge that there might be weaknesses in one's
 position - in order to identify them so that they can be remedied -
 is a large enough problem with the Open Source movement that it
 deserves to be on this list of the top five problems."
                       -- Michelle Levesque, "Fundamental Issues with
                                    Open Source Software Development"

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