Re: JDBC4 and setting statement_timeout: responds "is not yet implemented" => FIXED

Dear Robert
The server is external and I'm not in able to upgrade the
PostgreSQL-server. Because of the age I was afraid for choosing a "new"
jdbc-driver. But I followed your suggestion to replace the jdbc4-driver
with last edition and it worked nice with the new driver
postgresql-42.2.1.jar.
Thanks a lot, Robert.

Have a nice day.

Regards
-Gunnar;)

2018-03-06 0:36 GMT+01:00 rob stone <floriparob(at)gmail(dot)com>:

> Hi Gunnar,
>
> On Mon, 2018-03-05 at 12:27 +0100, Gunnar Halvorsen wrote:
> > Dear Sirs,
> > As quite new in this discussiongroup I have red a lot about
> > statement_timeout, but I can't find any answer on the following
> > problem:
> >
> > My JavaEE-code responds the fpllowing Error message:
> >
> > Method
> > org.postgresql.jdbc4.Jdbc4PreparedStatement.setQueryTimeout(int) is
> > not yet implemented
> >
> > Javacode:
> > PreparedStatement AA = null;
> > ..
> > ..
> > AA.setQueryTimeout( 5000 ); // This sentence generates the fault-
> > message
> >
> >
> > PostgreSQL version: 9.1.24
> > ( Only READ-access )
> >
> > JDBC4 version: postgresql-9.0-801.jdbc4.jar
> >
> >
> > My application reads contiously a SELECT-sentence every 10 seconds,
> > and needs to be aborted if it not returns in during of 5 seconds.
> >
> > Is the functiion setQueryTimeout(INT) not yet implemented in JDBC4,
> > or is it the PostgreSQK-server which is not yet implemented?
> >
> > How shall I implement statement_timeout in my JavaEE code, when I
> > only has Read-access to PostgreSQL, to avoid this ErrorMessage?
> >
> > Regards
> > -Gunnar
> >
> >
> >
> >
> >
>
>
> There was a fix to this in Version 9.4-1205 of the driver.
> Also, your version of PostgreSql is ancient.
>
> I think an upgrade would be worthwhile.
>
> HTH,
> Robert
>