Hello,
I am using SAP-DB 7.3.0.25 with JDBC in JAVA-Servlets. When the Servlet is
loaded,
it connects to the database. After a session timeout, the servlet should
automatically reconnect
to the DB.
Now, when a session timeout occurs, a select statement always needs 120
seconds,
until an SQLException occurs, although I set the queryTimeout to 5 seconds:
My DBCheck-Method goes:
try
{
Statement stmtTest;
ResultSet rsTest;
stmtTest=conn.createStatement();
stmtTest.setQueryTimeout(5);
rsTest=stmtTest.executeQuery("select ........"); // needs 120
seconds
rsTest.close();
stmtTest.close();
}
catch (Exception e)
{
reconnect .......
}
How can I configure SAP-DB (or my JDBC-Connection), that the SQLException
is coming earlier?
Regards
Uli
____________________________________________________
Ulrich Lickert, Universitaetsklinikum Freiburg
Klinikrechenzentrum, Agnesenstr. 6-8, D-79106 Freiburg
Tel +49-761-270-2265 Fax +49-761-270-2066
Email [EMAIL PROTECTED]
WWW: http://www.uniklinik-freiburg.de/
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
