By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,012 Members | 988 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,012 IT Pros & Developers. It's quick & easy.

Record lock timeout with webservices

P: n/a
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
Share this Question
Share on Google+
8 Replies


P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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

P: 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 discussion thread is closed

Replies have been disabled for this discussion.