# HG changeset patch
# User Ingo Weinzierl <ingo.weinzierl@intevation.de>
# Date 1299139497 0
# Node ID 3d70de111af14428dde518e59dd39e0a7c659598
# Parent  78a27a6b3f1f1ad405ec89ab03980a0faacfe2c0
Bugfix: Replaced wrong SQL statements with the correct ones.

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

diff -r 78a27a6b3f1f -r 3d70de111af1 ChangeLog
--- a/ChangeLog	Thu Mar 03 07:10:44 2011 +0000
+++ b/ChangeLog	Thu Mar 03 08:04:57 2011 +0000
@@ -1,3 +1,8 @@
+2011-03-03  Ingo Weinzierl <ingo@intevation.de>
+
+	* artifact-database/src/main/java/de/intevation/artifactdatabase/Backend.java:
+	  Bugfix: Replaced wrong SQL statements with the correct ones.
+
 2011-03-03  Ingo Weinzierl <ingo@intevation.de>
 
 	* artifact-database/src/main/java/de/intevation/artifactdatabase/ArtifactDatabaseImpl.java:
diff -r 78a27a6b3f1f -r 3d70de111af1 artifact-database/src/main/java/de/intevation/artifactdatabase/Backend.java
--- a/artifact-database/src/main/java/de/intevation/artifactdatabase/Backend.java	Thu Mar 03 07:10:44 2011 +0000
+++ b/artifact-database/src/main/java/de/intevation/artifactdatabase/Backend.java	Thu Mar 03 08:04:57 2011 +0000
@@ -946,7 +946,7 @@
 
                 // delete the collections of the user
 
-                stmnt = conn.prepareStatement(SQL_USERS_COLLECTIONS);
+                stmnt = conn.prepareStatement(SQL_USERS_DELETE_COLLECTIONS);
                 stmnt.setInt(1, id);
                 stmnt.execute();
                 stmnt.close(); stmnt = null;
@@ -997,7 +997,7 @@
         DataSource dataSource = DBConnection.getDataSource();
         try {
             conn = dataSource.getConnection();
-            stmnt = conn.prepareStatement(SQL_USERS_SELECT_ID_BY_GID);
+            stmnt = conn.prepareStatement(SQL_USERS_SELECT_GID);
             stmnt.setString(1, identifier);
             result = stmnt.executeQuery();
             if (!result.next()) { // no such user