Mercurial > dive4elements > framework
diff artifact-database/src/main/java/de/intevation/artifactdatabase/Backend.java @ 151:3d70de111af1
Bugfix: Replaced wrong SQL statements with the correct ones.
artifacts/trunk@1376 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
|---|---|
| date | Thu, 03 Mar 2011 08:04:57 +0000 |
| parents | 101a52d3ad08 |
| children | bf596b83d984 |
line wrap: on
line diff
--- 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