Hi, all:
We have a Windows application that make operations against an Oracle
database. The business logic components are in the server and are accesible
from the client interface trought a WebService. The business logic components
call the data access layer components and obtain the results. tha problem is
as follows:
one application requirement is that when a user make some operations, the
tables (or rows) he is working to remain locked until he finish his work,
maybe in that moment maybe after some minutes. But, as I know, Oracle tables
locks are associated with the connections, I mean, if I close the connection
the lock desappears. that´s right? Because I´m calling the business layer
trought a web service, when this call finish the lock ends. Do you know what
I mean? Anyone knows how to maintain locks in the database?
Thank you so much for your help!
cheers!
