--- a/flys-artifacts/src/main/java/de/intevation/flys/artifacts/model/RiverFactory.java	Tue Mar 15 17:12:58 2011 +0000
+++ b/flys-artifacts/src/main/java/de/intevation/flys/artifacts/model/RiverFactory.java	Thu Mar 17 11:46:43 2011 +0000
@@ -1,8 +1,15 @@
 package de.intevation.flys.artifacts.model;
 
-import java.util.ArrayList;
+
 import java.util.List;
 
+import de.intevation.flys.model.River;
+
+import de.intevation.flys.backend.SessionFactoryProvider;
+
+import org.hibernate.SessionFactory;
+import org.hibernate.Session;
+import org.hibernate.Query;
 
 /**
  * @author <a href="mailto:ingo.weinzierl@intevation.de">Ingo Weinzierl</a>
@@ -20,12 +27,15 @@
      * @return all rivers.
      */
     public static List<River> getRivers() {
-        List<River> rivers = new ArrayList<River>();
-
-        rivers.add(new River("Mosel"));
-        rivers.add(new River("Saar"));
-
-        return rivers;
+        SessionFactory sf = SessionFactoryProvider.getSessionFactory();
+        Session session = sf.openSession();
+        try {
+            return (List<River>)session
+                .createQuery("from River order by name").list();
+        }
+        finally {
+            session.close();
+        }
     }
 }
 // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf-8 :