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]
