Return-Path: 
 <torque-user-return-4467-apmail-db-torque-user-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-torque-user-archive@www.apache.org
Received: (qmail 59040 invoked from network); 19 Mar 2004 08:51:14 -0000
Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12)
  by minotaur-2.apache.org with SMTP; 19 Mar 2004 08:51:14 -0000
Received: (qmail 26034 invoked by uid 500); 19 Mar 2004 08:50:42 -0000
Delivered-To: apmail-db-torque-user-archive@db.apache.org
Received: (qmail 25950 invoked by uid 500); 19 Mar 2004 08:50:41 -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 25801 invoked from network); 19 Mar 2004 08:50:39 -0000
Received: from unknown (HELO mail.globaltech-bg.com) (195.24.36.102)
  by daedalus.apache.org with SMTP; 19 Mar 2004 08:50:39 -0000
Received: from localhost (localhost [127.0.0.1])
	by mail.globaltech-bg.com (Postfix) with ESMTP id 2392613B82
	for <torque-user@db.apache.org>; Fri, 19 Mar 2004 06:51:53 -0200 (GMT+2)
Received: from mail.globaltech-bg.com ([127.0.0.1])
 by localhost (ns.globaltech-bg.com [127.0.0.1]) (amavisd-new, port 10024)
 with ESMTP id 00938-02 for <torque-user@db.apache.org>;
 Fri, 19 Mar 2004 10:51:52 +0200 (EET)
Received: from bogdan (unknown [192.168.11.105])
	by mail.globaltech-bg.com (Postfix) with SMTP id 9D27813B7E
	for <torque-user@db.apache.org>; Fri, 19 Mar 2004 06:51:52 -0200 (GMT+2)
Message-ID: <000a01c40d90$6499f6c0$690ba8c0@int.globaltechbg.com>
From: "Bogdan Vatkov" <bvatkov@globaltech-bg.com>
To: "Apache Torque Users List" <torque-user@db.apache.org>
References: <004201c40d0f$e7a24b20$690ba8c0@int.globaltechbg.com>
 <Pine.LNX.4.50.0403181032330.3107-100000@corfu.local.net>
Subject: Re: torque-gen multiple db ?
Date: Fri, 19 Mar 2004 10:58:48 +0200
Organization: Global Communications Technologies
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2720.3000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2727.1300
X-Virus-Scanned: by F-Prot Antivirus at mail.globaltech-bg.com
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N
X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N

What I need is to have different schemas of one database. and maybe i was
wrong
to talk about multiple databases ..actually i need 1 database and multiple
schemas
in postgresql the schema is something like namespace (i do not mean xml
schema or conceptual db schema)

So the method of accomplishing the multiple schema i think was to somehow
use multiple database definition method

I think your way is not suitable for me as long as i need to have relations
between some tables located in
different schemas.

for the moment i have all the tables from all the schemas in one XML
definition file.

examle:
<database id="globalservices" name="globalservices" defaultidMethod="native"
defaultJavaType="object"basePeer="org.apache.torque.util.BasePeer"
defaultJavaNamingMethod="javaname" heavyIndexing="false">

    <table name="sys.account"  idMethod="native" skipSql="false"
abstract="false" basePeer="org.apache.torque.util.BasePeer"
heavyIndexing="false" description="" x="4774" y="2482" width="106"
height="142">
....
....
6 more tables with names "sys.tablename"

    <table name="cs.ani_conditions"  idMethod="native" skipSql="false"
abstract="false" basePeer="org.apache.torque.util.BasePeer"
heavyIndexing="false" description="" x="5125" y="2807" width="100"
height="90">
........
........
5 more tables with names "cs.tablename"

and 4-5 more namespaces with 5-9 tables in each

the code here contains some extra attributes and it is because i have used
devaki to visualize my XML db schema.

Of course i have made some corrections in the torque runtime &
torque-generator to successfully support the . (dot)
inside tables names. but now i want to separate the definition of each
schema and place it in a separate file (xml file)

any other suggestions will be appreciated

regards,
bogdan
----- Original Message -----
From: "Gary Shea" <shea@gtsdesign.com>
To: "Apache Torque Users List" <torque-user@db.apache.org>
Sent: Thursday, March 18, 2004 7:36 PM
Subject: Re: torque-gen multiple db ?


> I'm currently using multiple databases.  I build the schema and java
> code separately for each database.  In the schema document, make sure
> you set a unique name in the <database> element for each of your
> databases.
>
> Does that answer your question?
>
>         Gary
>
> On Thu, 18 Mar 2004, at 19:39 [+0200], Bogdan Vatkov
(bvatkov@globaltech-bg...:
>
> > Hey guys ..any clues about multiple databases definition in the
torque-generator phase ?
> >
> > regards,
> > bogdan
> >
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>


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