Mercurial > dive4elements > river
comparison flys-backend/src/main/java/de/intevation/flys/model/Wst.java @ 469:b5ca22aae092
Fixed index problem when an empty list is returned.
flys-backend/trunk@1708 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Fri, 15 Apr 2011 14:30:54 +0000 |
| parents | 8d76556c9616 |
| children | 9aa0eddc5221 |
comparison
equal
deleted
inserted
replaced
| 468:8d76556c9616 | 469:b5ca22aae092 |
|---|---|
| 124 " (select wstQRange.id from WstColumnQRange where " + | 124 " (select wstQRange.id from WstColumnQRange where " + |
| 125 " wstColumn.id in (select id from WstColumn where wst.id = :wst)) " + | 125 " wstColumn.id in (select id from WstColumn where wst.id = :wst)) " + |
| 126 " and range.id in " + | 126 " and range.id in " + |
| 127 " (select id from Range where not (a > :end or b < :start))"); | 127 " (select id from Range where not (a > :end or b < :start))"); |
| 128 | 128 |
| 129 query.setParameter("wst", getId()); | 129 query.setParameter("wst", getId()); |
| 130 query.setParameter("start", range.getA()); | 130 query.setParameter("start", range.getA()); |
| 131 query.setParameter("end", range.getB()); | 131 query.setParameter("end", range.getB()); |
| 132 | 132 |
| 133 List results = query.list(); | 133 List<Object []> results = query.list(); |
| 134 Object[] result = (Object[]) results.get(0); | |
| 135 | 134 |
| 136 return result != null | 135 if (results.isEmpty()) { |
| 137 ? new double[] { | 136 return null; |
| 138 ((BigDecimal) result[0]).doubleValue(), | 137 } |
| 139 ((BigDecimal) result[1]).doubleValue() } | 138 |
| 140 : null; | 139 Object [] result = results.get(0); |
| 140 | |
| 141 return new double [] { | |
| 142 ((BigDecimal)result[0]).doubleValue(), | |
| 143 ((BigDecimal)result[1]).doubleValue() }; | |
| 141 } | 144 } |
| 142 } | 145 } |
| 143 // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 : | 146 // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 : |