# HG changeset patch
# User Sascha L. Teichmann <sascha.teichmann@intevation.de>
# Date 1319105626 0
# Node ID 7514fe89efef24875d9074c6bf9274523f2bac5a
# Parent  be883e8435391b116198e764d7931d762f646424
Backend.getMasterArtifact: Limit result to one row.

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

diff -r be883e843539 -r 7514fe89efef ChangeLog
--- a/ChangeLog	Wed Oct 19 16:13:07 2011 +0000
+++ b/ChangeLog	Thu Oct 20 10:13:46 2011 +0000
@@ -1,3 +1,8 @@
+2011-10-20	Sascha L. Teichmann	<sascha.teichmann@intevation.de>
+
+	* artifact-database/src/main/java/de/intevation/artifactdatabase/Backend.java(getMasterArtifact):
+	  Limit result set to one row.
+
 2011-10-19	Felix Wolfsteller	<felix.wolfsteller@intevation.de>
 
 	Fix accidentally corruptd key to sql statement.
diff -r be883e843539 -r 7514fe89efef artifact-database/src/main/java/de/intevation/artifactdatabase/Backend.java
--- a/artifact-database/src/main/java/de/intevation/artifactdatabase/Backend.java	Wed Oct 19 16:13:07 2011 +0000
+++ b/artifact-database/src/main/java/de/intevation/artifactdatabase/Backend.java	Thu Oct 20 10:13:46 2011 +0000
@@ -1265,25 +1265,28 @@
             logger.debug("Invalid collection id: '" + collectionId + "'");
             return null;
         }
-        final List<String> uuid = new ArrayList<String>();
+        final String [] uuid = new String[1];
+
         SQLExecutor.Instance exec = sqlExecutor.new Instance() {
             public boolean doIt() throws SQLException {
                 // Fetch masters (oldest artifact) id.
                 prepareStatement(SQL_COLLECTIONS_OLDEST_ARTIFACT);
                 stmnt.setString(1, collectionId);
-                logger.debug("getMaster.execute");
+                stmnt.setMaxRows(1); //
                 result = stmnt.executeQuery();
                 if (!result.next()) {
                     logger.debug("No such collection: " + collectionId);
                     return false;
                 }
-                logger.debug("getMasterArtifact result.getString " + result.getString(1));
-                uuid.add(result.getString(1));
-                reset();
+                uuid[0] = result.getString(1);
+                if (logger.isDebugEnabled()) {
+                    logger.debug("getMasterArtifact result.getString " +
+                        uuid[0]);
+                }
                 return true;
             }
         };
-        return exec.runRead() ? uuid.get(0) : null;
+        return exec.runRead() ? uuid[0] : null;
     }
 
     public boolean deleteCollection(final String collectionId) {