From: | valgog <valgog(at)gmail(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #4123: Statement.setQueryTimeout does not work with Postgres Java Driver |
Date: | 2008-04-23 10:59:03 |
Message-ID: | ade05daf-5348-47b6-8633-ac58b055692c@s50g2000hsb.googlegroups.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On Apr 22, 5:53 pm, bo(dot)(dot)(dot)(at)ejurka(dot)com (Kris Jurka) wrote:
> On Tue, 22 Apr 2008, Amit Mujawar wrote:
>
> > The following bug has been logged online:
>
> > Bug reference: 4123
> > PostgreSQL version: 8.1
> > Description: Statement.setQueryTimeout does not work with Postgres
> > Java Driver
> > Details:
>
> > I am using PostgreSQL through JDBC
> > PostgreSQL – 8.1, Driver - org.postgresql.Driver 8.1-408.jdbc3
>
> > I suspect there is a problem with JDBC driver implementation for
> > setQueryTimeout API.
>
> setQueryTimeout is not implemented at all. Newer drivers (8.3+) will
> throw an exception telling you that if you try to call setQueryTimeout
> while older drivers silently accept the value and do nothing.
>
> Kris Jurka
>
> --
> Sent via pgsql-bugs mailing list (pgsql-b(dot)(dot)(dot)(at)postgresql(dot)org)
> To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-bugs- Hide quoted text -
>
> - Show quoted text -
Hi Kris,
wanted to ask you that all the time, but never had found time to do
that.
Is it possible to implement the setStatementTimeout() as somethig
like:
s = c.prepareStatement("SELECT set_config('statement_timeout',
<neededTimeoutInMilliseconds>, false);" );
s.executeQuery();
c.commit();
With best regards,
-- Valentine Gogichashvili
From | Date | Subject | |
---|---|---|---|
Next Message | Gregory Stark | 2008-04-23 11:56:35 | Re: BUG #4124: Error message: "You local administrators group contains 'Service users' this is a common configurat |
Previous Message | valgog | 2008-04-23 10:52:11 | Re: BUG #4123: Statement.setQueryTimeout does not work with Postgres Java Driver |