Mercurial > dive4elements > river
diff 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 |
line wrap: on
line diff
--- a/flys-artifacts/src/main/java/de/intevation/flys/artifacts/model/WKmsFactory.java Tue Nov 15 14:48:53 2011 +0000 +++ b/flys-artifacts/src/main/java/de/intevation/flys/artifacts/model/WKmsFactory.java Wed Nov 16 09:10:07 2011 +0000 @@ -41,7 +41,7 @@ /** Query to get name (description) for wst_id. */ public static final String SQL_SELECT_WST_NAME = "SELECT description from wsts "+ - "WHERE wst_id = :wst_id"; + "WHERE id = :wst_id"; private WKmsFactory() { @@ -86,8 +86,8 @@ String name = null; Session session = SessionHolder.HOLDER.get(); - SQLQuery nameQuery = session.createSQLQuery(SQL_SELECT_NAME) - .addScalar("name", StandardBasicTypes.STRING); + SQLQuery nameQuery = session.createSQLQuery(SQL_SELECT_WST_NAME) + .addScalar("description", StandardBasicTypes.STRING); nameQuery.setInteger("wst_id", wst_id); List<String> names = nameQuery.list();