db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Duddikunta, Padmanabha" <P...@cdc.gov>
Subject RE: Schema qualifier for table names
Date Mon, 16 Jun 2003 16:40:18 GMT
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

Mime
View raw message