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