arabinda baas

thanks a lot for replying.
i am using informix db.
catching the exception seems to be the easier one.
as java api says getErrorCode() method will display the vendor specific error codes.
Can it happen like informix team uses same error codes for different errors.

Hi all,

i have a problem like, lets say a database table is locked in shared mode.
At that time another thread is trying to put Exclusive lock on it.
so my question is how can you check the type of lock present on a particular table. If we can find out that there is already some lock present on a table, then we can make the second thread to wait for the lock to be released.

Any input on the same will be helpful.

Thanks