Mercurial > dive4elements > river
view etl/src/main/resources/sql/flys-oracle-jdbc-oracledriver.properties @ 9713:aef987124822 3.2.x
Do not rely on database default for setting hws_lines.official to 0
It's not under the control of the importer whether the field is rendered
into an INSERT statement, whether it's actually set or not. If it is
unset but rendered into the statement, the field would be set to NULL.
Thus, always set it explicitly.
While here, remove an unused import.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Fri, 12 Mar 2021 15:11:44 +0100 |
| 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