Please see the below issue and any response is appreciated. Thanks, Prashanth
-----Original Message----- From: Stuart Belden [mailto:[EMAIL PROTECTED] Sent: Friday, November 21, 2003 1:32 PM To: [EMAIL PROTECTED] Subject: RE: Schema name in DB2 You may want to post to the Torque mailing list if you haven't already, as this is a problem with Torque (I believe). They may be able to provide a better answer, faster. >>> [EMAIL PROTECTED] 11/21/03 10:13AM >>> I debugged through the code and found that the table name in the sql is malformed by BasePeer: sql= "SELECT JSSU.USER.USER_ID, JSSU.USER.LOGIN_NAME, JSSU.USER.PASSWORD_VALUE, JSSU.USER.FIRST_NAME, JSSU.USER.LAST_NAME, JSSU.USER.EMAIL, JSSU.USER.CONFIRM_VALUE, JSSU.USER.MODIFIED, JSSU.USER.CREATED, JSSU.USER.LAST_LOGIN, JSSU.USER.DISABLED, JSSU.USER.OBJECTDATA, JSSU.USER.PASSWORD_CHANGED FROM JSSU WHERE JSSU.USER.LOGIN_NAME='anon'" JSSU is the schema name that I am prefixing to the table name. DatabaseMap correctly built the table name as JSSU.USER, but in the BasePeer class, it is taking only JSSU. I need to get this done ASAP, please let me know how do I use a schema name to qualify the table name. Thanks, Prashanth -----Original Message----- From: Thavutam, Prashanth Sent: Thursday, November 20, 2003 3:23 PM To: 'Jetspeed Users List' Subject: Schema name in DB2 Hi, I need to use schema name to qualify the table names in DB2, so I created an entry in the properties file, getting it in the *Peer classes and prefixing it to the table names. I left the database name to default. When I run the application, BasePeer.doSelect(criteria) throws SQLException with "<username>.<schemaname> is undefined name. Is this the right way of using schema-name prefix?. Database name, user name and schema name are different in my environment. Thanks, Prashanth ======================================================================== This email message is for the sole use of the intended recipient (s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. To reply to our email administrator directly, send an email to [EMAIL PROTECTED] Toys "R" Us, Inc. --------------------------------------------------------------------- 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]
