Обсуждение: Status of setQueryTimeout

Hi there, I currently am using postgresql-8.2-504.jdbc.jar and had a question about the
PreparedStatement.setQueryTimeout().
I finally got around to looking at the latest releases because I wanted to get access to the generate key result sets
forinserts so I downloaded the 9 and then the 8.4 releases.  While it seemed to work in 8.2-504, none of the later
releasesseemed to accept the method, indicating the method is not implemented.  Was there something wrong with the
originalsetQueryTimeout or was it something that had to be taken out due to design changes?  Looking at the current
providedreleases I saw there was a 8.2.511 and that also seemed to accept the setQueryTimeout. 

-Scott

On Thu, 9 Dec 2010, Mackay, Scott wrote:

>
> Hi there, I currently am using postgresql-8.2-504.jdbc.jar and had a
> question about the PreparedStatement.setQueryTimeout(). I finally got
> around to looking at the latest releases because I wanted to get access
> to the generate key result sets for inserts so I downloaded the 9 and
> then the 8.4 releases.  While it seemed to work in 8.2-504, none of the
> later releases seemed to accept the method, indicating the method is not
> implemented.  Was there something wrong with the original
> setQueryTimeout or was it something that had to be taken out due to
> design changes?  Looking at the current provided releases I saw there
> was a 8.2.511 and that also seemed to accept the setQueryTimeout.
>

The 8.2 and earlier series accepted calls to setQueryTimeout, but then
ignored the value, so there wasn't any timeout in effect.  Starting with
8.3, we throw an error to indicate to the user that the call doesn't work.

Kris Jurka