db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ramesh Sabeti" ...@reazon.com>
Subject RE: Schema qualifier for table names
Date Mon, 16 Jun 2003 17:12:50 GMT
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



Mime
View raw message