Mercurial > lada > lada-server
comparison src/main/java/de/intevation/lada/validation/LMessungValidator.java @ 349:c26fcf442353 0.4
Fixed sql statement for messmethode/messgroesse validation.
| author | Raimund Renkert <rrenkert@intevation.de> |
|---|---|
| date | Mon, 02 Sep 2013 13:13:06 +0200 |
| parents | 02803c0e7bd1 |
| children | 6ba7630c7e52 |
comparison
equal
deleted
inserted
replaced
| 348:4612c43127b6 | 349:c26fcf442353 |
|---|---|
| 133 messwertRepository.getEntityManager(), LMesswert.class); | 133 messwertRepository.getEntityManager(), LMesswert.class); |
| 134 builder.and("messungsId", messung.getMessungsId()) | 134 builder.and("messungsId", messung.getMessungsId()) |
| 135 .and("probeId", messung.getProbeId()); | 135 .and("probeId", messung.getProbeId()); |
| 136 Response response = messwertRepository.filter(builder.getQuery()); | 136 Response response = messwertRepository.filter(builder.getQuery()); |
| 137 List<LMesswert> messwerte = (List<LMesswert>)response.getData(); | 137 List<LMesswert> messwerte = (List<LMesswert>)response.getData(); |
| 138 String query = "select messgroesse_id from S_mmt_messgroesse where mmt_id = " + mmt; | 138 String query = "select messgroesse_id from \"S_mmt_messgroesse\" where mmt_id = '" + mmt + "'"; |
| 139 List<Object[]> results = readonlyRepository.getEntityManager().createNativeQuery(query).getResultList(); | 139 List<Object[]> results = readonlyRepository.getEntityManager().createNativeQuery(query).getResultList(); |
| 140 for(LMesswert messwert: messwerte) { | 140 for(LMesswert messwert: messwerte) { |
| 141 boolean hit = false; | 141 boolean hit = false; |
| 142 for (Object[] row: results) { | 142 for (Object[] row: results) { |
| 143 if (messwert.getMessgroesseId().equals(row[0].toString())) { | 143 if (messwert.getMessgroesseId().equals(row[0].toString())) { |