SELECT statement_timeout(integer) in lieu of setQueryTimeout at the statement level

Поиск
Список
Период
Сортировка
От Johnny Luong
Тема SELECT statement_timeout(integer) in lieu of setQueryTimeout at the statement level
Дата
Msg-id 4DE92AB2.90507@trustcommerce.com
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Michal Politowski
Дата:
Сообщение: Re: [GENERAL] Mixed up protocol packets in server response?
Следующее
От: Steven Schlansker
Дата:
Сообщение: Accepting Object[] as an acceptable input to setObject with Types.ARRAY?