I use Geotools mostly for its CRS and geometry libraries, so I haven't been
exposed to feature stores, but it seems to me that a transaction should refer
to exactly one operation. For that matter, I'm not sure why closing the
transaction should close the underlying connection/connection pool. It works,
and if it's not broke why fix it, but I suppose I'm a little confused with
regards to why the behavior is what it is.
Best Regards
-Duane
From: Fred Lehodey [mailto:[email protected]]
Sent: Saturday, August 28, 2010 6:51 AM
To: geotools geotools-gt2-us...@lists. sourceforge. net
Subject: Re: [Geotools-gt2-users] FeatureStore and Transaction Problem
Sure ! :(
Thanks Jody...
On Sat, Aug 28, 2010 at 11:38 AM, Jody Garnett
<[email protected]<mailto:[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]<mailto:[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
