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 <[email protected]>
> 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
