db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Edgar González <...@valhallaproject.com>
Subject Re: Schema qualifier for table names
Date Mon, 16 Jun 2003 21:56:07 GMT
IMHO the property

torque.database.schema

has means in the JDBCToXMLSchema task, in order to generate only the tables
in this schema.

Paddy, I address this issue creating synonims in the database.

I'm not tried to specify the owner in the schema.xml, but I think it should
work
e.g:
<table name="owner.mytable" javaName="myTable" ...

----------------------------------------------------------------------------
Edgar Gonzalez Gonzalez
VALHALLA Project, s.a.
Chief Technology Officer
Web: www.valhallaproject.com
E-mail: egg@valhallaproject.com
Phone: +58-212-242.4379 / 6662 / 4055 / 6475
Fax: +58-212-242.6809

"The limits of my language mean the limits of my world."
Ludwig Wittgenstein

----------------------------------------------------------------------------

----- Original Message -----
From: "Duddikunta, Padmanabha" <Pkd2@cdc.gov>
To: "'Turbine Torque Users List'" <torque-user@db.apache.org>
Sent: Monday, June 16, 2003 5:32 PM
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
>
>
>


Mime
View raw message