Re: [Geotools-devel] PostGIS not releasing connections on OutOfMemory

2006-05-01 Thread David Blasby
FYI - this have been patched in the latest Postgresql drivers. I worked around this problem so we dont need to upgrade right away. Maybe upgrade the PostgreSQL JDBC driver next time there's an offical postgresql JDBC release? [EMAIL PROTECTED] wrote: I've applied a patch for this to 8.0,

Re: [Geotools-devel] PostGIS not releasing connections on OutOfMemory

2006-03-29 Thread Jody Garnett
David Blasby wrote: Okay, I've found a pretty nasty bug in the PostGIS driver. My dataset is a table with about 250 rows in it. Each row has the VMAP0 dataset polygon of a country in. Each row is large. If you look closely at the JDBC datastore, you'll notice that it will fetch 200 rows at

Re: [Geotools-devel] PostGIS not releasing connections on OutOfMemory

2006-03-24 Thread Chris Holmes
David Blasby wrote: Okay, I've found a pretty nasty bug in the PostGIS driver. My dataset is a table with about 250 rows in it. Each row has the VMAP0 dataset polygon of a country in. Each row is large. If you look closely at the JDBC datastore, you'll notice that it will fetch 200 rows

Re: [Geoserver-devel] Re: [Geotools-devel] PostGIS not releasing connections on OutOfMemory

2006-03-24 Thread David Blasby
Most of the connection pooling is actually done by the Postgresql JDBC driver, but there's a proxy object on top of it thats hard to look inside. I talked to the Postgresql JDBC mailing list and they said oops - it should reset the stream so its in a consistent state. Dont know when this

[Geotools-devel] PostGIS not releasing connections on OutOfMemory

2006-03-23 Thread David Blasby
Okay, I've found a pretty nasty bug in the PostGIS driver. My dataset is a table with about 250 rows in it. Each row has the VMAP0 dataset polygon of a country in. Each row is large. If you look closely at the JDBC datastore, you'll notice that it will fetch 200 rows at a time - which means