Sure ! :(
Thanks Jody...
On Sat, Aug 28, 2010 at 11:38 AM, Jody Garnett <[email protected]>wrote:
> You close your transaction :-) I think that was being used to read as well
> ...
>
> You can create a second feature source if you like; and use transaction
> AUTO_COMMIT; be in general it is nice to have a transaction and reuse it.
> Jody
>
> On 28/08/2010, at 8:08 PM, Fred Lehodey wrote:
>
> > Hi,
> > (certainly newbie and probably stupid problem....)
> >
> > When trying something like (gt2.6 + postgis):
> >
> > myFStore.setTransaction(t);
> > try {
> > myFStore.removeFeatures(filter);
> > t.commit();
> > t.close();
> > } catch (IOException ex) {
> > ex.printStackTrace();
> > }
> >
> > Works, and features are deleted in DB.
> > But next, I have this error (trying to zoom on mappane for example):
> >
> > 28/Ago/2010 11:03:11 org.geotools.jdbc.JDBCDataStore closeSafe
> > WARNING: Error occurred closing connection
> > 28/Ago/2010 11:03:11 org.geotools.renderer.lite.StreamingRenderer paint
> > SEVERE: java.io.IOException
> > java.lang.RuntimeException: java.io.IOException
> > at
> org.geotools.data.store.ContentFeatureCollection.iterator(ContentFeatureCollection.java:266)
> > at
> org.geotools.renderer.lite.StreamingRenderer.drawOptimized(StreamingRenderer.java:1859)
> > at
> org.geotools.renderer.lite.StreamingRenderer.processStylers(StreamingRenderer.java:1792)
> > at
> org.geotools.renderer.lite.StreamingRenderer.paint(StreamingRenderer.java:699)
> > at
> org.geotools.swing.RenderingExecutor$Task.call(RenderingExecutor.java:148)
> > at
> org.geotools.swing.RenderingExecutor$Task.call(RenderingExecutor.java:104)
> > at
> java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
> > at java.util.concurrent.FutureTask.run(FutureTask.java:138)
> > at
> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885)
> > at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)
> > at java.lang.Thread.run(Thread.java:619)
> > Caused by: java.io.IOException
> > at
> org.geotools.jdbc.JDBCFeatureSource.getReaderInternal(JDBCFeatureSource.java:568)
> > at
> org.geotools.jdbc.JDBCFeatureStore.getReaderInternal(JDBCFeatureStore.java:209)
> > at
> org.geotools.data.store.ContentFeatureSource.getReader(ContentFeatureSource.java:481)
> > at
> org.geotools.data.store.ContentFeatureCollection.iterator(ContentFeatureCollection.java:263)
> > ... 10 more
> > Caused by: java.sql.SQLException: Connection is closed.
> > at
> org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.checkOpen(PoolingDataSource.java:175)
> > at
> org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.createStatement(PoolingDataSource.java:209)
> > at
> org.geotools.jdbc.JDBCFeatureReader.<init>(JDBCFeatureReader.java:143)
> > at
> org.geotools.jdbc.JDBCFeatureSource.getReaderInternal(JDBCFeatureSource.java:562)
> > ... 13 more
> >
> > Thanks for any help..
> > Fred.
> >
> >
> >
> ------------------------------------------------------------------------------
> > Sell apps to millions through the Intel(R) Atom(Tm) Developer Program
> > Be part of this innovative community and reach millions of netbook users
> > worldwide. Take advantage of special opportunities to increase revenue
> and
> > speed time-to-market. Join now, and jumpstart your future.
> >
> http://p.sf.net/sfu/intel-atom-d2d_______________________________________________
> > Geotools-gt2-users mailing list
> > [email protected]
> > https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
>
>
------------------------------------------------------------------------------
Sell apps to millions through the Intel(R) Atom(Tm) Developer Program
Be part of this innovative community and reach millions of netbook users
worldwide. Take advantage of special opportunities to increase revenue and
speed time-to-market. Join now, and jumpstart your future.
http://p.sf.net/sfu/intel-atom-d2d
_______________________________________________
Geotools-gt2-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
