Re: setQueryTimeout not working

From: Sue Purkis (suepurkis_at_yahoo.com)
Date: 08/13/04 

Date: 13 Aug 2004 08:14:48 -0700

Rueben,
  I used your code snippet in one of my programs and it worked as
expected. Can you share the rest of your code and connection options,
so I can compare what I have with what you have?

  Thanks.

Sue Purkis
DataDirect Technologies.

"Ruben Hesselbęk" <Mr.Chaos@area99.dk> wrote in message news:<uzbpJxVeEHA.1656@TK2MSFTNGP09.phx.gbl>...
> Does setQueryTimeout work in the latest JDBC driver ?
>
> We have a tool that executes some queries, but the first couple of queries
> timeout just after the connection has been established.
> Each query is tried 3 times and each time the QueryTimeout is doubled (300
> seconds default), and everything below happens in the same synchronized
> block.
>
> The first 3 columns are DATE TIME and ms, so how can the JDBC driver claim
> that the query timed out within the same milisecond ?
> Totally during the 3 retries 2100 seconds should have been used, but as you
> can see in the logs only 78ms were actually used
>
> 040803 145706 0632 EV report connectToSQLServer Connected to SQL server
> succesfully ##[
> 040803 145706 0695 ER report executeQuery caught exception while
> executing [select * from TABLE where 1=2] with timeout
> [300]java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for
> JDBC]Execution timeout expired.
> ##[pi=Tomcat,ti=HttpProcessor[80][4],cr=platform.report.util.CoreLogAdapter.
> log(CoreLogAdapter.java:74)
> 040803 145706 0695 EV report executeQuery Setting new timeout [600] ##[
> 040803 145706 0710 ER report executeQuery caught exception while
> executing [select * from TABLE where 1=2] with timeout
> [300]java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for
> JDBC]Execution timeout expired.
> ##[pi=Tomcat,ti=HttpProcessor[80][4],cr=platform.report.util.CoreLogAdapter.
> log(CoreLogAdapter.java:74)
> 040803 145706 0710 EV report executeQuery Setting new timeout [1200] ##[
> 040803 145706 0710 ER report executeQuery caught exception while
> executing [select * from TABLE where 1=2] with timeout
> [300]java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for
> JDBC]Execution timeout expired.
> ##[pi=Tomcat,ti=HttpProcessor[80][4],cr=platform.report.util.CoreLogAdapter.
> log(CoreLogAdapter.java:74)
> 040803 145706 0710 EV report executeQuery Setting new timeout [2400] ##[
> 040803 145706 0710 ER report executeQuery failed after 3 retries (cause
> exception: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for
> JDBC]Execution timeout expired.)
>
> Here is the code
>
> for (int retry = 1; retry <= retries; retry += 1) {
> try {
> statement.setQueryTimeout(timeout);
> rs = statement.executeQuery(sql);
> return rs;
> } catch (SQLException e) {
> if (rs != null) {
> try {
> while (rs.next());
> } catch (SQLException ex) {
> }
> finally {
> try {
> rs.close();
> }
> catch (SQLException ex) {
> }
> }
> rs = null;
> }
> log.error("executeQuery", "caught exception while executing
> ["+sql+"] with timeout ["+timeout+"]" + e);
> // double sqltimeout for next try
> timeout = timeout * 2;
> log.event("executeQuery", "Setting new timeout [" + timeout +"]");
> }
> }
>
> Hope someone can help
>
> /Ruben

Loading