<div>
thanks yongsing,<br />
<br />
is this method really effective? do you think it is better to also configure on the database side?
</div>


thanks yongsing,

is this method really effective? do you think it is better to also configure on the database side?

<div>
I have not tried it before, but you can always test it out. You can try configuring the database as well, but you should program your application such that it knows that a timeout has occurred when an SQLException is thrown.
</div>


I have not tried it before, but you can always test it out. You can try configuring the database as well, but you should program your application such that it knows that a timeout has occurred when an SQLException is thrown.

<div>
No comment has been added lately, so it's time to clean up this TA.<br />
<br />
I will leave a recommendation in the Cleanup topic area that this question is:<br />
<br />
- points to yongsing<br />
<br />
Please leave any comments here within the<br />
next seven days.<br />
<br />
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !<br />
<br />
girionis<br />
Cleanup Volunteer<br />

</div>


No comment has been added lately, so it's time to clean up this TA.

I will leave a recommendation in the Cleanup topic area that this question is:

- points to yongsing

Please leave any comments here within the
next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !

girionis
Cleanup Volunteer


<div>
<div class="content wysiwyg-content">
i have a database component called JDBCController. i need some suggestions on timeout mechanism in this component. this is the problem that i faced:<br />
<br />
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.<br />
<br />
any suggestions on this?<br />

</div>
</div>


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?


timeout mechanism in database component

Java is a platform-independent, object-oriented programming language and run-time environment, designed to have as few implementation dependencies as possible such that developers can write one set of code across all platforms using libraries. Most devices will not run Java natively, and require a run-time component to be installed in order to execute a Java program.