db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sperlich, Tino" <t.sperl...@hpc-hamburg.de>
Subject AW: Antwort: blocking calls, query timeout
Date Wed, 08 Sep 2004 15:16:36 GMT
Hi Arne,

thanks for your replies.
The nowait option really
seems to be doing what is required:
return if the row is blocked by
smbd. else.

excuse me if I keep asking, but 
how would I code that with Torque?

Do I have to create a custom query
or even raw sql? that would be the
very last choice since then 
I would loose torque mapping db-stuff
to my objects...

I saw that in Hibernate the criteria object
has the setQueryTimeout option, and 
I have also looked at the torque source
and it seems to me that adding that to 
torque/village is quite an effort...

Gruesse,

Tino

-----Urspr√ľngliche Nachricht-----
Von: arne.siegel@pta.de [mailto:arne.siegel@pta.de]
Gesendet: Mittwoch, 8. September 2004 16:14
An: Apache Torque Users List
Betreff: Antwort: blocking calls, query timeout



Hi Tino once more,


another more "official" way to achieve your goal is accessing the
to-be-updated database rows with the


SELECT ... FOR UPDATE NOWAIT


statement.


I believe there has already been some discussion around that theme complex
in this list.


Gruss


Arne


"Sperlich, Tino" wrote:


Hi all,

my problem is this:
My app using torque accesses an oracle db that
is shared with other apps. These apps tend to
use long blocking calls to select/update data,
causing my app to wait forever on updating that
same data.

As I cannot change those other apps I would
like to detect these blockings and handle them,
but therefore I need to set the timeout or smth. on
my queries, so they return with a nice SQLException
stating the error.

How would I set this timeout in torque, are there
other ways to cope with this problem?

Best regards,

Tino Sperlich



**********************************************************************
http://www.pta.de
Mit 1006 Erfahrungsberichten aus 35 Jahren erfolgreicher Projektarbeit!
**********************************************************************



---------------------------------------------------------------------
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


Mime
View raw message