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@xxxxxxxxx>:
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
