Mercurial > dive4elements > river
diff flys-artifacts/src/main/java/de/intevation/flys/artifacts/model/SQOverview.java @ 3289:ec9aab93f292
SQ: First peek into fetching relevant data from SedDB
flys-artifacts/trunk@4957 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Thu, 12 Jul 2012 16:15:30 +0000 |
| parents | 30f157c7e466 |
| children | 36f3b53d5cfc |
line wrap: on
line diff
--- a/flys-artifacts/src/main/java/de/intevation/flys/artifacts/model/SQOverview.java Thu Jul 12 14:03:15 2012 +0000 +++ b/flys-artifacts/src/main/java/de/intevation/flys/artifacts/model/SQOverview.java Thu Jul 12 16:15:30 2012 +0000 @@ -96,6 +96,7 @@ " ON s.gewaesserid = g.gewaesserid " + "WHERE" + " m.gsiebsatzid IS NOT NULL AND" + + " m.q IS NOT NULL AND" + " g.name = :name " + "ORDER by" + " s.km, m.datum"; @@ -119,8 +120,8 @@ protected void loadData(Session session) { SQLQuery query = session.createSQLQuery(SQL_SQ) - .addScalar("km", StandardBasicTypes.DOUBLE) - .addScalar("datum", StandardBasicTypes.DATE); + .addScalar("km", StandardBasicTypes.DOUBLE) + .addScalar("datum", StandardBasicTypes.DATE); query.setString("name", riverName);