Mercurial > dive4elements > river
comparison flys-artifacts/src/main/java/de/intevation/flys/artifacts/model/WKmsFactory.java @ 1897:cf8a376eb4c9
Fix and use SQL statement to fetch wst-names.
flys-artifacts/trunk@3257 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Felix Wolfsteller <felix.wolfsteller@intevation.de> |
|---|---|
| date | Wed, 16 Nov 2011 09:10:07 +0000 |
| parents | 1cf36ffe69b5 |
| children | 5642a83420f2 |
comparison
equal
deleted
inserted
replaced
| 1896:2e2ca95459d2 | 1897:cf8a376eb4c9 |
|---|---|
| 39 "WHERE wst_id = :wst_id AND position = :column_pos"; | 39 "WHERE wst_id = :wst_id AND position = :column_pos"; |
| 40 | 40 |
| 41 /** Query to get name (description) for wst_id. */ | 41 /** Query to get name (description) for wst_id. */ |
| 42 public static final String SQL_SELECT_WST_NAME = | 42 public static final String SQL_SELECT_WST_NAME = |
| 43 "SELECT description from wsts "+ | 43 "SELECT description from wsts "+ |
| 44 "WHERE wst_id = :wst_id"; | 44 "WHERE id = :wst_id"; |
| 45 | 45 |
| 46 | 46 |
| 47 private WKmsFactory() { | 47 private WKmsFactory() { |
| 48 } | 48 } |
| 49 | 49 |
| 84 log.debug("WKmsFactory.getWKmsName wst_id/" + wst_id); | 84 log.debug("WKmsFactory.getWKmsName wst_id/" + wst_id); |
| 85 | 85 |
| 86 String name = null; | 86 String name = null; |
| 87 Session session = SessionHolder.HOLDER.get(); | 87 Session session = SessionHolder.HOLDER.get(); |
| 88 | 88 |
| 89 SQLQuery nameQuery = session.createSQLQuery(SQL_SELECT_NAME) | 89 SQLQuery nameQuery = session.createSQLQuery(SQL_SELECT_WST_NAME) |
| 90 .addScalar("name", StandardBasicTypes.STRING); | 90 .addScalar("description", StandardBasicTypes.STRING); |
| 91 nameQuery.setInteger("wst_id", wst_id); | 91 nameQuery.setInteger("wst_id", wst_id); |
| 92 | 92 |
| 93 List<String> names = nameQuery.list(); | 93 List<String> names = nameQuery.list(); |
| 94 if (names.size() >= 1) { | 94 if (names.size() >= 1) { |
| 95 name = names.get(0); | 95 name = names.get(0); |