annotate flys-aft/src/main/resources/sql/aft-oracle-jdbc-oracledriver.properties @ 4655:cd44d28d0fbc

Move the access to artifact data to the Access object Use BedHeightAccess class to receive the data from the artifact. This abstracts the data access from the actual artifact.
author Björn Ricks <bjoern.ricks@intevation.de>
date Tue, 11 Dec 2012 09:44:04 +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