oracle statement parsing/select * from ...

[Robert Dietrick <rd...@sega.com>]

I'm using Torque 3.0, and I've modified all of the generated code to 
make doPSSelect() calls instead of doSelect() calls.  Still, our DBA 
insists that he sees a high parse rate in our Oracle database with 
statements such as:
SELECT *
FROM user_action
WHERE USER_ID=51521

I've seen references in the mailing list archives to problems in which 
Torque does a select before issuing an update or insert statement.  Can 
anyone shed any light on this situation?  Has anyone else encountered this?

-rob


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

RE: oracle statement parsing/select * from ...

[Ramesh Sabeti <rs...@reazon.com>]

Robert,

Did you find an answer to your question?  I'm running into the same
problem, except doPSSelect returns a totally different list (list
elements are of type com.workingdogs.village.Record) which totally
crashes my program.

Ramesh.

> -----Original Message-----
> From: Robert Dietrick [mailto:rdietrick@sega.com]
> Sent: Wednesday, October 08, 2003 11:42 AM
> To: torque-user@db.apache.org
> Subject: oracle statement parsing/select * from ...
> 
> I'm using Torque 3.0, and I've modified all of the generated code to
> make doPSSelect() calls instead of doSelect() calls.  Still, our DBA
> insists that he sees a high parse rate in our Oracle database with
> statements such as:
> SELECT *
> FROM user_action
> WHERE USER_ID=51521
> 
> I've seen references in the mailing list archives to problems in which
> Torque does a select before issuing an update or insert statement.
Can
> anyone shed any light on this situation?  Has anyone else encountered
> this?
> 
> -rob
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org



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