Subject: Re: Re: [SQL] JDBC Statement.setQueryTimeout : is there plan to
	implement this?
Mime-Version: 1.0 (Apple Message framework v1251.1)
Content-Type: text/plain; charset=utf-8
From: Steven Schlansker <stevenschlansker@gmail.com>
In-Reply-To: 
 <CADK3HHJmo4ayR=RKBeomggu48=tbGYV7HdX7FVP_QOoFt=du+Q@mail.gmail.com>
Date: Thu, 15 Dec 2011 09:38:48 -0800
Cc: Craig Ringer <ringerc@ringerc.id.au>,
	=?utf-8?Q?Rados=C5=82aw_Smogura?= <rsmogura@softperience.eu>,
	David Fetter <david@fetter.org>, Sylvain Mougenot <smougenot@sqli.com>,
	pgsql-jdbc@postgresql.org
Content-Transfer-Encoding: quoted-printable
Message-Id: <0A239648-B5D6-4E58-B67B-8257AD2AA516@gmail.com>
References: 
 <CACKdPFjK_UsZ5wExD-RvBbvi6Zo-VYtoxQsCUpWXzTN9kywj7w@mail.gmail.com>
	<4EE8AC41.2040505@ringerc.id.au>
	<20111214161349.GA31176@fetter.org>
	<4EE968FF.5010604@ringerc.id.au> <4EE97B85.50909@ringerc.id.au>
	<c138137e3524335c64e646b0e88e7dbc@mail.softperience.eu>
	<4EE9FE03.7070107@ringerc.id.au>
	<CADK3HHJmo4ayR=RKBeomggu48=tbGYV7HdX7FVP_QOoFt=du+Q@mail.gmail.com>
To: Dave Cramer <pg@fastcrypt.com>

java.util.concurrent introduces ScheduledExecutorService, which fixes a =
lot of the problems with java.util.Timer and introduces more features.

Specifically, it enqueues timed actions and executes them on a thread =
pool, providing good controls both for controlling individual tasks =
(canceling) and the entire pool (shutting down cleanly / immediately)

It might be a good fit for implementing timeouts.

On Dec 15, 2011, at 6:17 AM, Dave Cramer wrote:

> Craig,
>=20
> That is the current implementation. What do you suggest as a more
> robust implementation ?
>=20
> Dave Cramer
>=20
> dave.cramer(at)credativ(dot)ca
> http://www.credativ.ca
>=20
>=20
>=20
> On Thu, Dec 15, 2011 at 9:02 AM, Craig Ringer <ringerc@ringerc.id.au> =
wrote:
>> On 12/15/2011 07:29 PM, Rados=C5=82aw Smogura wrote:
>>>=20
>>> Long, long time ago I've sent implementation with timers, you need =
to
>>> search archive If you need this.
>>=20
>>=20
>> If it was ages ago, you probably used java.util.Timer, right?
>>=20
>> java.util.Timer is not suitable for use in a JDBC driver because it =
doesn't
>> do any exception handling on the timer thread, it's subject to =
congestion on
>> the timer thread, and it offers no way for the driver to control the =
timer
>> thread to cleanly shut it down during unload. It's unusable in app =
servers
>> and not really a great idea anywhere that needs to be robust and
>> long-running.
>>=20
>> --
>> Craig Ringer
>>=20
>>=20
>> --
>> Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-jdbc
>=20
> --=20
> Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-jdbc