Mercurial > dive4elements > framework
changeset 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 | 78a27a6b3f1f |
| children | 7e5619115d5b |
| files | ChangeLog artifact-database/src/main/java/de/intevation/artifactdatabase/Backend.java |
| diffstat | 2 files changed, 7 insertions(+), 2 deletions(-) [+] |
line wrap: on
line diff
--- 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:
--- 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