RE: Schema name

2005-06-10 Thread Thomas Fischer
in 3.1.1 and soone, Torque is not able to extract the correct column name from a String like "creator.MYTABLE.someColumn". Thomas "Gerhard Otte" <[EMAIL PROTECTED]> schrieb am 10.06.2005 16:46:24: > Hello ! > > Im using torque 3.1 and wonder if it

Schema name

2005-06-10 Thread Gerhard Otte
Hello ! Im using torque 3.1 and wonder if it's possible to have a schema name prefixed to the tablename. The generated sql should look like this select COL1 from creator.MYTABLE where ... When I generated my objectmodel I specified torque.database.schema = creator in my build property

Fwd: RE: Schema name in DB2

2003-12-22 Thread Charles-Alexandre Sabourdin
I finally got the schema name prefix working with small changes in BasePeer.java and Criteria.java But, I think we want to create a user JSSU and use it rather than using the changed code, to be able to easily upgrade the version. Thanks for your response. Prashanth -Original Message- F

RE: Schema name in DB2

2003-11-21 Thread Thavutam, Prashanth
I finally got the schema name prefix working with small changes in BasePeer.java and Criteria.java But, I think we want to create a user JSSU and use it rather than using the changed code, to be able to easily upgrade the version. Thanks for your response. Prashanth -Original Message

R: Schema name in DB2

2003-11-21 Thread Giulio Vezzelli
I had schema problems too, with DB2 and Torque. I used this dirty workaround : DB2 tries to use the database user name you supplied as the schema name, if not specified. So, if you create and use a "JSSU" user for connecting to DB2, you'll handle it. I know it's not the &qu

RE: Schema name in DB2

2003-11-21 Thread Thavutam, Prashanth
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

Re: Trouble with schema name in DB2 SQL - torque newbie

2003-08-20 Thread Amy Smith
On Tue, 2003-08-19 at 11:03, Amy Smith wrote: > Is there a way to append a schema name in front of the table name in the > from clause? On Tue, 2003-08-19 at 15:30, Dave Newton wrote: > For a different reason, but with the same effect, I simply modified > several of the Veloci

RE: Trouble with schema name in DB2 SQL - torque newbie

2003-08-19 Thread Lach, Thierry
This capability would also be useful for Oracle users. -Original Message- From: Amy Smith [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 19, 2003 11:03 AM To: [EMAIL PROTECTED] Subject: Trouble with schema name in DB2 SQL - torque newbie Hi all, It looks like Torque does not specify

Re: Trouble with schema name in DB2 SQL - torque newbie

2003-08-19 Thread Dave Newton
On Tue, 2003-08-19 at 11:03, Amy Smith wrote: > Is there a way to append a schema name in front of the table name in the > from clause? For a different reason, but with the same effect, I simply modified several of the Velocity templates Torque uses to generate the java code. Perhaps this

Trouble with schema name in DB2 SQL - torque newbie

2003-08-19 Thread Amy Smith
Hi all, It looks like Torque does not specify a schema name in front of the table name in the from clause. eg: select option_id from option_mstr_index DB2 here is set to default to the username and we must always specify the schema name first. eg select option_id from