i have a database component called JDBCController. i need some suggestions on timeout mechanism in this component. this is the problem that i faced:
let say i do a select statement (using say method executeQuery in JDBCController) to select a record. suppose if that particular record is locked by some other applications and it is never release the lock. the method executeQuery will also be blocked indefinitely. as such, it is important to make sure that any request will not be blocked indefinitely.
any suggestions on this?