i’m using postgres 9.2 postgis2.0 geoserver 2.2.1
Can i use geoserver for import VIEWs from postgis?
because i’ve got exception error import it.
here:
java.lang.RuntimeException: java.io.IOException: Error occured calculating bounds at org.geotools.jdbc.JDBCFeatureSource.getBoundsInternal(JDBCFeatureSource.java:508) at org.geotools.data.store.ContentFeatureSource.getBounds(ContentFeatureSource.java:426) at org.geotools.data.store.ContentFeatureSource.getBounds(ContentFeatureSource.java:363) .
.
. at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:395) at org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:450) Caused by: java.io.IOException: Error occured calculating bounds at org.geotools.jdbc.JDBCDataStore.getBounds(JDBCDataStore.java:1173) at org.geotools.jdbc.JDBCFeatureSource.getBoundsInternal(JDBCFeatureSource.java:501) … 91 more Caused by: org.postgresql.util.PSQLException: ERROR: relation “emily_2po_4gr” does not exist at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2101) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1834) .
.
.
On Sat, Nov 24, 2012 at 2:35 PM, Raffaello Bertini <raffaellobertini@anonymised.com> wrote:
i’m using postgres 9.2 postgis2.0 geoserver 2.2.1
Can i use geoserver for import VIEWs from postgis?
because i’ve got exception error import it.
here:
java.lang.RuntimeException: java.io.IOException: Error occured calculating bounds at org.geotools.jdbc.JDBCFeatureSource.getBoundsInternal(JDBCFeatureSource.java:508) at org.geotools.data.store.ContentFeatureSource.getBounds(ContentFeatureSource.java:426) at org.geotools.data.store.ContentFeatureSource.getBounds(ContentFeatureSource.java:363) .
.
. at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:395) at org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:450) Caused by: java.io.IOException: Error occured calculating bounds at org.geotools.jdbc.JDBCDataStore.getBounds(JDBCDataStore.java:1173) at org.geotools.jdbc.JDBCFeatureSource.getBoundsInternal(JDBCFeatureSource.java:501) … 91 more Caused by: org.postgresql.util.PSQLException: ERROR: relation “emily_2po_4gr” does not exist at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2101) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1834)
The error says emily_2po_4gr does not exists.
Is it a table used in the view? If so, maybe it’s a typo, maybe the user for the connection pool is not allowed to see that
table?
Cheers
Andrea
–
Ing. Andrea Aime
@geowolf
Technical Lead
GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 339 8844549
http://www.geo-solutions.it
http://twitter.com/geosolutions_it
I’m so sorry. It’s was my fault!!! I don’t see the bad table name…
Geoserver it’s properly working.
sorry again.
2012/11/25 Andrea Aime <andrea.aime@anonymised.com107…>
On Sat, Nov 24, 2012 at 2:35 PM, Raffaello Bertini <raffaellobertini@anonymised.com…84…> wrote:
i’m using postgres 9.2 postgis2.0 geoserver 2.2.1
Can i use geoserver for import VIEWs from postgis?
because i’ve got exception error import it.
here:
java.lang.RuntimeException: java.io.IOException: Error occured calculating bounds at org.geotools.jdbc.JDBCFeatureSource.getBoundsInternal(JDBCFeatureSource.java:508) at org.geotools.data.store.ContentFeatureSource.getBounds(ContentFeatureSource.java:426) at org.geotools.data.store.ContentFeatureSource.getBounds(ContentFeatureSource.java:363) .
.
. at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:395) at org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:450) Caused by: java.io.IOException: Error occured calculating bounds at org.geotools.jdbc.JDBCDataStore.getBounds(JDBCDataStore.java:1173) at org.geotools.jdbc.JDBCFeatureSource.getBoundsInternal(JDBCFeatureSource.java:501) … 91 more Caused by: org.postgresql.util.PSQLException: ERROR: relation “emily_2po_4gr” does not exist at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2101) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1834)
The error says emily_2po_4gr does not exists.
Is it a table used in the view? If so, maybe it’s a typo, maybe the user for the connection pool is not allowed to see that
table?
Cheers
Andrea
–
Ing. Andrea Aime
@geowolf
Technical Lead
GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 339 8844549
http://www.geo-solutions.it
http://twitter.com/geosolutions_it