Skip to content

SRID=4326 with Oracle #8

@Tom9729

Description

@Tom9729

Setup

I have geometry columns and indices with SRID=4326. I'm trying to support Oracle 10gR2+ and Postgres 9+ with as few differences as possible.

Expected Behaviour

The entries in USER_SDO_GEOM_METADATA for my geometry columns should have SRID=4326.

Observed Behaviour

The entries in USER_SDO_GEOM_METADATA for my geometry columns have SRID=8307.

This is happening because the Oracle SQL generator is wrapping the SRID in MAP_EPSG_SRID_TO_ORACLE which in this case is converting EPSG:4326 to the legacy code SDO:8307.

I suspect this may have been done to support older versions of Oracle (pre 10gR2).

Requested Change

Add an option to disable mapping EPSG codes to Oracle codes. I'm thinking a system property like -Dliquibase.ext.spatial.map-epsg-srid-to-oracle=false would cause the SRIDs to be passed through verbatim.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions