473,881 Members | 1,765 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Record lock timeout with webservices

We have a smart device application running on handhelds(Symbo l 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 4020
Use transaction in strored procedure instead of web service.

"Komandur Kannan" wrote:
We have a smart device application running on handhelds(Symbo l 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(Symbo l 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(Symbo l 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(Symbo l 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: AcV58cjpfxNVVjf SSSi8vSzNrixZHg ==
X-WBNR-Posting-Host: 213.42.2.11
From: =?Utf-8?B?S29tYW5kdXI gS2FubmFu?=
<Ko************ @discussions.mi crosoft.com>
References: <4D************ *************** *******@microso ft.com>
<A0************ *************** *******@microso ft.com>
Subject: RE: Record lock timeout with webservices
Date: Sat, 25 Jun 2005 18:53:01 -0700
Lines: 22
Message-ID: <AE************ *************** *******@microso ft.com>
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.publi c.dotnet.framew ork.webservices
NNTP-Posting-Host: TK2MSFTNGXA03.p hx.gbl 10.40.2.250
Path: TK2MSFTNGXA01.p hx.gbl!TK2MSFTN GXA03.phx.gbl
Xref: TK2MSFTNGXA01.p hx.gbl
microsoft.publi c.dotnet.framew ork.webservices :6941
X-Tomcat-NG: microsoft.publi c.dotnet.framew ork.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(Symbo l 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: AcV58cjpfxNVVjf SSSi8vSzNrixZHg ==
X-WBNR-Posting-Host: 213.42.2.11
From: =?Utf-8?B?S29tYW5kdXI gS2FubmFu?=
<Ko************ @discussions.mi crosoft.com>
References: <4D************ *************** *******@microso ft.com>
<A0************ *************** *******@microso ft.com>
Subject: RE: Record lock timeout with webservices
Date: Sat, 25 Jun 2005 18:53:01 -0700
Lines: 22
Message-ID: <AE************ *************** *******@microso ft.com>
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.publi c.dotnet.framew ork.webservices
NNTP-Posting-Host: TK2MSFTNGXA03.p hx.gbl 10.40.2.250
Path: TK2MSFTNGXA01.p hx.gbl!TK2MSFTN GXA03.phx.gbl
Xref: TK2MSFTNGXA01.p hx.gbl
microsoft.publi c.dotnet.framew ork.webservices :6941
X-Tomcat-NG: microsoft.publi c.dotnet.framew ork.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(Symbo l 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: AcWMOxZezRahzB7 STOWSsXDu8QubVA ==
X-WBNR-Posting-Host: 213.42.2.26
From: =?Utf-8?B?S29tYW5kdXI gS2FubmFu?= <ka****@nomail. nospam>
References: <4D************ *************** *******@microso ft.com>
<A0************ *************** *******@microso ft.com>
<AE************ *************** *******@microso ft.com>
<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************ *************** *******@microso ft.com>
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.publi c.dotnet.framew ork.webservices
NNTP-Posting-Host: TK2MSFTNGXA03.p hx.gbl 10.40.2.250
Path: TK2MSFTNGXA01.p hx.gbl!TK2MSFTN GXA03.phx.gbl
Xref: TK2MSFTNGXA01.p hx.gbl
microsoft.publi c.dotnet.framew ork.webservices :7246
X-Tomcat-NG: microsoft.publi c.dotnet.framew ork.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: AcV58cjpfxNVVjf SSSi8vSzNrixZHg ==
X-WBNR-Posting-Host: 213.42.2.11
From: =?Utf-8?B?S29tYW5kdXI gS2FubmFu?=
<Ko************ @discussions.mi crosoft.com>
References: <4D************ *************** *******@microso ft.com>
<A0************ *************** *******@microso ft.com>
Subject: RE: Record lock timeout with webservices
Date: Sat, 25 Jun 2005 18:53:01 -0700
Lines: 22
Message-ID: <AE************ *************** *******@microso ft.com>
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.publi c.dotnet.framew ork.webservices
NNTP-Posting-Host: TK2MSFTNGXA03.p hx.gbl 10.40.2.250
Path: TK2MSFTNGXA01.p hx.gbl!TK2MSFTN GXA03.phx.gbl
Xref: TK2MSFTNGXA01.p hx.gbl
microsoft.publi c.dotnet.framew ork.webservices :6941
X-Tomcat-NG: microsoft.publi c.dotnet.framew ork.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(Symbo l 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 New Member
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
2818
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 class that allows for a timeout but doesn't use polling. All comments are welcome. ----------------------- Tlock.py -------------------------------
5
11112
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 have some questions regarding LOCK TIMEOUT and its compatibility with LOCK MODE WAIT in INFOMIX. Last week, I just found out that the following statement was complied and built in Stored Procedure SET LOCK MODE TO WAIT 5;
2
4598
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 Here's the scenario: 1. .NET Windows Client on a remote machine makes a web service call to update tables on a Web Server running SQL Server 2000. 2. The Update is updating about 1000 - 3000 records doing simple update statements like "Update...
2
4726
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. Unforuntatley, I tend to get a timeout message on my client which is not good. I want the client to wait until it gets a response. Can I adjust the amount of time that it waits? If so where is that at?
0
1050
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 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...
4
9555
by: A.M-SG | last post by:
Hi, How can I increase the HTTP Timeout value at the client side? Thank you, Alan
19
1727
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 record then updating it, there is no lock on that record while you are making the changes in your browser window. Does transactions handle that? Do you make your selection and update all part of the same transaction? This whole scenario has me...
9
2663
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 data. And there is an Intranet ASP.NET application which is an interface to the database in question... and there are 100 pretty girls eager to... uhmm... use the application and validate the data of course ;-). The task is to enable the data...
0
11712
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 java.sql.SQLException: Deadlock found when trying to get lock; Try restarting transaction message from server: "Lock wait timeout exceeded; try restarting transaction"; We get such errors generally on inserts or updates while applying a
0
9930
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
11103
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10720
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
9555
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
7113
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5978
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4597
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4196
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3225
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.