# HG changeset patch
# User Felix Wolfsteller <felix.wolfsteller@intevation.de>
# Date 1321434607 0
# Node ID cf8a376eb4c9b9678bf8e8e3a5cb7301e5cdfbbc
# Parent  2e2ca95459d21eda713048938db10674623fc456
Fix and use SQL statement to fetch wst-names.

flys-artifacts/trunk@3257 c6561f87-3c4e-4783-a992-168aeb5c3f6f

diff -r 2e2ca95459d2 -r cf8a376eb4c9 flys-artifacts/ChangeLog
--- 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,
diff -r 2e2ca95459d2 -r cf8a376eb4c9 flys-artifacts/src/main/java/de/intevation/flys/artifacts/model/WKmsFactory.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();