Re: a problem about setQueryTimeout is not fixed?

From: Tomonari Katsumata <katsumata(dot)tomonari(at)po(dot)ntts(dot)co(dot)jp>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: a problem about setQueryTimeout is not fixed?
Date: 2013-07-16 08:57:10
Message-ID: 51E50AE6.9080701@po.ntts.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi Dave,

I've tested the new driver(postgresql-9.2-1004.jdbc4.jar).
It worked fine.

My test scenario:
step0. preparing tomcat connection pool environment.
step1. connect to PostgreSQL with pooled connection.
step2. executing setQueryTimeout(5).
step3. executing dummy query(access to non exist table) and get
SQLException.
step4. cotinueously, executing "SELECT pg_sleep(10)".

the result:
- old driver
getting SQLException during step4.
because of timer expired from step2.

- new driver
query of step4 complete without any error.

I'm happy to the new driver be released soon,
but I'm concerning about a quick release make
many users chaos.

Now, you are working for website renewal, rigth?
So, I think it's better to release new driver on
renewal websit.
What do you think of it ?

regards,
--------
NTT Software Corporation
Tomonari Katsumata

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2013-07-16 12:25:21 Re: a problem about setQueryTimeout is not fixed?
Previous Message Tom Dunstan 2013-07-16 00:05:53 Re: Website Redo Kick Off