changeset 3929:f37323e86d59

S(Q) relation: Fixed SQL projection. flys-artifacts/trunk@5623 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Thu, 27 Sep 2012 16:41:16 +0000 (2012-09-27)
parents d3e2080d3ada
children 442973614796
files flys-artifacts/ChangeLog flys-artifacts/src/main/java/de/intevation/flys/artifacts/model/sq/MeasurementFactory.java
diffstat 2 files changed, 6 insertions(+), 4 deletions(-) [+]
line wrap: on
line diff
--- a/flys-artifacts/ChangeLog	Thu Sep 27 16:31:21 2012 +0000
+++ b/flys-artifacts/ChangeLog	Thu Sep 27 16:41:16 2012 +0000
@@ -1,3 +1,8 @@
+2012-09-27	Sascha L. Teichmann	<sascha.teichmann@intevation.de>
+
+	* src/main/java/de/intevation/flys/artifacts/model/sq/MeasurementFactory.java:
+	  Removed invalid entries of the SQL projection.
+
 2012-09-27	Sascha L. Teichmann	<sascha.teichmann@intevation.de>
 
 	* src/main/java/de/intevation/flys/artifacts/model/sq/MeasurementFactory.java,
--- a/flys-artifacts/src/main/java/de/intevation/flys/artifacts/model/sq/MeasurementFactory.java	Thu Sep 27 16:31:21 2012 +0000
+++ b/flys-artifacts/src/main/java/de/intevation/flys/artifacts/model/sq/MeasurementFactory.java	Thu Sep 27 16:41:16 2012 +0000
@@ -27,7 +27,7 @@
         "SELECT m.datum        AS DATUM," +
                "g.UFERABST     AS UFERABST," +
                "g.UFERABLINKS  AS UFERABLINKS," +
-               "m.tschweb      AS TSCHWEB," +
+               "m.TSCHWEB      AS TSCHWEB," +
                "m.TSAND        AS TSAND," +
                "gp.MESSDAUER   AS MESSDAUER," +
                "gp.MENGE       AS MENGE," +
@@ -107,9 +107,6 @@
         }
 
         SQLQuery query = session.createSQLQuery(SQL_MEASSURE)
-            .addScalar("TSAND",        StandardBasicTypes.DOUBLE)
-            .addScalar("TSCHWEB",      StandardBasicTypes.DOUBLE)
-            .addScalar("CSCHWEB",      StandardBasicTypes.DOUBLE)
             .addScalar("Q_BPEGEL",     StandardBasicTypes.DOUBLE)
             .addScalar("DATUM",        StandardBasicTypes.DATE)
             .addScalar("UFERABST",     StandardBasicTypes.DOUBLE)

http://dive4elements.wald.intevation.org