annotate flys-aft/src/main/resources/sql/aft-oracle-jdbc-oracledriver.properties @ 4218:6ae99d996f79

flys/issue903: Display the discharge tables of the selected gauge as chart in historical discharge calculation. There is a new class 'DischargeTablesChart' which is a Canvas and displays the chart using the new service 'DischargeTablesServiceImpl'.
author Ingo Weinzierl <ingo.weinzierl@intevation.de>
date Tue, 23 Oct 2012 12:01:19 +0200
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