Better error message for database permission problems
-----------------------------------------------------
Key: GEOS-1822
URL: http://jira.codehaus.org/browse/GEOS-1822
Project: GeoServer
Issue Type: Improvement
Components: UI
Affects Versions: 1.6.1
Reporter: Teemu Välimäki
Assignee: Andrea Aime
Priority: Minor
I was about to create a new FeatureType from Postgis DataStore, when GS webgui told, that the SRS could not be found (GS placed -1 on the SRS input field) and when manually entered GS could not calculate BBOX values. The error message was misleading, when it tried to hint me about empty dataset or not having default geometry attribute.
The real problem was, that the Postgres account didn't have query access to table spatial_ref_sys.
Error what GS gave was
{quote}
The FeatureType 'laa_akseli' has a NULL extent.
HINT: the dataset is empty or has no default geometry attribute.
{quote}
GS logged this
{quote}
2008-03-20 12:20:44,280 WARN [org.geotools.data.jdbc] - Error building attribute type. The column will be ignored org.geotools.data.DataSourceException: ERROR: permission denied for relation spatial_ref_sys
{quote}
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira