Mercurial > dive4elements > river
comparison flys-artifacts/src/main/java/de/intevation/flys/artifacts/model/sq/MeasurementFactory.java @ 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 |
| parents | d3e2080d3ada |
| children | 6bcc50e2cc7d |
comparison
equal
deleted
inserted
replaced
| 3928:d3e2080d3ada | 3929:f37323e86d59 |
|---|---|
| 25 | 25 |
| 26 public static final String SQL_MEASSURE = | 26 public static final String SQL_MEASSURE = |
| 27 "SELECT m.datum AS DATUM," + | 27 "SELECT m.datum AS DATUM," + |
| 28 "g.UFERABST AS UFERABST," + | 28 "g.UFERABST AS UFERABST," + |
| 29 "g.UFERABLINKS AS UFERABLINKS," + | 29 "g.UFERABLINKS AS UFERABLINKS," + |
| 30 "m.tschweb AS TSCHWEB," + | 30 "m.TSCHWEB AS TSCHWEB," + |
| 31 "m.TSAND AS TSAND," + | 31 "m.TSAND AS TSAND," + |
| 32 "gp.MESSDAUER AS MESSDAUER," + | 32 "gp.MESSDAUER AS MESSDAUER," + |
| 33 "gp.MENGE AS MENGE," + | 33 "gp.MENGE AS MENGE," + |
| 34 "gp.GTRIEB AS GTRIEB," + | 34 "gp.GTRIEB AS GTRIEB," + |
| 35 "gp.LFDNR AS LFDNR," + | 35 "gp.LFDNR AS LFDNR," + |
| 105 if (debug) { | 105 if (debug) { |
| 106 log.debug(SQL_MEASSURE); | 106 log.debug(SQL_MEASSURE); |
| 107 } | 107 } |
| 108 | 108 |
| 109 SQLQuery query = session.createSQLQuery(SQL_MEASSURE) | 109 SQLQuery query = session.createSQLQuery(SQL_MEASSURE) |
| 110 .addScalar("TSAND", StandardBasicTypes.DOUBLE) | |
| 111 .addScalar("TSCHWEB", StandardBasicTypes.DOUBLE) | |
| 112 .addScalar("CSCHWEB", StandardBasicTypes.DOUBLE) | |
| 113 .addScalar("Q_BPEGEL", StandardBasicTypes.DOUBLE) | 110 .addScalar("Q_BPEGEL", StandardBasicTypes.DOUBLE) |
| 114 .addScalar("DATUM", StandardBasicTypes.DATE) | 111 .addScalar("DATUM", StandardBasicTypes.DATE) |
| 115 .addScalar("UFERABST", StandardBasicTypes.DOUBLE) | 112 .addScalar("UFERABST", StandardBasicTypes.DOUBLE) |
| 116 .addScalar("UFERABLINKS", StandardBasicTypes.DOUBLE) | 113 .addScalar("UFERABLINKS", StandardBasicTypes.DOUBLE) |
| 117 .addScalar("TSCHWEB", StandardBasicTypes.DOUBLE) | 114 .addScalar("TSCHWEB", StandardBasicTypes.DOUBLE) |