SQL timeout for JSP file?

Question

Java

There is a very simple jsp file designed to check the connection to the database:

&lt;%@ taglib uri=&quot;http://java.sun.com/jstl/sql&quot; prefix=&quot;sql&quot; %&gt;<br/>
&lt;sql:query var=&quot;tests&quot; dataSource=&quot;MYBD&quot;&gt;<br/>
 SELECT 'Test'<br/>
&lt;/sql:query&gt;<br/>

What is the way to interrupt waiting for MS-SQL query response after some specific time?
JavaScript cannot be used.

Answer 1

I'm not a great Java specialist, but maybe you need to check the availability of the DBMS using a separate function using JDBC with a connection timeout?