Thanks Michael for your reply!
I think the problem is happening at postGIS side since when I try to load in
the feature layer (just as creating other feature layers,
JMapContent.addlayer(FeatureLayer) to the JMapFrame or JMapPane, there is an
error showing:
Mar 14, 2012 10:53:35 AM org.geotools.data.postgis.PostGISDialect
getOptimizedBounds
WARNING: Failed to use ST_Estimated_Extent, falling back on envelope
aggregation
org.postgresql.util.PSQLException: ERROR: LWGEOM_estimated_extent: couldn't
locate table within current schema
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:353)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:252)
at
org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at
org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at
org.geotools.data.postgis.PostGISDialect.getOptimizedBounds(PostGISDialect.java:248)
at
org.geotools.jdbc.JDBCDataStore.getBounds(JDBCDataStore.java:1123)
at
org.geotools.jdbc.JDBCFeatureSource.getBoundsInternal(JDBCFeatureSource.java:501)
at
org.geotools.jdbc.JDBCFeatureStore.getBoundsInternal(JDBCFeatureStore.java:189)
at
org.geotools.data.store.ContentFeatureSource.getBounds(ContentFeatureSource.java:426)
at
org.geotools.data.store.ContentFeatureSource.getBounds(ContentFeatureSource.java:363)
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.showMap(JMapFrame.java:152)
at
org.geotools.tutorial.test.query2.PostGISDisplay(query2.java:624)
at
org.geotools.tutorial.test.query2.access$2000(query2.java:148)
at
org.geotools.tutorial.test.query2$24.action(query2.java:529)
at
org.geotools.swing.action.SafeAction.actionPerformed(SafeAction.java:50)
at
javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2018)
at
javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2341)
at
javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
at
javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
at
javax.swing.AbstractButton.doClick(AbstractButton.java:376)
at
javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:833)
at
javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:877)
at java.awt.Component.processMouseEvent(Component.java:6505)
at
javax.swing.JComponent.processMouseEvent(JComponent.java:3321)
at java.awt.Component.processEvent(Component.java:6270)
at java.awt.Container.processEvent(Container.java:2229)
at java.awt.Component.dispatchEventImpl(Component.java:4861)
at java.awt.Container.dispatchEventImpl(Container.java:2287)
at java.awt.Component.dispatchEvent(Component.java:4687)
at
java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4832)
at
java.awt.LightweightDispatcher.processMouseEvent(Container.java:4492)
at
java.awt.LightweightDispatcher.dispatchEvent(Container.java:4422)
at java.awt.Container.dispatchEventImpl(Container.java:2273)
at java.awt.Window.dispatchEventImpl(Window.java:2713)
at java.awt.Component.dispatchEvent(Component.java:4687)
at
java.awt.EventQueue.dispatchEventImpl(EventQueue.java:707)
at java.awt.EventQueue.access$000(EventQueue.java:101)
at java.awt.EventQueue$3.run(EventQueue.java:666)
at java.awt.EventQueue$3.run(EventQueue.java:664)
at java.security.AccessController.doPrivileged(Native
Method)
at
java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
at
java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:87)
at java.awt.EventQueue$4.run(EventQueue.java:680)
at java.awt.EventQueue$4.run(EventQueue.java:678)
at java.security.AccessController.doPrivileged(Native
Method)
at
java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:677)
at
java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:211)
at
java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:128)
at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:117)
at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:113)
at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:105)
at
java.awt.EventDispatchThread.run(EventDispatchThread.java:90)
I searched the 'LWGEOM_estimated_extent: couldn't locate table within
current schema' error on our mailing list and found this thread
'http://osgeo-org.1560.n6.nabble.com/Error-Trying-to-Update-Geotools-2-6-2-to-2-7-4-td4338104.html#a4342849'
I am using GeoTools 8, which seems should have fixed the problem.
Any idea how I can get an workaround or I have to dig into postgis for a
fix?
Thanks again!
Yang
--
View this message in context:
http://osgeo-org.1560.n6.nabble.com/Problem-Using-Info-Tool-on-PostGIS-Layer-tp4574141p4577917.html
Sent from the geotools-gt2-users mailing list archive at Nabble.com.
------------------------------------------------------------------------------
Virtualization & Cloud Management Using Capacity Planning
Cloud computing makes use of virtualization - but cloud computing
also focuses on allowing computing to be delivered as a service.
http://www.accelacomm.com/jaw/sfnl/114/51521223/
_______________________________________________
GeoTools-GT2-Users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
