Looks like the user/password you used when connecting via geotools does not
have acess to the PostGIS book keeping tables (geometry_columns table etc...).
Try checking with PgAdmin?
--
Jody Garnett
On Tuesday, 24 May 2011 at 4:55 PM, Gerson Galang wrote:
> Hi Guys,
>
> I ingested a couple of shape files into PostGIS and after running a
> query against it, an exception gets thrown even if the query returns a
> proper response.
>
> Here are the tables I have in my DB:
> geo=# \dt;
> List of relations
> Schema | Name | Type | Owner
> --------+-------------------+-------+-------
> public | geometry_columns | table | gis
> public | lga07aaust_region | table | gis
> public | spatial_ref_sys | table | gis
> public | ssc06aaust_region | table | gis
>
> Here's the code snippet that I'm trying to execute:
> String typeName = "ssc06aaust_region";
> FeatureSource source = dataStore.getFeatureSource(typeName);
>
> Filter filter = CQL
> .toFilter("name_2006 = 'Melbourne'");
> FeatureCollection<SimpleFeatureType, SimpleFeature> features =
> source
> .getFeatures(filter);
> System.out.println(features.size());
>
> And the exception that it throws back to the terminal:
> May 24, 2011 2:55:14 PM org.geotools.jdbc.JDBCFeatureSource buildFeatureType
> WARNING: Error occured determing srid for ssc06aaust_region.wkb_geometry
> org.postgresql.util.PSQLException: ERROR: permission denied for relation
> geography_columns
> 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.getGeometrySRID(PostGISDialect.java:386)
> at
> org.geotools.jdbc.JDBCFeatureSource.buildFeatureType(JDBCFeatureSource.java:291)
> at
> org.geotools.jdbc.JDBCDataStore.createFeatureSource(JDBCDataStore.java:767)
> at
> org.geotools.data.store.ContentDataStore.getFeatureSource(ContentDataStore.java:384)
> at
> org.geotools.data.store.ContentDataStore.getFeatureSource(ContentDataStore.java:349)
> at
> org.geotools.data.store.ContentDataStore.getFeatureSource(ContentDataStore.java:102)
> at au.org.aurin.wfs.client.QueryLab.filterFeatures(QueryLab.java:116)
> at au.org.aurin.wfs.client.QueryLab.connect(QueryLab.java:103)
> at au.org.aurin.wfs.client.QueryLab.<init>(QueryLab.java:67)
> at au.org.aurin.wfs.client.QueryLab.main(QueryLab.java:54)
>
> Note that I still get "1" as the output in stdout even if the exception
> gets thrown in stderr.
>
> Any ideas?
>
> Thanks,
> Gerson
>
> ------------------------------------------------------------------------------
> vRanger cuts backup time in half-while increasing security.
> With the market-leading solution for virtual backup and recovery,
> you get blazing-fast, flexible, and affordable data protection.
> Download your free trial now.
> http://p.sf.net/sfu/quest-d2dcopy1
> _______________________________________________
> Geotools-gt2-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
>
------------------------------------------------------------------------------
vRanger cuts backup time in half-while increasing security.
With the market-leading solution for virtual backup and recovery,
you get blazing-fast, flexible, and affordable data protection.
Download your free trial now.
http://p.sf.net/sfu/quest-d2dcopy1
_______________________________________________
Geotools-gt2-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
