RE: postgres jdbc driver

2013-03-06 Thread Michael Gargano
We're have the postgres logging on for long running queries... nothing takes more than a few seconds. -Mike From: Karl Gretton [mailto:kgret...@mac.com] Sent: Wednesday, March 06, 2013 12:06 PM To: Michael Gargano Cc: WebObjects-Dev List (webobjects-dev@lists.apple.com) Subject: Re: pos

RE: postgres jdbc driver

2013-03-06 Thread Michael Gargano
trying to debug this for months. I'm on pg 9.0. -Mike From: Ramsey Gurley [mailto:rgur...@smarthealth.com] Sent: Wednesday, March 06, 2013 11:59 AM To: Michael Gargano Cc: WebObjects-Dev List (webobjects-dev@lists.apple.com) Subject: Re: postgres jdbc driver Out of curiosity, what sort of

Re: postgres jdbc driver

2013-03-06 Thread Kevin Hinkson
On 6 Mar 2013, at 11:46, webobjects-dev-requ...@lists.apple.com wrote: > > Hi all, > >Just taking a quick survey of folks using postgres. I think > we've found an issue with the jdbc driver (any version within the last year > or so). >Since people don't update

Re: postgres jdbc driver

2013-03-06 Thread Karl Gretton
Michael, Did my suggestion about the statement_timeout help at all? If you have queries that run for a long time, the statement will time out and Postgres will close the connection. There are both statement and connection timeout parameters in the PG conf file. Karl On 6 Mar 2013, at 08:37,

Re: postgres jdbc driver

2013-03-06 Thread Ramsey Gurley
Out of curiosity, what sort of issues are you seeing? We use postgresql here, but it's old. (8.3.x) Ramsey On Mar 6, 2013, at 9:37 AM, Michael Gargano wrote: > Hi all, > > Just taking a quick survey of folks using postgres. I think > we’ve found an issue with the jdbc driver