Re: setQueryTimeout problem !?!?! - Mailing list pgsql-jdbc

From robert engels
Subject Re: setQueryTimeout problem !?!?!
Date
Msg-id 578F9AE2-CD8D-45C3-966E-6B1AB825DA6B@ix.netcom.com
Whole thread Raw
In response to Re: setQueryTimeout problem !?!?!  (Oliver Jowett <oliver@opencloud.com>)
Responses Re: setQueryTimeout problem !?!?!  (Oliver Jowett <oliver@opencloud.com>)
List pgsql-jdbc
Here is the javadoc. The method explicitly states when it throws an exception:

    /**
     * Sets the number of seconds the driver will wait for a 
     * <code>Statement</code> object to execute to the given number of seconds.
     * If the limit is exceeded, an <code>SQLException</code> is thrown.
     *
     * @param seconds the new query timeout limit in seconds; zero means 
     *        there is no limit
     * @exception SQLException if a database access error occurs
     *            or the condition seconds >= 0 is not satisfied
     * @see #getQueryTimeout
     */

Even if this is not sufficient, it worked this way in the previous driver versions - so I guess there should be evidence the other way in order to change it.

This is not a problem when using the 8.3 driver against an 8.3 database - only seems to happen with a 8.1 db (maybe 8.2???)

On Mar 17, 2008, at 6:14 PM, Oliver Jowett wrote:

robert engels wrote:

The specification states that the request should be ignored - not throw an exception in this case.

Do you have a spec reference for this?

-O


-- 
Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
To make changes to your subscription:

pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: setQueryTimeout problem !?!?!
Next
From: Kris Jurka
Date:
Subject: Re: JDBC rewriting a bad query?