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:32:55 GMT
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
> 
> 
> 
> 



Mime
View raw message