Thread: a problem about setQueryTimeout is not fixed?
Hi, It seems new PostgreSQL JDBC Driver(9.2-1003) is released. But I can not find waht change has been done to new driver, because no Changelog about new driver is download site. http://jdbc.postgresql.org/changes.html I've been looking forward to being fixed an issue about setQueryTimeout(*), but the fix was not applied against new driver. (*)The problem is discussed on a ML. http://www.postgresql.org/message-id/283FE4ADE0E66642A4301967EDD7BAEE338464@YUL01WMXB02.rp.corp The fix is applied against master source. Do you have any plan to apply the fix aggainst 9.2driver? P.S. and one more comment. "Supported Versions" on download site has old information. http://jdbc.postgresql.org/download.html Please fix it too! regards, -------------- NTT Software Corporation Tomonari Katsumata
Tomonari,
There really were no changes to the driver. 1002 was mistakenly created using java 1.7 and pushed to maven central. As such it was not useable by java 1.6 1003 is really just a recompile with 1.6
Thanks for reminding me about the timer fix. I will see if a patch will just apply to 9.2
On Wed, Jul 10, 2013 at 2:41 AM, Tomonari Katsumata <katsumata.tomonari@po.ntts.co.jp> wrote:
Hi,
It seems new PostgreSQL JDBC Driver(9.2-1003) is released.
But I can not find waht change has been done to new driver,
because no Changelog about new driver is download site.
http://jdbc.postgresql.org/changes.html
I've been looking forward to being fixed an issue about
setQueryTimeout(*), but the fix was not applied against new driver.
(*)The problem is discussed on a ML.
http://www.postgresql.org/message-id/283FE4ADE0E66642A4301967EDD7BAEE338464@YUL01WMXB02.rp.corp
The fix is applied against master source.
Do you have any plan to apply the fix aggainst 9.2driver?
P.S.
and one more comment.
"Supported Versions" on download site has old information.
http://jdbc.postgresql.org/download.html
Please fix it too!
regards,
--------------
NTT Software Corporation
Tomonari Katsumata
--
Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc
Tomonari,
I patched the code and have created a jar postgresql-9.2-1004.jdbc4.jar you can download it at http://jdbc.postgresql.org/download/postgresql-9.2-1004.jdbc4.jar
Can you test this please ?
On Wed, Jul 10, 2013 at 6:43 AM, Dave Cramer <pg@fastcrypt.com> wrote:
Tomonari,There really were no changes to the driver. 1002 was mistakenly created using java 1.7 and pushed to maven central. As such it was not useable by java 1.6 1003 is really just a recompile with 1.6Thanks for reminding me about the timer fix. I will see if a patch will just apply to 9.2On Wed, Jul 10, 2013 at 2:41 AM, Tomonari Katsumata <katsumata.tomonari@po.ntts.co.jp> wrote:Hi,
It seems new PostgreSQL JDBC Driver(9.2-1003) is released.
But I can not find waht change has been done to new driver,
because no Changelog about new driver is download site.
http://jdbc.postgresql.org/changes.html
I've been looking forward to being fixed an issue about
setQueryTimeout(*), but the fix was not applied against new driver.
(*)The problem is discussed on a ML.
http://www.postgresql.org/message-id/283FE4ADE0E66642A4301967EDD7BAEE338464@YUL01WMXB02.rp.corp
The fix is applied against master source.
Do you have any plan to apply the fix aggainst 9.2driver?
P.S.
and one more comment.
"Supported Versions" on download site has old information.
http://jdbc.postgresql.org/download.html
Please fix it too!
regards,
--------------
NTT Software Corporation
Tomonari Katsumata
--
Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc
Hi Dave,
Thanks for updating it.
I'll test it next week.
I'm sorry but please wait for the result.
regards,
------------
Tomonari Katsumata
2013/07/11 20:25 "Dave Cramer" <pg@fastcrypt.com>:
Tomonari,I patched the code and have created a jar postgresql-9.2-1004.jdbc4.jar you can download it at http://jdbc.postgresql.org/download/postgresql-9.2-1004.jdbc4.jarCan you test this please ?On Wed, Jul 10, 2013 at 6:43 AM, Dave Cramer <pg@fastcrypt.com> wrote:Tomonari,There really were no changes to the driver. 1002 was mistakenly created using java 1.7 and pushed to maven central. As such it was not useable by java 1.6 1003 is really just a recompile with 1.6Thanks for reminding me about the timer fix. I will see if a patch will just apply to 9.2On Wed, Jul 10, 2013 at 2:41 AM, Tomonari Katsumata <katsumata.tomonari@po.ntts.co.jp> wrote:Hi,
It seems new PostgreSQL JDBC Driver(9.2-1003) is released.
But I can not find waht change has been done to new driver,
because no Changelog about new driver is download site.
http://jdbc.postgresql.org/changes.html
I've been looking forward to being fixed an issue about
setQueryTimeout(*), but the fix was not applied against new driver.
(*)The problem is discussed on a ML.
http://www.postgresql.org/message-id/283FE4ADE0E66642A4301967EDD7BAEE338464@YUL01WMXB02.rp.corp
The fix is applied against master source.
Do you have any plan to apply the fix aggainst 9.2driver?
P.S.
and one more comment.
"Supported Versions" on download site has old information.
http://jdbc.postgresql.org/download.html
Please fix it too!
regards,
--------------
NTT Software Corporation
Tomonari Katsumata
--
Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/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
Tomonari,
I don't have a problem putting this up on the site as the latest driver.
On Tue, Jul 16, 2013 at 4:57 AM, Tomonari Katsumata <katsumata.tomonari@po.ntts.co.jp> wrote:
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
--
Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc
Hi Dave, > I don't have a problem putting this up on the site as the latest driver. > OK, I wish you put it up soon. And... please don't forget to put ChangeLog up too ;-) Thanks a lot ! regards, -------------- NTT Software Corporation Tomonari Katsumata (2013/07/16 21:25), Dave Cramer wrote: > Tomonari, > > I don't have a problem putting this up on the site as the latest driver. > > Dave Cramer > > dave.cramer(at)credativ(dot)ca > http://www.credativ.ca > > > On Tue, Jul 16, 2013 at 4:57 AM, Tomonari Katsumata < > katsumata.tomonari@po.ntts.co.jp> wrote: > >> 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 >> >> >> >> >> -- >> Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org) >> To make changes to your subscription: >> http://www.postgresql.org/**mailpref/pgsql-jdbc<http://www.postgresql.org/mailpref/pgsql-jdbc> >> >