deegree SqlFeatureStoreConfigCreator does not apply value set in parameter '-srid' when creating DDL statements for Oracle dialect

[julianzz98]

deegree Version: 3.5.8 (docker image)

When using the deegree SqlFeatureStoreConfigCreator to create a DDL statement for an Oracle database, the value defined within the -srid parameter is not set. Instead the SRID is set as null, causing problems when you want to import the data in the Oracle database using the deegree GmlLoader (ORA-13365: layer SRID does not match geometry SRID).

In order to reproduce the following command can be used (no reference data needed):

java -jar deegree-tools-gml.jar SqlFeatureStoreConfigCreator -format=all -srid=7423 -idtype=uuid -mapping=relational -dialect=oracle -schemaUrl=https://inspire.ec.europa.eu/schemas/bu-core3d/4.0/BuildingsCore3D.xsd

The produced DDL statement then looks like this (excerpt):

INSERT INTO user_sdo_geom_metadata(TABLE_NAME,COLUMN_NAME,DIMINFO,SRID) VALUES ('BU_CORE3D_BUILDING','BU_CORE3D_GEOMETRY2D_BU_BA_202',SDO_DIM_ARRAY(SDO_DIM_ELEMENT('X', -180.0, 180.0, 0.00000005), SDO_DIM_ELEMENT('Y', -90.0, 90.0, 0.00000005)), null);