Web and Lock...

Hi

I have seen many posting related to Lock / Kill / Acquire / Release ... In our web scenario , we have built a SOFT LOCK approach, where we store the PK's with session id Etc Etc of the row that has been retrieved and put a timeout seconds...

We have been trying to convert out existing forms 6i app to web .. most of the places we have a execute query with update clause..means, when i retrieve the row, it acquires the lock !!! The problem is connection drops !!! I am sure PMON wakes up time to time to clean up these dead processes...but what is that interval time ??? How long ??? Can we set the interval in which PMON is expected to wake up and clean ??? If i get the answers for these, probably i would look at existing method...Otherwise, i got to implement the soft lock approach as i mentioned above in all the forms...(any better idea)..

Also, if somebody can give me an input of what are the parameters that i have to setup in forms90.properties to make it run fastly and efficiently...is there is something can be done at Jinitator level to make it better !!! any help is highly appreciated..

vj Received on Wed Nov 19 2003 - 08:39:38 CST