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) { |