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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]