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

       

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Geoserver-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-devel

Reply via email to