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 16:50:06 GMT
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



Mime
View raw message