annotate flys-aft/src/main/resources/sql/aft-oracle-jdbc-oracledriver.properties @ 4368:1c5370683769

Fixed sediment yield parser. * Fixed loading files ending with '_Sand.csv'. There are different files ending like this, containing different data sets. * Added new file ending. Naming for files is different in single year and official epochs.
author Raimund Renkert <rrenkert@intevation.de>
date Fri, 02 Nov 2012 14:43:01 +0100
parents 9ba12119e662
children d9f1202cef78
rev   line source
4106
9ba12119e662 Added SQL statements to make the connection to the AFT database Oracle compatible.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
1 select.abflusstafel = SELECT ABFLUSSTAFEL_NR, \
9ba12119e662 Added SQL statements to make the connection to the AFT database Oracle compatible.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
2 ABFLUSSTAFEL_BEZ, \
9ba12119e662 Added SQL statements to make the connection to the AFT database Oracle compatible.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
3 GUELTIG_VON, \
9ba12119e662 Added SQL statements to make the connection to the AFT database Oracle compatible.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
4 GUELTIG_BIS, \
9ba12119e662 Added SQL statements to make the connection to the AFT database Oracle compatible.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
5 PEGELNULLPUNKT FROM ABFLUSSTAFEL WHERE MESSSTELLE_NR LIKE :number
9ba12119e662 Added SQL statements to make the connection to the AFT database Oracle compatible.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
6

http://dive4elements.wald.intevation.org