Re: Re: [SQL] JDBC Statement.setQueryTimeout : is there plan to implement this?

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>
Cc: Radosław Smogura <rsmogura(at)softperience(dot)eu>, David Fetter <david(at)fetter(dot)org>, Sylvain Mougenot <smougenot(at)sqli(dot)com>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Re: [SQL] JDBC Statement.setQueryTimeout : is there plan to implement this?
Date: 2011-12-15 14:17:35
Message-ID: CADK3HHJmo4ayR=RKBeomggu48=tbGYV7HdX7FVP_QOoFt=du+Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc pgsql-sql

Craig,

That is the current implementation. What do you suggest as a more
robust implementation ?

Dave Cramer

dave.cramer(at)credativ(dot)ca
http://www.credativ.ca

On Thu, Dec 15, 2011 at 9:02 AM, Craig Ringer <ringerc(at)ringerc(dot)id(dot)au> wrote:
> On 12/15/2011 07:29 PM, Radosław Smogura wrote:
>>
>> Long, long time ago I've sent implementation with timers, you need to
>> search archive If you need this.
>
>
> If it was ages ago, you probably used java.util.Timer, right?
>
> 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.
>
> --
> Craig Ringer
>
>
> --
> Sent via pgsql-jdbc mailing list (pgsql-jdbc(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-jdbc

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message the6campbells 2011-12-15 16:02:13 Re: getTables not returning 10 columns etc
Previous Message Craig Ringer 2011-12-15 14:02:43 Re: Re: [SQL] JDBC Statement.setQueryTimeout : is there plan to implement this?

Browse pgsql-sql by date

  From Date Subject
Next Message Steven Schlansker 2011-12-15 17:38:48 Re: Re: [SQL] JDBC Statement.setQueryTimeout : is there plan to implement this?
Previous Message Craig Ringer 2011-12-15 14:02:43 Re: Re: [SQL] JDBC Statement.setQueryTimeout : is there plan to implement this?