On Sat, Nov 24, 2012 at 2:35 PM, Raffaello Bertini <
[email protected]> 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
--
==
Our support, Your Success! Visit http://opensdi.geo-solutions.it for more
information.
==
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
-------------------------------------------------------
------------------------------------------------------------------------------
Monitor your physical, virtual and cloud infrastructure from a single
web console. Get in-depth insight into apps, servers, databases, vmware,
SAP, cloud infrastructure, etc. Download 30-day Free Trial.
Pricing starts from $795 for 25 servers or applications!
http://p.sf.net/sfu/zoho_dev2dev_nov
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
