view etl/src/main/resources/sql/flys-oracle-jdbc-oracledriver.properties @ 6693:88bb0c794833

issue1391: Enable GaugeDischarge artifact to directly load a table by its ID This allows us to use the GaugeDischargeArtifact for any discharge tables that we have in our database. The name of the created facet is taken from the ids string as is also usual in the WMS artifacts.
author Andre Heinecke <aheinecke@intevation.de>
date Mon, 29 Jul 2013 12:19:57 +0200
parents 5aa05a7a34b7
children
line wrap: on
line source
next.gauge.id = \
    SELECT GAUGES_ID_SEQ.NEXTVAL AS gauge_id FROM DUAL
next.timeinterval.id = \
    SELECT TIME_INTERVALS_ID_SEQ.NEXTVAL AS time_interval_id FROM DUAL
next.discharge.id = \
    SELECT DISCHARGE_TABLES_ID_SEQ.NEXTVAL AS discharge_table_id FROM DUAL
next.discharge.table.values.id = \
    SELECT DISCHARGE_TABLE_VALUES_ID_SEQ.NEXTVAL AS discharge_table_values_id FROM DUAL

http://dive4elements.wald.intevation.org