Mercurial > dive4elements > river
comparison flys-artifacts/src/main/java/de/intevation/flys/artifacts/model/AnnotationsFactory.java @ 1925:01f2473e362d
Fixed flys/411 (Oracle max expressions for annotations query).
flys-artifacts/trunk@3301 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Felix Wolfsteller <felix.wolfsteller@intevation.de> |
|---|---|
| date | Tue, 22 Nov 2011 14:00:55 +0000 |
| parents | 57b03b3ab15c |
| children | 97a25b54eea3 |
comparison
equal
deleted
inserted
replaced
| 1924:57b03b3ab15c | 1925:01f2473e362d |
|---|---|
| 28 * value set. | 28 * value set. |
| 29 */ | 29 */ |
| 30 public static List<Annotation> getPointAnnotations(String river) { | 30 public static List<Annotation> getPointAnnotations(String river) { |
| 31 Session session = SessionHolder.HOLDER.get(); | 31 Session session = SessionHolder.HOLDER.get(); |
| 32 | 32 |
| 33 Query rangesQuery = session.createQuery( | |
| 34 "from Range where river.name=:name and b = null"); | |
| 35 rangesQuery.setParameter("name", river); | |
| 36 List<Range> ranges = rangesQuery.list(); | |
| 37 | |
| 38 Query query = session.createQuery( | 33 Query query = session.createQuery( |
| 39 "from Annotation where range in (:ranges) order by range.a"); | 34 "from Annotation as an " + |
| 40 query.setParameterList("ranges", ranges); | 35 "where an.range.b = null and an.range.river.name=:name " + |
| 36 "order by range.a"); | |
| 37 query.setParameter("name", river); | |
| 41 return query.list(); | 38 return query.list(); |
| 42 } | 39 } |
| 43 | 40 |
| 44 | 41 |
| 45 public static List<Annotation> getAnnotations(River river) { | 42 public static List<Annotation> getAnnotations(River river) { |