RE: Schema name in DB2

["Thavutam, Prashanth" <1t...@toysrus.com>]

Please see the below issue and any response is appreciated.

Thanks,
Prashanth

-----Original Message-----
From: Stuart Belden [mailto:SBelden@bjc.org]
Sent: Friday, November 21, 2003 1:32 PM
To: jetspeed-user@jakarta.apache.org
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.

>>> 1thavutp@toysrus.com 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 EmailAdmin@toysrus.com. 
Toys "R" Us, Inc.

---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org 
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org 





---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org