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
