SELECT statement_timeout(integer) in lieu of setQueryTimeout at the statement level - Mailing list pgsql-jdbc

From Johnny Luong
Subject SELECT statement_timeout(integer) in lieu of setQueryTimeout at the statement level
Date
Msg-id 4DE92AB2.90507@trustcommerce.com
Whole thread Raw
List pgsql-jdbc
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256

Hi All,

I'm trying to set an upper bound on the time a particular
PreparedStatement (via executeQuery, executeBatch) and it looks like
setQueryTimeout is not actually implemented.  Assuming potential network
failures/delay occur infrequently between the JDBC app and the Postgres
server, would doing a SELECT statement_timeout() at the start of the
connection simulate the behavior of setQueryTimeout in the other cases?

Best,
Johnny
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/

iQIcBAEBCAAGBQJN6SqyAAoJENQfv1FjsMMvjcUQAL769f0fBN0e4QpqCHplNmhj
bVXJxyiOtAEHaDsBAkXX2odPOKbEiC9RljGqAeJqHj7b10zbY+OZ/ZkOxl7eiPsR
IziC/tcS2bsc79jRLjJQqaBFL0qtFfRXBbgQo+9suRTvggb7fCHz8ThXE0U159ot
R96c0HwjCSZaaqfU8tspkNWabVV5/lxqL8JskBQ6w6onrhcTx+gMdZ8gNZTVYLye
vDYEpJgE4dOcmNmoA77nIZ/nkaeuOj/TRArovPvvOetAL+ynx1/gRbC2vjsYUuNk
JUkXJ5bD7TdoWKOeyDOkVtjXhLBaePD3EVUKYwfmovzKWng3wIR+H3gERtRxnlvb
7ZGt+bwLMJ4HzU8aRePKY4nhzrQGCxG9lH0O1fj3oF3pZ1iiJO6U7yJvy1z87hgk
10EmjmOs5usMtRy1BS7fsNO8hz6KPSwiif4NLw0ZeL5kA0YcN8nwQygZFJfywcIK
9bAZbblYTYOn9WydLbyTPX97FD3fBAeRKp8otiD63HSAV0ASfYB6nuo9VVQe7WkX
db1+iNARX03DO2pxLoA/IhfdRJX860b3pziBAo+rX+bi1JNMY9HUlsmuLwTNMZJS
OoaZnx5WEHtxCbJ971Z4X3RC9My6UMiGB3KEAb5XmWgvvDdVGKPE3NxGVhnP64CW
LhRW3q9tREpBAzn98Kbp
=QClW
-----END PGP SIGNATURE-----

pgsql-jdbc by date:

Previous
From: Michal Politowski
Date:
Subject: Re: [GENERAL] Mixed up protocol packets in server response?
Next
From: Steven Schlansker
Date:
Subject: Accepting Object[] as an acceptable input to setObject with Types.ARRAY?