Mercurial > dive4elements > river
comparison flys-artifacts/src/main/java/de/intevation/flys/artifacts/model/WQKmsFactory.java @ 5727:26dcd924befc
WQKmsFactory: Fix name sql.
author | Felix Wolfsteller <felix.wolfsteller@intevation.de> |
---|---|
date | Tue, 16 Apr 2013 12:39:12 +0200 |
parents | 17eba7d251b2 |
children | c08f691652cf |
comparison
equal
deleted
inserted
replaced
5726:17eba7d251b2 | 5727:26dcd924befc |
---|---|
35 | 35 |
36 /** Query to get name for wst_id and column_pos. */ | 36 /** Query to get name for wst_id and column_pos. */ |
37 public static final String SQL_SELECT_NAME = | 37 public static final String SQL_SELECT_NAME = |
38 "SELECT name " + | 38 "SELECT name " + |
39 "FROM wst_columns "+ | 39 "FROM wst_columns "+ |
40 "WHERE wst_id = :wst_id AND position = :column_pos"; | 40 "WHERE id = :column_id"; |
41 | 41 |
42 | 42 |
43 /** Hidden constructor, use static methods instead. */ | 43 /** Hidden constructor, use static methods instead. */ |
44 private WQKmsFactory() { | 44 private WQKmsFactory() { |
45 } | 45 } |
46 | 46 |
47 | 47 |
48 /** | 48 /** |
49 * Get WKms for given column and wst_id, caring about the cache. | 49 * Get WKms for given column (pos) and wst_id, caring about the cache. |
50 */ | 50 */ |
51 public static WQKms getWQKms(int column, int wst_id) { | 51 public static WQKms getWQKms(int column, int wst_id) { |
52 log.debug("WQKmsFactory.getWQKms"); | 52 log.debug("WQKmsFactory.getWQKms"); |
53 Cache cache = CacheFactory.getCache(StaticWQKmsCacheKey.CACHE_NAME); | 53 Cache cache = CacheFactory.getCache(StaticWQKmsCacheKey.CACHE_NAME); |
54 | 54 |