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: [EMAIL PROTECTED] 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" <[EMAIL PROTECTED]> To: "'Turbine Torque Users List'" <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED] > 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:[EMAIL PROTECTED] > > 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:[EMAIL PROTECTED] > > 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:[EMAIL PROTECTED] > > > 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:[EMAIL PROTECTED] > > > 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:[EMAIL PROTECTED] > > > > 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:[EMAIL PROTECTED] > > > > 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:[EMAIL PROTECTED] > > > > > Sent: Monday, June 16, 2003 9:22 AM > > > > > To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]' > > > > > 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: [EMAIL PROTECTED] > > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > > > --------------------------------------------------------------------- > > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > > > > > > --------------------------------------------------------------------- > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > --------------------------------------------------------------------- > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
