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 : |