473,326 Members | 2,111 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Record lock timeout with webservices

We have a smart device application running on handhelds(Symbol MC9000G). The
backend is Oracle and a middle tier web services development done in Vb.net.

We use pessimistic Locking due to specific business needs
When such a lock is made for a transaction (this code is in the web service)
and the handhelds are terminated abnormally (cold booted or battery low),
the lock still remains. The Web service's connection to oracle is still
active and it does not know that the handheld using it is now inactive.

How do we timeout the transaction to unlock and roll back
Nov 23 '05 #1
8 3973
Use transaction in strored procedure instead of web service.

"Komandur Kannan" wrote:
We have a smart device application running on handhelds(Symbol MC9000G). The
backend is Oracle and a middle tier web services development done in Vb.net.

We use pessimistic Locking due to specific business needs
When such a lock is made for a transaction (this code is in the web service)
and the handhelds are terminated abnormally (cold booted or battery low),
the lock still remains. The Web service's connection to oracle is still
active and it does not know that the handheld using it is now inactive.

How do we timeout the transaction to unlock and roll back

Nov 23 '05 #2
Use transaction in strored procedure instead of web service.

"Komandur Kannan" wrote:
We have a smart device application running on handhelds(Symbol MC9000G). The
backend is Oracle and a middle tier web services development done in Vb.net.

We use pessimistic Locking due to specific business needs
When such a lock is made for a transaction (this code is in the web service)
and the handhelds are terminated abnormally (cold booted or battery low),
the lock still remains. The Web service's connection to oracle is still
active and it does not know that the handheld using it is now inactive.

How do we timeout the transaction to unlock and roll back

Nov 23 '05 #3
Thanks for reply. We already use stored procedure for this. the webservices
calls this procedure to lock/unlock records. This webservice is used by the
portable terminals. When pdt (portables) freezes, the oracle server is not
aware that the client is done since for the oracle server the client is web
services which is alive - so i need a way to timeout this.

"Ajit" wrote:
Use transaction in strored procedure instead of web service.

"Komandur Kannan" wrote:
We have a smart device application running on handhelds(Symbol MC9000G). The
backend is Oracle and a middle tier web services development done in Vb.net.

We use pessimistic Locking due to specific business needs
When such a lock is made for a transaction (this code is in the web service)
and the handhelds are terminated abnormally (cold booted or battery low),
the lock still remains. The Web service's connection to oracle is still
active and it does not know that the handheld using it is now inactive.

How do we timeout the transaction to unlock and roll back

Nov 23 '05 #4
Thanks for reply. We already use stored procedure for this. the webservices
calls this procedure to lock/unlock records. This webservice is used by the
portable terminals. When pdt (portables) freezes, the oracle server is not
aware that the client is done since for the oracle server the client is web
services which is alive - so i need a way to timeout this.

"Ajit" wrote:
Use transaction in strored procedure instead of web service.

"Komandur Kannan" wrote:
We have a smart device application running on handhelds(Symbol MC9000G). The
backend is Oracle and a middle tier web services development done in Vb.net.

We use pessimistic Locking due to specific business needs
When such a lock is made for a transaction (this code is in the web service)
and the handhelds are terminated abnormally (cold booted or battery low),
the lock still remains. The Web service's connection to oracle is still
active and it does not know that the handheld using it is now inactive.

How do we timeout the transaction to unlock and roll back

Nov 23 '05 #5
Hi Komandur,

How are you doing on this issue currently , are you still suffering this
problem? As you mentioned that since it is the webservice which makes the
store procedure call to the backend oracle db, the front client's inactive
won't notify the backend db to abort the transaction,yes? If so, have you
tried setting command timeout in the webservice method (for example, if
you're using the Command object to execute the store procedure, we can
apply a timeout on it, does this helps? In addition, I also suggest you
try posting in the ADO.NET group to see whether any guys there have some
good suggstions on this. Thanks,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

--------------------
Thread-Topic: Record lock timeout with webservices
thread-index: AcV58cjpfxNVVjfSSSi8vSzNrixZHg==
X-WBNR-Posting-Host: 213.42.2.11
From: =?Utf-8?B?S29tYW5kdXIgS2FubmFu?=
<Ko************@discussions.microsoft.com>
References: <4D**********************************@microsoft.co m>
<A0**********************************@microsoft.co m>
Subject: RE: Record lock timeout with webservices
Date: Sat, 25 Jun 2005 18:53:01 -0700
Lines: 22
Message-ID: <AE**********************************@microsoft.co m>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
Newsgroups: microsoft.public.dotnet.framework.webservices
NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl
microsoft.public.dotnet.framework.webservices:6941
X-Tomcat-NG: microsoft.public.dotnet.framework.webservices

Thanks for reply. We already use stored procedure for this. the webservices
calls this procedure to lock/unlock records. This webservice is used by the
portable terminals. When pdt (portables) freezes, the oracle server is not
aware that the client is done since for the oracle server the client is web
services which is alive - so i need a way to timeout this.

"Ajit" wrote:
Use transaction in strored procedure instead of web service.

"Komandur Kannan" wrote:
We have a smart device application running on handhelds(Symbol MC9000G). The backend is Oracle and a middle tier web services development done in Vb.net.
We use pessimistic Locking due to specific business needs
When such a lock is made for a transaction (this code is in the web service) and the handhelds are terminated abnormally (cold booted or battery low), the lock still remains. The Web service's connection to oracle is still
active and it does not know that the handheld using it is now inactive.

How do we timeout the transaction to unlock and roll back


Nov 23 '05 #6
Dear Steven Cheng

Thanks for your idea.
I also put a timer control and am unlocking it based on the time set.
It has worked in a test environment.

Archana
(On Behalf of Komandur Kannan)

"Steven Cheng[MSFT]" wrote:
Hi Komandur,

How are you doing on this issue currently , are you still suffering this
problem? As you mentioned that since it is the webservice which makes the
store procedure call to the backend oracle db, the front client's inactive
won't notify the backend db to abort the transaction,yes? If so, have you
tried setting command timeout in the webservice method (for example, if
you're using the Command object to execute the store procedure, we can
apply a timeout on it, does this helps? In addition, I also suggest you
try posting in the ADO.NET group to see whether any guys there have some
good suggstions on this. Thanks,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

--------------------
Thread-Topic: Record lock timeout with webservices
thread-index: AcV58cjpfxNVVjfSSSi8vSzNrixZHg==
X-WBNR-Posting-Host: 213.42.2.11
From: =?Utf-8?B?S29tYW5kdXIgS2FubmFu?=
<Ko************@discussions.microsoft.com>
References: <4D**********************************@microsoft.co m>
<A0**********************************@microsoft.co m>
Subject: RE: Record lock timeout with webservices
Date: Sat, 25 Jun 2005 18:53:01 -0700
Lines: 22
Message-ID: <AE**********************************@microsoft.co m>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
Newsgroups: microsoft.public.dotnet.framework.webservices
NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl
microsoft.public.dotnet.framework.webservices:6941
X-Tomcat-NG: microsoft.public.dotnet.framework.webservices

Thanks for reply. We already use stored procedure for this. the webservices
calls this procedure to lock/unlock records. This webservice is used by the
portable terminals. When pdt (portables) freezes, the oracle server is not
aware that the client is done since for the oracle server the client is web
services which is alive - so i need a way to timeout this.

"Ajit" wrote:
Use transaction in strored procedure instead of web service.

"Komandur Kannan" wrote:
We have a smart device application running on handhelds(Symbol MC9000G). The backend is Oracle and a middle tier web services development done in Vb.net.
We use pessimistic Locking due to specific business needs
When such a lock is made for a transaction (this code is in the web service) and the handhelds are terminated abnormally (cold booted or battery low), the lock still remains. The Web service's connection to oracle is still
active and it does not know that the handheld using it is now inactive.

How do we timeout the transaction to unlock and roll back

Nov 23 '05 #7
Thanks for your followup Archana,

If there are any other questions later, please feel free to post here also.
Thanks,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
--------------------
Thread-Topic: Record lock timeout with webservices
thread-index: AcWMOxZezRahzB7STOWSsXDu8QubVA==
X-WBNR-Posting-Host: 213.42.2.26
From: =?Utf-8?B?S29tYW5kdXIgS2FubmFu?= <ka****@nomail.nospam>
References: <4D**********************************@microsoft.co m>
<A0**********************************@microsoft.co m>
<AE**********************************@microsoft.co m>
<37*************@TK2MSFTNGXA01.phx.gbl>
Subject: RE: Record lock timeout with webservices
Date: Tue, 19 Jul 2005 01:23:05 -0700
Lines: 85
Message-ID: <D6**********************************@microsoft.co m>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
Newsgroups: microsoft.public.dotnet.framework.webservices
NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl
microsoft.public.dotnet.framework.webservices:7246
X-Tomcat-NG: microsoft.public.dotnet.framework.webservices

Dear Steven Cheng

Thanks for your idea.
I also put a timer control and am unlocking it based on the time set.
It has worked in a test environment.

Archana
(On Behalf of Komandur Kannan)

"Steven Cheng[MSFT]" wrote:
Hi Komandur,

How are you doing on this issue currently , are you still suffering this
problem? As you mentioned that since it is the webservice which makes the store procedure call to the backend oracle db, the front client's inactive won't notify the backend db to abort the transaction,yes? If so, have you
tried setting command timeout in the webservice method (for example, if
you're using the Command object to execute the store procedure, we can
apply a timeout on it, does this helps? In addition, I also suggest you
try posting in the ADO.NET group to see whether any guys there have some
good suggstions on this. Thanks,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

--------------------
Thread-Topic: Record lock timeout with webservices
thread-index: AcV58cjpfxNVVjfSSSi8vSzNrixZHg==
X-WBNR-Posting-Host: 213.42.2.11
From: =?Utf-8?B?S29tYW5kdXIgS2FubmFu?=
<Ko************@discussions.microsoft.com>
References: <4D**********************************@microsoft.co m>
<A0**********************************@microsoft.co m>
Subject: RE: Record lock timeout with webservices
Date: Sat, 25 Jun 2005 18:53:01 -0700
Lines: 22
Message-ID: <AE**********************************@microsoft.co m>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
Newsgroups: microsoft.public.dotnet.framework.webservices
NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl
microsoft.public.dotnet.framework.webservices:6941
X-Tomcat-NG: microsoft.public.dotnet.framework.webservices

Thanks for reply. We already use stored procedure for this. the webservices calls this procedure to lock/unlock records. This webservice is used by the portable terminals. When pdt (portables) freezes, the oracle server is not aware that the client is done since for the oracle server the client is web services which is alive - so i need a way to timeout this.

"Ajit" wrote:
Use transaction in strored procedure instead of web service.

"Komandur Kannan" wrote:
We have a smart device application running on handhelds(Symbol MC9000G). The backend is Oracle and a middle tier web services development done in Vb.net.
We use pessimistic Locking due to specific business needs
When such a lock is made for a transaction (this code is in the web service) and the handhelds are terminated abnormally (cold booted or battery low), the lock still remains. The Web service's connection to oracle is still active and it does not know that the handheld using it is now inactive.
How do we timeout the transaction to unlock and roll back


Nov 23 '05 #8
eng_kh
1
Dear Steven Cheng
please send me details about this problem and solution because i am suffering from the same problem
please send me here or on this mail
eng_kh@hotmail.com

waiting for reply
thanks
Jul 13 '06 #9

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

14
by: Antoon Pardon | last post by:
The queue and condition class allow threads to wait only a limited time. However this currently is implemented by a polling loop. Now for those who like to avoid polling I have here a Tlock...
5
by: harborboy76 | last post by:
Hi all, First of all, just want to let you know that I'm coming from Informix background, and we just recently migrated to DB2. It's been a great new learning experience. For the time being, I...
2
by: Chris Langston | last post by:
I have a Web Server running IIS 5 or 6 on Windows 2K and Windows 2003 Server that is experiencing strange shutdown problems. We are using ASP.NET v1.1 and our application is written in VB.NET ...
2
by: Dan | last post by:
All, I have a Web Service that validates a piece of data. However, the database that the data comes from is mamouth. So, it may take a long time for the validation query to complete. ...
0
by: Komandur Kannan | last post by:
We have a smart device application running on handhelds(Symbol MC9000G). The backend is Oracle and a middle tier web services development done in Vb.net. We use pessimistic Locking due to...
4
by: A.M-SG | last post by:
Hi, How can I increase the HTTP Timeout value at the client side? Thank you, Alan
19
by: rich | last post by:
I am building an app using php and postgresql. My questionis this. How do you handle people wanting to make parallel changes to a record. Since in web apps you are doing a select, bring over a...
9
by: master | last post by:
Actually, it is not only the record locking, what I need, and nobody seems to descibe this. Imagine the following scenario. There is a database with, say 10000 records with some unvalidated...
0
by: cwho.work | last post by:
Hi! We are using apache ibatis with our MySQL 5.0 database (using innodb tables), in our web application running on Tomcat 5. Recently we started getting a number of errors relating to...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.