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]
