[Geoserver-devel] [jira] Created: (GEOS-1302) USER_SDO_GEOM_METADATA not being read when login is not data owner

GeoServer GeoServer Developer
1

USER_SDO_GEOM_METADATA not being read when login is not data owner
-------------------------------------------------------------------

                 Key: GEOS-1302
                 URL: http://jira.codehaus.org/browse/GEOS-1302
             Project: GeoServer
          Issue Type: Bug
          Components: Oracle
    Affects Versions: 1.5.3
         Environment: Windows XP Pro, Oracle XE
            Reporter: Jeff Hobbs
            Assignee: Andrea Aime

I have data in SCHEMA1. All of the pertinent metadata is completed in USER_SDO_GEOM_METADATA for SCHEMA 1. I've created a user named MYUSER. MYUSER has select privs on some of the tables in SCHEMA1. When I'm trying to create a new feature in the admin, I'm getting the following error:

"No geometry column for srid in table: FIRE_HYDRANT, geometry column GDO_GEOMETRY, be sure column is defined in USER_SDO_GEOM_METADATA"

When I change the user from MYUSER to SCHEMA1, the error goes away.

I've even tried to build the USER_SDO_GEOM_METADATA metadata in the MYUSER schema referencing "SCHEMA1.FIRE_HYDRANT" as the table name. This does not solve the problem.

In the connection settings, I have SCHEMA1 set as the schema.

--
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

2

This is likely caused by the ‘USER’ part of that view – the solution is likely to have the Oracle driver read from ALL_SDO_GEOM_METADATA.

David

On 8/24/07, Jeff Hobbs (JIRA) <jira@anonymised.com> wrote:

USER_SDO_GEOM_METADATA not being read when login is not data owner

Key: GEOS-1302
URL: http://jira.codehaus.org/browse/GEOS-1302
Project: GeoServer
Issue Type: Bug
Components: Oracle
Affects Versions: 1.5.3
Environment: Windows XP Pro, Oracle XE
Reporter: Jeff Hobbs
Assignee: Andrea Aime

I have data in SCHEMA1. All of the pertinent metadata is completed in USER_SDO_GEOM_METADATA for SCHEMA 1. I’ve created a user named MYUSER. MYUSER has select privs on some of the tables in SCHEMA1. When I’m trying to create a new feature in the admin, I’m getting the following error:

“No geometry column for srid in table: FIRE_HYDRANT, geometry column GDO_GEOMETRY, be sure column is defined in USER_SDO_GEOM_METADATA”

When I change the user from MYUSER to SCHEMA1, the error goes away.

I’ve even tried to build the USER_SDO_GEOM_METADATA metadata in the MYUSER schema referencing “SCHEMA1.FIRE_HYDRANT” as the table name. This does not solve the problem.

In the connection settings, I have SCHEMA1 set as the schema.

–
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: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/

Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel