Return-Path: 
 <torque-dev-return-5823-apmail-db-torque-dev-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-torque-dev-archive@www.apache.org
Received: (qmail 83447 invoked from network); 30 Aug 2005 22:07:57 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 30 Aug 2005 22:07:57 -0000
Received: (qmail 52362 invoked by uid 500); 30 Aug 2005 22:07:56 -0000
Delivered-To: apmail-db-torque-dev-archive@db.apache.org
Received: (qmail 52342 invoked by uid 500); 30 Aug 2005 22:07:56 -0000
Mailing-List: contact torque-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:torque-dev-unsubscribe@db.apache.org>
List-Help: <mailto:torque-dev-help@db.apache.org>
List-Post: <mailto:torque-dev@db.apache.org>
List-Id: "Apache Torque Developers List" <torque-dev.db.apache.org>
Reply-To: "Apache Torque Developers List" <torque-dev@db.apache.org>
Delivered-To: mailing list torque-dev@db.apache.org
Received: (qmail 52319 invoked by uid 99); 30 Aug 2005 22:07:56 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 30 Aug 2005 15:07:56 -0700
X-ASF-Spam-Status: No, hits=0.9 required=10.0
	tests=DNS_FROM_RFC_ABUSE,INFO_TLD
X-Spam-Check-By: apache.org
Received-SPF: pass (asf.osuosl.org: local policy)
Received: from [65.112.55.73] (HELO mail.dukece.com) (65.112.55.73)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 30 Aug 2005 15:08:10 -0700
Received: from dukece-mail2.dukece.com ([192.168.1.220]) by mail.dukece.com
 with Microsoft SMTPSVC(5.0.2195.6713); Tue, 30 Aug 2005 18:07:59 -0400
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506
Content-Class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable
Subject: RE: <foreign-key> to another db
Date: Tue, 30 Aug 2005 18:07:51 -0400
Message-ID: <0EBA2D5D58A98C4AAFBF2ACB6E625A260C18E6@dukece-mail2.dukece.com>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: <foreign-key> to another db
Thread-Index: AcWtn3ruQO1lzoWaSV2nMLSMsHH+xQADgvPA
From: "Greg Monroe" <Greg.Monroe@DukeCE.com>
To: "Apache Torque Developers List" <torque-dev@db.apache.org>
X-OriginalArrivalTime: 30 Aug 2005 22:07:59.0687 (UTC)
 FILETIME=[487B9D70:01C5ADAF]
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

I wonder if this is too SQL implimentation specific?  I know that MS SQL
doesn't support it and I'm pretty sure that My SQL doesn't either.  How
would you handle writing the table creation SQL scripts from the XML in
these cases if the input XML specifies foreign DB keys?=20

But then I'm looking at it from the point of needing cross-DB type code.
If it can support both cases in some way, great.

> -----Original Message-----
> From: Thomas Fischer [mailto:tfischer@apache.org]=20
> Sent: Tuesday, August 30, 2005 4:15 PM
> To: Apache Torque Developers List
> Subject: Re: <foreign-key> to another db
>=20
>=20
> Hi,
>=20
> I'm not totally sure, but I would guess this does not work.=20
> However, with=20
> 3.2-RC1, there is the possibility to include one schema into=20
> another. I=20
> have never used it, but it might work then (I would try it=20
> without using=20
> the db2 prefix)
>=20
>     Thomas
>=20
> On Sun, 28 Aug 2005, Mickey Mokotov wrote:
>=20
> > Hi All,
> >
> > Can in any way we support the <foreign-key> tag to=20
> reference another=20
> > db? for example:
> >
> > <database name=3D"db1">
> >
> >  <table name=3D"t1">
> >    <column name=3D"userId" type=3D"INTEGER" primaryKey=3D"true"=20
> > autoIncrement=3D"true"/>
> >    <column name=3D"countryId" type=3D"INTEGER"/>
> >    <foreign-key foreignTable=3D"db2.Country">
> >      <reference local=3D"countryKey" foreign=3D"symbol"/>
> >    </foreign-key>
> >  </table>
> >
> > </database>
> >
> >
> > --
> > <http://www.fetchbook.info/> www.FetchBook.Info
> > Find the lowest price - Compare more then a hundred book=20
> stores in a click.
> >
> >
>=20
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-dev-help@db.apache.org
>=20
>=20

Duke CE Privacy Statement
Please be advised that this e-mail and any files transmitted with it are =
confidential communication or may otherwise be privileged or =
confidential and are intended solely for the individual or entity to =
whom they are addressed.  If you are not the intended recipient you may =
not rely on the contents of this email or any attachments, and we ask =
that you  please not read, copy or retransmit this communication, but =
reply to the sender and destroy the email, its contents, and all copies =
thereof immediately.  Any unauthorized dissemination, distribution or =
copying of this communication is strictly prohibited.



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