changeset 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 2e2ca95459d2
children 7053e3255ab4
files flys-artifacts/ChangeLog flys-artifacts/src/main/java/de/intevation/flys/artifacts/model/WKmsFactory.java
diffstat 2 files changed, 8 insertions(+), 3 deletions(-) [+]
line wrap: on
line diff
--- a/flys-artifacts/ChangeLog	Tue Nov 15 14:48:53 2011 +0000
+++ b/flys-artifacts/ChangeLog	Wed Nov 16 09:10:07 2011 +0000
@@ -1,3 +1,8 @@
+2011-11-16  Felix Wolfsteller <felix.wolfsteller@intevation.de>
+
+	* src/main/java/de/intevation/flys/artifacts/model/WKmsFactory.java:
+	  (getWstName): Fix and use SQL statement.
+
 2011-11-15  Felix Wolfsteller <felix.wolfsteller@intevation.de>
 
 	* src/main/java/de/intevation/flys/artifacts/model/WQFacet.java,
--- 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();

http://dive4elements.wald.intevation.org