Re: [Geoserver-users] Geoserver 2.2.1 generating exception when computing BBox coords from postgis viewtable.

[Andrea A. <and...@ge...>]

On Sat, Nov 24, 2012 at 2:35 PM, Raffaello Bertini <
raf...@gm...> 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

-------------------------------------------------------