From: | David Fetter <david(at)fetter(dot)org> |
---|---|
To: | Radosław Smogura <rsmogura(at)softperience(dot)eu> |
Cc: | Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, PG Hackers <pgsql-hackers(at)postgresql(dot)org>, PostgreSQL JDBC List <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: [JDBC] Support for JDBC setQueryTimeout, et al. |
Date: | 2010-10-12 14:14:39 |
Message-ID: | 20101012141439.GA29627@fetter.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-jdbc |
On Tue, Oct 12, 2010 at 04:04:56AM -0500, Radosław Smogura wrote:
> On Mon, 11 Oct 2010 08:29:16 -0500, "Kevin Grittner"
> <Kevin(dot)Grittner(at)wicourts(dot)gov> wrote:
> > David Fetter <david(at)fetter(dot)org> wrote:
> >
> >> Please find enclosed a WIP patch from one of my co-workers
> >> intended to support JDBC's setQueryTimeout, along with the patch
> >> for JDBC that uses it.
> >
> > I agree that it would be very nice to support this JDBC feature, but
> > I'm not clear on why this can't be done with just JDBC changes using
> > the java.util.Timer class and the existing Statement.cancel()
> > method. Can you explain why the backend needed to be touched?
> >
> > -Kevin
>
> I sent such patch fully in Java
> (http://archives.postgresql.org/pgsql-jdbc/2009-11/msg00010.php)
> implementing cancellation with Timer and "cancel query" facility of
> PSQL server,
Would you like to update it?
Is there something incomplete about the ones I sent, and if so, what?
> unfortunately none has revised it, even that setQuertyTimeout todo
> is for long time on dashboard, and it's important for enterprise
> class software.
That sounds a tad buzzword-y. What exactly is it that *you* see as
important to delivering this feature? I'm thinking JDBC1 compliance,
but you might have something very different in mind.
Cheers,
David.
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
From | Date | Subject | |
---|---|---|---|
Next Message | Joe Uhl | 2010-10-12 14:19:57 | Re: Slow count(*) again... |
Previous Message | Robert Haas | 2010-10-12 14:09:09 | Re: security hook on table creation |
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Grittner | 2010-10-12 15:37:00 | Re: [JDBC] Support for JDBC setQueryTimeout, et al. |
Previous Message | Radosław Smogura | 2010-10-12 09:04:56 | Re: [JDBC] Support for JDBC setQueryTimeout, et al. |