Sybase

While using sybase as database and using connection objects.
WHen any chance ,if there is any lock is set on table , our application will be hanged.due to the connection object will be waiting until the lock is released .

then we can solve it by executing a query while getting the connnection object itself.

from now onwards if there are deadlocks or waiting on table ..this connection object will wait for specific time and return back with altering ,
then we have control over the connection..

query="set lock wait 10";