Andrea,
thanks for the response.
the problem was the same with diferrents versions of Postgres (8.3, 9.0 and
9.1) on local or remote host.
As you indicated, I enabled connection validation:
params.put(PostgisNGDataStoreFactory.VALIDATECONN.key,"true");
Now, it works (magic?) fine except the same warnings :
27/Fev/2012 16:34:45 org.geotools.jdbc.JDBCFeatureReader finalize
WARNING: There is code leaving feature readers/iterators open, this is
leaking statements and connections!
27/Fev/2012 16:34:45 org.geotools.jdbc.JDBCFeatureReader finalize
WARNING: There is code leaving feature readers/iterators open, this is
leaking statements and connections!
I am a little bit afraid with theres warnings using gt 8.0. :(
Any tip ?
Thanks again.
On Sat, Feb 25, 2012 at 5:15 PM, Andrea Aime
<[email protected]>wrote:
> On Sat, Feb 25, 2012 at 1:19 PM, Leoze Oze <[email protected]> wrote:
>
>> Hello list,
>> I have no problem using directly a FeatureSource (comments) but
>> with FeatureCollection. See erro at the end.....
>> Thanks a lot for any ideia !
>>
>
> PostgreSQL is shutting the connection in your face, maybe due to network
> issues, maybe due to
> timeouts.
> Enable connection validation when setting up the store "params" (the param
> key shoudl be in
> the base class of PostgisNGDataStoreFactory) to have the connection pool
> check if a connection
> is still alive before returning it to GeoTools.
>
> Cheers
> Andrea
>
>
> --
> -------------------------------------------------------
> Ing. Andrea Aime
> GeoSolutions S.A.S.
> Tech lead
>
> Via Poggio alle Viti 1187
> 55054 Massarosa (LU)
> Italy
>
> phone: +39 0584 962313
> fax: +39 0584 962313
> mob: +39 339 8844549
>
> http://www.geo-solutions.it
> http://geo-solutions.blogspot.com/
> http://www.youtube.com/user/GeoSolutionsIT
> http://www.linkedin.com/in/andreaaime
> http://twitter.com/geowolf
>
> -------------------------------------------------------
>
------------------------------------------------------------------------------
Try before you buy = See our experts in action!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-dev2
_______________________________________________
GeoTools-GT2-Users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
