RE: postgres jdbc driver

2013-03-06 Thread Michael Gargano
tgres jdbc driver 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

RE: postgres jdbc driver

2013-03-06 Thread Michael Gargano
The statement is closing at random times and it eventually ends up hanging eof and locking the instance. It looks like others have found an issue with the postgres jdbc driver doing this under heavy load, it's all in the statement pooling (some kind of race condition). I've been

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

postgres jdbc driver

2013-03-06 Thread Michael Gargano
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 the jdbc drivers too frequently. What version of driver are you on?