Return-Path: <rs@reazon.com>
Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm
Delivered-To: mailing list torque-user@db.apache.org
Received: (qmail 26547 invoked from network); 17 Jun 2003 16:16:37 -0000
Received: from unknown (HELO postoffice.sitehosting.net) (216.87.160.23)
  by daedalus.apache.org with SMTP; 17 Jun 2003 16:16:37 -0000
Received: from RSC640 ([67.112.246.202]) by postoffice.sitehosting.net
          (Post.Office MTA v3.5.3 release 223 ID# 0-0U10L2S100V35)
          with ESMTP id net for <torque-user@db.apache.org>;
          Tue, 17 Jun 2003 08:57:07 -0700
From: "Ramesh Sabeti" <rs@reazon.com>
To: "'Turbine Torque Users List'" <torque-user@db.apache.org>
Subject: RE: Schema qualifier for table names
Date: Tue, 17 Jun 2003 09:16:33 -0700
Message-ID: <000f01c334eb$d1d9d9e0$50e5fea9@RSC640>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="US-ASCII"
Content-Transfer-Encoding: 7bit
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook, Build 10.0.2627
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
In-Reply-To: <1CB0CA7C1D7FD711ABA900010285328A4EA574@mcdc-atl-50.cdc.gov>
Importance: Normal
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N

My database contains multiple schemas.  In torque.properties I set the
values according to the schema in question.  I'm testing accessing
multiple schemas in a single application now.

> -----Original Message-----
> From: Duddikunta, Padmanabha [mailto:Pkd2@cdc.gov]
> Sent: Monday, June 16, 2003 2:33 PM
> To: 'Turbine Torque Users List'
> Subject: RE: Schema qualifier for table names
> 
> What do you when there are more than one schema in the database.
> 
> 
> -----Original Message-----
> From: Ramesh Sabeti [mailto:rs@reazon.com]
> Sent: Monday, June 16, 2003 5:03 PM
> To: 'Turbine Torque Users List'
> Subject: RE: Schema qualifier for table names
> 
> I don't know how it works in your app.  I use torque.properties in my
> app which includes that info.
> 
> > -----Original Message-----
> > From: Duddikunta, Padmanabha [mailto:Pkd2@cdc.gov]
> > Sent: Monday, June 16, 2003 10:28 AM
> > To: 'Turbine Torque Users List'
> > Subject: RE: Schema qualifier for table names
> >
> > See that is the problem.  Then how would it able to generate sql
with
> > schema
> > name qualifier.
> >
> > Ex:  SELECT COL1, COL2, COL3 FROM SCHEMA_NAME.TABLE
> >
> > Thanks
> > Paddy
> >
> >
> > -----Original Message-----
> > From: Ramesh Sabeti [mailto:rs@reazon.com]
> > Sent: Monday, June 16, 2003 1:13 PM
> > To: 'Turbine Torque Users List'
> > Subject: RE: Schema qualifier for table names
> >
> > Here it is.  There's no mention of the schema name in my schema.xml
by
> > the way.
> >
> >   <?xml version="1.0" ?>
> >   <!DOCTYPE database (View Source for full doctype...)>
> >  <!--  Autogenerated by JDBCToXMLSchema!
> >   -->
> >  <database defaultIdMethod="none" defaultJavaType="primitive"
> > defaultJavaNamingMethod="underscore" heavyIndexing="false">
> >  <table name="ACCESSREQUEST" idMethod="null" skipSql="false"
> > abstract="false">
> >   <column name="ARQ_ID" primaryKey="true" required="true" size="22"
> > type="DECIMAL" autoIncrement="false" inheritance="false" />
> >   <column name="MBR_ID" size="22" type="DECIMAL" primaryKey="false"
> > required="false" autoIncrement="false" inheritance="false" />
> >
> > > -----Original Message-----
> > > From: Duddikunta, Padmanabha [mailto:Pkd2@cdc.gov]
> > > Sent: Monday, June 16, 2003 9:56 AM
> > > To: 'Turbine Torque Users List'
> > > Subject: RE: Schema qualifier for table names
> > >
> > > Ramesh,
> > >
> > > Would you mind posting a portion of your generated XML schema.
> > Especially
> > > I
> > > am interested in seeing the following.
> > >
> > > <database name="ehaz" ..........................................>
> > > <table name="SITE" javaName="Site" idMethod="none">
> > >     <column name="SITE_ID" javaName="SiteId" required="true"
> > > type="VARCHAR"
> > > size="12" />
> > >     <column name="SUPERFUND_NUM" javaName="SuperfundNum"
> > required="false"
> > > type="VARCHAR" size="7" />
> > >     <column name="ATS_STATUS" javaName="AtsStatus" required="true"
> > > type="VARCHAR" size="1" />
> > > .
> > > .
> > > .
> > >
> > >
> > > Thanks
> > > Paddy
> > >
> > >
> > >
> > >
> > > -----Original Message-----
> > > From: Ramesh Sabeti [mailto:rs@reazon.com]
> > > Sent: Monday, June 16, 2003 12:50 PM
> > > To: 'Turbine Torque Users List'
> > > Subject: RE: Schema qualifier for table names
> > >
> > > I'm generating the XML Schema directly from the database.  Maybe
you
> > > need to qualify table names in your SQL file with "XYZ." To avoid
> the
> > > default qualifier of user name "dbuser."
> > >
> > > > -----Original Message-----
> > > > From: Duddikunta, Padmanabha [mailto:Pkd2@cdc.gov]
> > > > Sent: Monday, June 16, 2003 9:40 AM
> > > > To: 'Turbine Torque Users List'
> > > > Subject: RE: Schema qualifier for table names
> > > >
> > > > I generated my XML schema from a SQL file.  I don't see anything
> > > > corresponding to schema qualifier in the generated XML schema.
> > > >
> > > > -----Original Message-----
> > > > From: Ramesh Sabeti [mailto:rs@reazon.com]
> > > > Sent: Monday, June 16, 2003 12:33 PM
> > > > To: 'Turbine Torque Users List'
> > > > Subject: RE: Schema qualifier for table names
> > > >
> > > > This is what I use for Oracle in torque.build:
> > > >
> > > > torque.database.schema=XYZ
> > > >
> > > >
> > > > > -----Original Message-----
> > > > > From: Duddikunta, Padmanabha [mailto:Pkd2@cdc.gov]
> > > > > Sent: Monday, June 16, 2003 9:22 AM
> > > > > To: 'torque-user@db.apache.org'; 'torque-dev@db.apache.org'
> > > > > Subject: Schema qualifier for table names
> > > > >
> > > > > I having trouble specifying schema qualifier for tables.  I
> login
> > to
> > > > > database using a user "dbuser", but my tables lie under a
> > different
> > > > schema
> > > > >
> > > > > say XYZ schema.
> > > > >
> > > > >
> > > > >
> > > > > Now I want to query XYZ.TABLE1.  But torque seems to generate
> sql
> > > > > something
> > > > > like,
> > > > >
> > > > >
> > > > >
> > > > > SELECT COL1, COL2, COL3 FROM dbuser.TABLE1   instead of
> > > > >
> > > > >
> > > > >
> > > > > SELECT COL1, COL2, COL3 FROM XYZ.TABLE1
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > I would appreciate any pointer on solving this problem.
> > > > >
> > > > >
> > > > >
> > > > > Thanks
> > > > >
> > > > > Paddy
> > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > >
> > > >
> >
---------------------------------------------------------------------
> > > > 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
> > >
> > >
> > >
> > >
> ---------------------------------------------------------------------
> > > 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
> >
> >
> >
> >
---------------------------------------------------------------------
> > 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
> 
> 
> 
> ---------------------------------------------------------------------
> 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