Mercurial > dive4elements > river
comparison flys-backend/src/main/java/de/intevation/flys/model/River.java @ 3795:f210432f4383
Fix hibernate query
flys-backend/trunk@5438 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Bjoern Ricks <bjoern.ricks@intevation.de> |
|---|---|
| date | Wed, 12 Sep 2012 11:12:19 +0000 |
| parents | 42db09d101f3 |
| children | 5fea100c5334 |
comparison
equal
deleted
inserted
replaced
| 3794:42db09d101f3 | 3795:f210432f4383 |
|---|---|
| 222 | 222 |
| 223 public double[] determineMinMaxQ() { | 223 public double[] determineMinMaxQ() { |
| 224 Session session = SessionHolder.HOLDER.get(); | 224 Session session = SessionHolder.HOLDER.get(); |
| 225 | 225 |
| 226 Query query = session.createQuery( | 226 Query query = session.createQuery( |
| 227 "select min(wqr.q) as min, max(wqr.q) as max from Wst w " + | 227 "select min(wqr.q) as min, max(wqr.q) as max " + |
| 228 "join WstColumns as wc " + | 228 "from Wst as w " + |
| 229 "join WstColumnQRange as wcqr " + | 229 "join w.columns as wc " + |
| 230 "join WstQRange as wqr " + | 230 "join wc.columnQRanges as wcqr " + |
| 231 "where w.kind = 0 and river_id = :river_id"); | 231 "join wcqr.wstQRange as wqr " + |
| 232 "where w.kind = 0 and river_id = :river"); | |
| 232 | 233 |
| 233 query.setParameter("river", getId()); | 234 query.setParameter("river", getId()); |
| 234 | 235 |
| 235 double minmax[] = new double[] { Double.MAX_VALUE, Double.MIN_VALUE }; | 236 double minmax[] = new double[] { Double.MAX_VALUE, Double.MIN_VALUE }; |
| 236 | 237 |