# HG changeset patch # User Sascha L. Teichmann # Date 1348764076 0 # Node ID f37323e86d59346b1854ed32f83ec2b337cb22bf # Parent d3e2080d3adabea5cc6263c1eea587aa1d661f0a S(Q) relation: Fixed SQL projection. flys-artifacts/trunk@5623 c6561f87-3c4e-4783-a992-168aeb5c3f6f diff -r d3e2080d3ada -r f37323e86d59 flys-artifacts/ChangeLog --- 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 + + * src/main/java/de/intevation/flys/artifacts/model/sq/MeasurementFactory.java: + Removed invalid entries of the SQL projection. + 2012-09-27 Sascha L. Teichmann * src/main/java/de/intevation/flys/artifacts/model/sq/MeasurementFactory.java, diff -r d3e2080d3ada -r f37323e86d59 flys-artifacts/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)