Thanks again Andrea,
Now, I have this stack trace from jdbc reader. (see above).
Note: with a query, I have 2 times the same error. This is the same for
different tables and different postgres version.
I´m not a java guru, but if I can help for something, please tell me.... I
will try.
Regards,
28/Fev/2012 11:50:18 org.geotools.jdbc.JDBCFeatureReader finalize
WARNING: There is code leaving feature readers/iterators open, this is
leaking statements and connections!
28/Fev/2012 11:50:18 org.geotools.jdbc.JDBCFeatureReader finalize
WARNING: The unclosed reader originated on this stack trace
java.lang.Exception
at
org.geotools.jdbc.JDBCFeatureReader.init(JDBCFeatureReader.java:169)
at
org.geotools.jdbc.JDBCFeatureReader.<init>(JDBCFeatureReader.java:132)
at
org.geotools.jdbc.JDBCFeatureSource.getReaderInternal(JDBCFeatureSource.java:580)
at
org.geotools.jdbc.JDBCFeatureStore.getReaderInternal(JDBCFeatureStore.java:220)
at
org.geotools.data.store.ContentFeatureSource.getReader(ContentFeatureSource.java:562)
at
org.geotools.data.store.ContentFeatureCollection.features(ContentFeatureCollection.java:221)
at
org.geotools.data.store.ContentFeatureCollection.features(ContentFeatureCollection.java:64)
at
org.geotools.data.collection.CollectionDataStore.getBoundsInternal(CollectionDataStore.java:152)
at
org.geotools.data.collection.CollectionDataStore.getBounds(CollectionDataStore.java:145)
at
org.geotools.data.AbstractFeatureSource.getBounds(AbstractFeatureSource.java:318)
at
org.geotools.data.AbstractFeatureSource.getBounds(AbstractFeatureSource.java:286)
at org.geotools.map.FeatureLayer.getBounds(FeatureLayer.java:195)
at org.geotools.map.MapContent.getMaxBounds(MapContent.java:600)
at
org.geotools.swing.AbstractMapPane.setFullExtent(AbstractMapPane.java:939)
at
org.geotools.swing.AbstractMapPane.doSetMapContent(AbstractMapPane.java:559)
at
org.geotools.swing.AbstractMapPane.<init>(AbstractMapPane.java:205)
at org.geotools.swing.JMapPane.<init>(JMapPane.java:77)
at org.geotools.swing.JMapPane.<init>(JMapPane.java:66)
at org.geotools.swing.JMapFrame.<init>(JMapFrame.java:196)
at org.geotools.swing.JMapFrame.doShowMap(JMapFrame.java:165)
at org.geotools.swing.JMapFrame.access$000(JMapFrame.java:74)
at org.geotools.swing.JMapFrame$1.run(JMapFrame.java:158)
at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:597)
at
java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:273)
at
java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183)
at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:173)
at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:168)
at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:160)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:121)
On Mon, Feb 27, 2012 at 7:57 PM, Andrea Aime
<[email protected]>wrote:
> On Mon, Feb 27, 2012 at 5:46 PM, Leoze Oze <[email protected]> wrote:
> > 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 ?
>
> Something is using jdbc readers but not closing them... run
> your application with this system property set:
> -Dgt2.jdbc.trace=true
> (or System.setProperty("gt2.jdbc.trace", "true" in your code)
>
> and JDBCFeatureReader should log the stack trace that gathered
> the reader without closing it.
>
> 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
>
> -------------------------------------------------------
>
------------------------------------------------------------------------------
Keep Your Developer Skills Current with LearnDevNow!
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-d2d
_______________________________________________
GeoTools-GT2-Users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
