Torque, JBoss and Axis

2004-09-08 Thread Gerhard Otte
Hello ! We are using Torque and Axis to integrate a couple of ms visualbasic clients via web service interface with our warehouse application. As this app grows we are going to use a jboss server (3.2.5) for some upcoming extensions. For now i have three questions. Here they are: a) Can someone

Antwort: blocking calls, query timeout

2004-09-08 Thread arne . siegel
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:

AW: Antwort: blocking calls, query timeout

2004-09-08 Thread Sperlich, Tino
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