dive4elements/framework: artifact-database/src/main/java/de/intevation/artifactdatabase/Backend.java annotate

annotate artifact-database/src/main/java/de/intevation/artifactdatabase/Backend.java @ 170:ac0f8bd97277

Fix parameter propagation of creation time ond collection names. artifacts/trunk@1395 c6561f87-3c4e-4783-a992-168aeb5c3f6f

author	Sascha L. Teichmann <sascha.teichmann@intevation.de>
date	Fri, 04 Mar 2011 10:51:10 +0000
parents	c9c27aca2f70
children	25d472a67a9f

rev	line source
100 933bbc9fc11f Added license file and license headers. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 93 diff changeset	1 /*
933bbc9fc11f Added license file and license headers. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 93 diff changeset	2 * Copyright (c) 2010 by Intevation GmbH
933bbc9fc11f Added license file and license headers. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 93 diff changeset	3 *
933bbc9fc11f Added license file and license headers. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 93 diff changeset	4 * This program is free software under the LGPL (>=v2.1)
933bbc9fc11f Added license file and license headers. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 93 diff changeset	5 * Read the file LGPL.txt coming with the software for details
933bbc9fc11f Added license file and license headers. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 93 diff changeset	6 * or visit http://www.gnu.org/licenses/ if it does not exist.
933bbc9fc11f Added license file and license headers. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 93 diff changeset	7 */
933bbc9fc11f Added license file and license headers. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 93 diff changeset	8
13 0d6badf6af42 Added not yet working backend to artifact database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	9 package de.intevation.artifactdatabase;
0d6badf6af42 Added not yet working backend to artifact database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	10
158 d718a4d55662 Implemented the createCollection() method in the artifact database. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 157 diff changeset	11 import de.intevation.artifacts.Artifact;
157 6e6965873a48 Simplified creation of users. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 156 diff changeset	12 import de.intevation.artifacts.ArtifactCollection;
158 d718a4d55662 Implemented the createCollection() method in the artifact database. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 157 diff changeset	13 import de.intevation.artifacts.ArtifactCollectionFactory;
41 5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	14 import de.intevation.artifacts.ArtifactFactory;
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	15 import de.intevation.artifacts.ArtifactSerializer;
133 2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	16 import de.intevation.artifacts.User;
157 6e6965873a48 Simplified creation of users. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 156 diff changeset	17 import de.intevation.artifacts.UserFactory;
13 0d6badf6af42 Added not yet working backend to artifact database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	18
138 b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	19 import de.intevation.artifacts.common.utils.XMLUtils;
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	20
93 e27cf9c84eb8 Unified imports. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 90 diff changeset	21 import java.sql.Connection;
e27cf9c84eb8 Unified imports. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 90 diff changeset	22 import java.sql.PreparedStatement;
e27cf9c84eb8 Unified imports. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 90 diff changeset	23 import java.sql.ResultSet;
e27cf9c84eb8 Unified imports. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 90 diff changeset	24 import java.sql.SQLException;
170 ac0f8bd97277 Fix parameter propagation of creation time ond collection names. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	25 import java.sql.Timestamp;
93 e27cf9c84eb8 Unified imports. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 90 diff changeset	26 import java.sql.Types;
e27cf9c84eb8 Unified imports. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 90 diff changeset	27
148 101a52d3ad08 Added code to load all users from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 147 diff changeset	28 import java.util.ArrayList;
170 ac0f8bd97277 Fix parameter propagation of creation time ond collection names. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	29 import java.util.Date;
148 101a52d3ad08 Added code to load all users from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 147 diff changeset	30
93 e27cf9c84eb8 Unified imports. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 90 diff changeset	31 import javax.sql.DataSource;
e27cf9c84eb8 Unified imports. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 90 diff changeset	32
17 5a6b6a3debc7 Integrated logging into artifact database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 15 diff changeset	33 import org.apache.log4j.Logger;
5a6b6a3debc7 Integrated logging into artifact database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 15 diff changeset	34
133 2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	35 import org.w3c.dom.Document;
2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	36
2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	37
13 0d6badf6af42 Added not yet working backend to artifact database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	38 /**
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	39 * The backend implements the low level layer used to store artifacts
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	40 * in a SQL database.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	41 *
79 f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	42 * @author <a href="mailto:sascha.teichmann@intevation.de">Sascha L. Teichmann</a>
13 0d6badf6af42 Added not yet working backend to artifact database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	43 */
0d6badf6af42 Added not yet working backend to artifact database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	44 public class Backend
41 5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	45 implements DatabaseCleaner.ArtifactReviver
13 0d6badf6af42 Added not yet working backend to artifact database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	46 {
17 5a6b6a3debc7 Integrated logging into artifact database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 15 diff changeset	47 private static Logger logger = Logger.getLogger(Backend.class);
5a6b6a3debc7 Integrated logging into artifact database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 15 diff changeset	48
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	49 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	50 * The SQL statement to create new artifact id inside the database.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	51 */
14 0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	52 public static final String SQL_NEXT_ID =
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	53 SQL.get("artifacts.id.nextval");
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	54
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	55 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	56 * The SQL statement to insert an artifact into the database.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	57 */
14 0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	58 public static final String SQL_INSERT =
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	59 SQL.get("artifacts.insert");
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	60
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	61 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	62 * The SQL statement to update some columns of an existing
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	63 * artifact in the database.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	64 */
14 0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	65 public static final String SQL_UPDATE =
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	66 SQL.get("artifacts.update");
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	67
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	68 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	69 * The SQL statement to touch the access time of an
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	70 * artifact inside the database.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	71 */
14 0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	72 public static final String SQL_TOUCH =
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	73 SQL.get("artifacts.touch");
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	74
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	75 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	76 * The SQL statement to load an artifact by a given
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	77 * identifier from the database.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	78 */
15 9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	79 public static final String SQL_LOAD_BY_GID =
9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	80 SQL.get("artifacts.select.gid");
9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	81
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	82 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	83 * The SQL statement to get the database id of an artifact
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	84 * identified by the identifier.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	85 */
80 8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	86 public static final String SQL_GET_ID =
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	87 SQL.get("artifacts.get.id");
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	88
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	89 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	90 * The SQL statement to replace the content of an
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	91 * existing artifact inside the database.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	92 */
80 8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	93 public static final String SQL_REPLACE =
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	94 SQL.get("artifacts.replace");
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	95
133 2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	96 // USER SQL
2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	97
2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	98 public static final String SQL_USERS_NEXT_ID =
2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	99 SQL.get("users.id.nextval");
2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	100
2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	101 public static final String SQL_USERS_INSERT =
2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	102 SQL.get("users.insert");
2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	103
144 5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	104 public static final String SQL_USERS_SELECT_ID_BY_GID =
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	105 SQL.get("users.select.id.by.gid");
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	106
133 2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	107 public static final String SQL_USERS_SELECT_GID =
2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	108 SQL.get("users.select.gid");
2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	109
2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	110 public static final String SQL_USERS_DELETE_ID =
2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	111 SQL.get("users.delete.id");
2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	112
2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	113 public static final String SQL_USERS_DELETE_COLLECTIONS =
2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	114 SQL.get("users.delete.collections");
2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	115
148 101a52d3ad08 Added code to load all users from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 147 diff changeset	116 public static final String SQL_USERS_SELECT_ALL =
133 2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	117 SQL.get("users.select.all");
2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	118
144 5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	119 public static final String SQL_USERS_COLLECTIONS =
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	120 SQL.get("users.collections");
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	121
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	122 public static final String SQL_USERS_COLLECTION_IDS =
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	123 SQL.get("users.collection.ids");
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	124
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	125 public static final String SQL_USERS_DELETE_ALL_COLLECTIONS =
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	126 SQL.get("users.delete.all.collections");
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	127
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	128 public static final String SQL_ARTIFACTS_IN_ONLY_COLLECTION_ONLY =
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	129 SQL.get("artifacts.in.one.collection.only");
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	130
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	131 public static final String SQL_OUTDATE_ARTIFACTS_COLLECTION =
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	132 SQL.get("outdate.artifacts.collection");
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	133
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	134 public static final String SQL_OUTDATE_ARTIFACTS_USER =
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	135 SQL.get("outdate.artifacts.user");
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	136
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	137 public static final String SQL_DELETE_USER_COLLECTION_ITEMS =
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	138 SQL.get("delete.user.collection.items");
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	139
159 db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	140 public static final String SQL_COLLECTIONS_NEXT_ID =
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	141 SQL.get("collections.id.nextval");
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	142
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	143 public static final String SQL_COLLECTIONS_INSERT =
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	144 SQL.get("collections.insert");
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	145
167 c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	146 public static final String SQL_COLLECTIONS_SELECT_USER =
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	147 SQL.get("collections.select.user");
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	148
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	149 public static final String SQL_COLLECTIONS_SELECT_ALL =
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	150 SQL.get("collections.select.all");
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	151
170 ac0f8bd97277 Fix parameter propagation of creation time ond collection names. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	152 public static final String SQL_COLLECTIONS_CREATION_TIME =
ac0f8bd97277 Fix parameter propagation of creation time ond collection names. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	153 SQL.get("collection.creation.time");
ac0f8bd97277 Fix parameter propagation of creation time ond collection names. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	154
128 bfa65a812c7a Made the backend singleton. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 100 diff changeset	155 /** The singleton.*/
bfa65a812c7a Made the backend singleton. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 100 diff changeset	156 protected static Backend instance;
bfa65a812c7a Made the backend singleton. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 100 diff changeset	157
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	158 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	159 * The database cleaner. Reference is stored here because
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	160 * the cleaner is woken up if the backend finds an outdated
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	161 * artifact. This artifact should be removed as soon as
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	162 * possible.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	163 */
30 88972c6daa4f Added a cleanup thread which periodically removes Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 27 diff changeset	164 protected DatabaseCleaner cleaner;
88972c6daa4f Added a cleanup thread which periodically removes Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 27 diff changeset	165
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	166 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	167 * To revive an artifact from the bytes coming from the database
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	168 * we need the artifact factory which references the artifact
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	169 * serializer which is able to do the reviving job.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	170 */
41 5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	171 protected FactoryLookup factoryLookup;
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	172
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	173 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	174 * Little helper interface to decouple the ArtifactDatabase
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	175 * from the Backend. A ArtifactDatabase should depend on a
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	176 * Backend but a Backend not from an ArtifactDatabase.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	177 */
41 5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	178 public interface FactoryLookup {
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	179
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	180 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	181 * Returns an ArtifactFactory which is bound to a given name.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	182 * @param factoryName The name of the artifact factory.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	183 * @return The ArtifactFactory bound to the factory name or
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	184 * null if not matching factory is found.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	185 */
41 5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	186 ArtifactFactory getArtifactFactory(String factoryName);
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	187
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	188 } // interface FactoryLookup
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	189
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	190 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	191 * Inner class that brigdes between the persisten form of the
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	192 * artifact and the living one inside the artifact database.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	193 * After the describe(), feed(), advance() and out() operations
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	194 * of the artifact it must be possible to write to modified artifact
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	195 * back into the database.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	196 */
32 c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	197 public final class PersistentArtifact
c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	198 extends Id
14 0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	199 {
41 5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	200 private Artifact artifact;
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	201 private ArtifactSerializer serializer;
84 72e2dd4feb31 Added the time to live of an artifact to the CallContext. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 80 diff changeset	202 private Long ttl;
14 0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	203
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	204 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	205 * Cronstructor to create a persistent artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	206 * @param artifact The living artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	207 * @param serializer The serializer to store the artifact
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	208 * after the operations.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	209 * @param ttl The time to life of the artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	210 * @param id The database id of the artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	211 */
41 5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	212 public PersistentArtifact(
47 4ae4dc99127d Removed trailing whitespace. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 46 diff changeset	213 Artifact artifact,
41 5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	214 ArtifactSerializer serializer,
84 72e2dd4feb31 Added the time to live of an artifact to the CallContext. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 80 diff changeset	215 Long ttl,
41 5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	216 int id
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	217 ) {
32 c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	218 super(id);
41 5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	219 this.artifact = artifact;
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	220 this.serializer = serializer;
84 72e2dd4feb31 Added the time to live of an artifact to the CallContext. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 80 diff changeset	221 this.ttl = ttl;
14 0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	222 }
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	223
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	224 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	225 * Returns the wrapped living artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	226 * @return the living artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	227 */
32 c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	228 public Artifact getArtifact() {
c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	229 return artifact;
14 0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	230 }
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	231
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	232 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	233 * Returns the serialized which is able to write a
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	234 * modified artifact back into the database.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	235 * @return The serializer.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	236 */
41 5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	237 public ArtifactSerializer getSerializer() {
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	238 return serializer;
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	239 }
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	240
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	241 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	242 * The time to life of the artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	243 * @return The time to live.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	244 */
84 72e2dd4feb31 Added the time to live of an artifact to the CallContext. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 80 diff changeset	245 public Long getTTL() {
72e2dd4feb31 Added the time to live of an artifact to the CallContext. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 80 diff changeset	246 return ttl;
72e2dd4feb31 Added the time to live of an artifact to the CallContext. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 80 diff changeset	247 }
72e2dd4feb31 Added the time to live of an artifact to the CallContext. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 80 diff changeset	248
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	249 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	250 * Stores the living artifact back into the database.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	251 */
32 c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	252 public void store() {
38 93edc04f3a10 Added postgresql support. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 34 diff changeset	253 if (logger.isDebugEnabled()) {
93edc04f3a10 Added postgresql support. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 34 diff changeset	254 logger.debug("storing artifact id = " + getId());
93edc04f3a10 Added postgresql support. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 34 diff changeset	255 }
32 c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	256 Backend.this.store(this);
14 0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	257 }
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	258
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	259 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	260 * Only touches the access time of the artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	261 */
32 c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	262 public void touch() {
38 93edc04f3a10 Added postgresql support. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 34 diff changeset	263 if (logger.isDebugEnabled()) {
93edc04f3a10 Added postgresql support. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 34 diff changeset	264 logger.debug("touching artifact id = " + getId());
93edc04f3a10 Added postgresql support. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 34 diff changeset	265 }
32 c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	266 Backend.this.touch(this);
14 0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	267 }
32 c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	268 } // class ArtifactWithId
14 0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	269
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	270 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	271 * Default constructor
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	272 */
13 0d6badf6af42 Added not yet working backend to artifact database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	273 public Backend() {
0d6badf6af42 Added not yet working backend to artifact database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	274 }
0d6badf6af42 Added not yet working backend to artifact database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	275
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	276 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	277 * Constructor to create a backend with a link to the database cleaner.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	278 * @param cleaner The clean which periodically removes outdated
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	279 * artifacts from the database.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	280 */
30 88972c6daa4f Added a cleanup thread which periodically removes Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 27 diff changeset	281 public Backend(DatabaseCleaner cleaner) {
88972c6daa4f Added a cleanup thread which periodically removes Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 27 diff changeset	282 this.cleaner = cleaner;
88972c6daa4f Added a cleanup thread which periodically removes Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 27 diff changeset	283 }
88972c6daa4f Added a cleanup thread which periodically removes Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 27 diff changeset	284
128 bfa65a812c7a Made the backend singleton. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 100 diff changeset	285
bfa65a812c7a Made the backend singleton. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 100 diff changeset	286 /**
bfa65a812c7a Made the backend singleton. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 100 diff changeset	287 * Returns the singleton of this Backend.
bfa65a812c7a Made the backend singleton. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 100 diff changeset	288 *
bfa65a812c7a Made the backend singleton. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 100 diff changeset	289 * @return the backend.
bfa65a812c7a Made the backend singleton. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 100 diff changeset	290 */
bfa65a812c7a Made the backend singleton. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 100 diff changeset	291 public static synchronized Backend getInstance() {
bfa65a812c7a Made the backend singleton. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 100 diff changeset	292 if (instance == null) {
bfa65a812c7a Made the backend singleton. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 100 diff changeset	293 instance = new Backend();
bfa65a812c7a Made the backend singleton. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 100 diff changeset	294 }
bfa65a812c7a Made the backend singleton. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 100 diff changeset	295
bfa65a812c7a Made the backend singleton. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 100 diff changeset	296 return instance;
bfa65a812c7a Made the backend singleton. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 100 diff changeset	297 }
bfa65a812c7a Made the backend singleton. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 100 diff changeset	298
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	299 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	300 * Sets the factory lookup mechanism to decouple ArtifactDatabase
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	301 * and Backend.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	302 * @param factoryLookup
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	303 */
41 5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	304 public void setFactoryLookup(FactoryLookup factoryLookup) {
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	305 this.factoryLookup = factoryLookup;
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	306 }
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	307
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	308 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	309 * Sets the database cleaner explicitly.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	310 * @param cleaner The database cleaner
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	311 */
32 c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	312 public void setCleaner(DatabaseCleaner cleaner) {
c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	313 this.cleaner = cleaner;
c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	314 }
c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	315
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	316 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	317 * Returns a new unique identifier to external identify
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	318 * the artifact across the system. This implementation
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	319 * uses random UUIDs v4 to achieve this target.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	320 * @return the new identifier
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	321 */
32 c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	322 public String newIdentifier() {
c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	323 // TODO: check database for collisions.
79 f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	324 return StringUtils.newUUID();
32 c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	325 }
c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	326
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	327 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	328 * Stores a new artifact into the database.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	329 * @param artifact The artifact to be stored
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	330 * @param factory The factory which build the artifact
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	331 * @param ttl The initial time to life of the artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	332 * @return A persistent wrapper around the living
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	333 * artifact to be able to write modification later.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	334 * @throws Exception Thrown if something went wrong with the
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	335 * storage process.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	336 */
32 c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	337 public PersistentArtifact storeInitially(
41 5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	338 Artifact artifact,
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	339 ArtifactFactory factory,
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	340 Long ttl
47 4ae4dc99127d Removed trailing whitespace. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 46 diff changeset	341 )
32 c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	342 throws Exception
c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	343 {
c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	344 return new PersistentArtifact(
c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	345 artifact,
41 5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	346 factory.getSerializer(),
84 72e2dd4feb31 Added the time to live of an artifact to the CallContext. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 80 diff changeset	347 ttl,
41 5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	348 insertDatabase(artifact, factory, ttl));
32 c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	349 }
47 4ae4dc99127d Removed trailing whitespace. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 46 diff changeset	350
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	351 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	352 * Stores an artifact into database if it does not exist there.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	353 * If it exists there it is only updated.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	354 * @param artifact The artifact to store/update.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	355 * @param factory The factory which created the artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	356 * @param ttl The initial time to live of the artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	357 * @return A persistent version of the artifact to be able
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	358 * to store a modification later.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	359 * @throws Exception Thrown if something went wrong during
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	360 * storing/updating.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	361 */
80 8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	362 public PersistentArtifact storeOrReplace(
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	363 Artifact artifact,
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	364 ArtifactFactory factory,
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	365 Long ttl
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	366 )
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	367 throws Exception
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	368 {
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	369 return new PersistentArtifact(
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	370 artifact,
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	371 factory.getSerializer(),
84 72e2dd4feb31 Added the time to live of an artifact to the CallContext. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 80 diff changeset	372 ttl,
80 8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	373 storeOrReplaceDatabase(artifact, factory, ttl));
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	374 }
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	375
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	376 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	377 * Implementors of this interface are able to process the raw
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	378 * artifact data from the database for loading.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	379 */
79 f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	380 public interface ArtifactLoader {
f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	381
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	382 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	383 * Creates a custom object from the raw artifact database data.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	384 * @param factory The factory that created this artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	385 * @param ttl The current time to life of the artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	386 * @param bytes The raw artifact bytes from the database.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	387 * @param id The database id of the artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	388 * @return The custom object created by the implementation.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	389 */
84 72e2dd4feb31 Added the time to live of an artifact to the CallContext. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 80 diff changeset	390 Object load(ArtifactFactory factory, Long ttl, byte [] bytes, int id);
79 f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	391
f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	392 } // interface ArtifactLoader
f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	393
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	394 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	395 * Fetches an artifact from the database identified by the
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	396 * given identifier.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	397 * @param identifer The identifier of the artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	398 * @return A persistent wrapper around the found artifact
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	399 * to be able to write back a modifaction later or null
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	400 * if no artifact is found for this identifier.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	401 */
32 c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	402 public PersistentArtifact getArtifact(String identifer) {
15 9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	403
79 f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	404 return (PersistentArtifact)loadArtifact(
86 b2e0cb83631c Removed trailing whitespace Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 84 diff changeset	405 identifer,
79 f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	406 new ArtifactLoader() {
f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	407
f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	408 public Object load(
f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	409 ArtifactFactory factory,
84 72e2dd4feb31 Added the time to live of an artifact to the CallContext. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 80 diff changeset	410 Long ttl,
79 f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	411 byte [] bytes,
f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	412 int id
f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	413 ) {
f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	414 ArtifactSerializer serializer = factory.getSerializer();
f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	415
f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	416 Artifact artifact = serializer.fromBytes(bytes);
f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	417
f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	418 return artifact == null
f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	419 ? null
84 72e2dd4feb31 Added the time to live of an artifact to the CallContext. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 80 diff changeset	420 : new PersistentArtifact(artifact, serializer, ttl, id);
79 f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	421 }
f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	422 });
f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	423 }
f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	424
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	425 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	426 * More general loading mechanism for artifacts. The concrete
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	427 * load processing is delegated to the given loader.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	428 * @param identifer The identifier of the artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	429 * @param loader The loader which processes the raw database data.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	430 * @return The object created by the loader.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	431 */
79 f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	432 public Object loadArtifact(String identifer, ArtifactLoader loader) {
f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	433
f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	434 if (!StringUtils.checkUUID(identifer)) {
15 9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	435 return null;
9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	436 }
9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	437
9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	438 Connection connection = null;
9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	439 PreparedStatement stmnt_load = null;
9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	440 ResultSet load_result = null;
9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	441
9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	442 DataSource dataSource = DBConnection.getDataSource();
9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	443 try {
9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	444 connection = dataSource.getConnection();
9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	445 stmnt_load = connection.prepareStatement(SQL_LOAD_BY_GID);
32 c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	446 stmnt_load.setString(1, identifer);
15 9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	447
9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	448 load_result = stmnt_load.executeQuery();
9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	449
9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	450 if (!load_result.next()) {
9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	451 return null;
9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	452 }
9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	453
84 72e2dd4feb31 Added the time to live of an artifact to the CallContext. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 80 diff changeset	454 int id = load_result.getInt(1);
72e2dd4feb31 Added the time to live of an artifact to the CallContext. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 80 diff changeset	455 long ttlX = load_result.getLong(3);
15 9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	456
84 72e2dd4feb31 Added the time to live of an artifact to the CallContext. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 80 diff changeset	457 Long ttl = load_result.wasNull() ? null : Long.valueOf(ttlX);
72e2dd4feb31 Added the time to live of an artifact to the CallContext. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 80 diff changeset	458
72e2dd4feb31 Added the time to live of an artifact to the CallContext. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 80 diff changeset	459 if (ttl != null) { // real time to life
15 9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	460 long last_access = load_result.getTimestamp(2).getTime();
84 72e2dd4feb31 Added the time to live of an artifact to the CallContext. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 80 diff changeset	461 if (last_access + ttlX < System.currentTimeMillis()) {
15 9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	462 artifactOutdated(id);
9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	463 return null;
9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	464 }
9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	465 }
9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	466
41 5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	467 String factoryName = load_result.getString(4);
15 9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	468
41 5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	469 if (factoryLookup == null) {
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	470 logger.error("factory lookup == null");
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	471 return null;
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	472 }
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	473
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	474 ArtifactFactory factory = factoryLookup
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	475 .getArtifactFactory(factoryName);
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	476
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	477 if (factory == null) {
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	478 logger.error("factory '" + factoryName + "' not found");
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	479 return null;
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	480 }
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	481
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	482 byte [] bytes = load_result.getBytes(5);
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	483
84 72e2dd4feb31 Added the time to live of an artifact to the CallContext. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 80 diff changeset	484 return loader.load(factory, ttl, bytes, id);
15 9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	485 }
9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	486 catch (SQLException sqle) {
17 5a6b6a3debc7 Integrated logging into artifact database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 15 diff changeset	487 logger.error(sqle.getLocalizedMessage(), sqle);
15 9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	488 }
9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	489 finally {
9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	490 if (load_result != null) {
9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	491 try { load_result.close(); }
9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	492 catch (SQLException sqle) {}
9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	493 }
9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	494 if (stmnt_load != null) {
9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	495 try { load_result.close(); }
9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	496 catch (SQLException sqle) {}
9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	497 }
9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	498 if (connection != null) {
47 4ae4dc99127d Removed trailing whitespace. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 46 diff changeset	499 try { connection.close(); }
15 9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	500 catch (SQLException sqle) {}
9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	501 }
9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	502 }
9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	503 return null;
9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	504 }
9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	505
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	506 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	507 * Called if the load mechanism found an outdated artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	508 * It wakes up the database cleaner.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	509 * @param id The id of the outdated artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	510 */
15 9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	511 protected void artifactOutdated(int id) {
79 f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	512 if (logger.isDebugEnabled()) {
f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	513 logger.info("artifactOutdated: id = " + id);
f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	514 }
30 88972c6daa4f Added a cleanup thread which periodically removes Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 27 diff changeset	515 if (cleaner != null) {
88972c6daa4f Added a cleanup thread which periodically removes Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 27 diff changeset	516 cleaner.wakeup();
88972c6daa4f Added a cleanup thread which periodically removes Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 27 diff changeset	517 }
15 9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	518 }
9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	519
41 5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	520 public Artifact reviveArtifact(String factoryName, byte [] bytes) {
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	521 if (factoryLookup == null) {
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	522 logger.error("reviveArtifact: factory lookup == null");
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	523 return null;
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	524 }
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	525 ArtifactFactory factory = factoryLookup
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	526 .getArtifactFactory(factoryName);
32 c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	527
41 5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	528 if (factory == null) {
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	529 logger.error(
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	530 "reviveArtifact: no factory '" + factoryName + "' found");
41 5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	531 return null;
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	532 }
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	533
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	534 ArtifactSerializer serializer = factory.getSerializer();
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	535
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	536 return serializer.fromBytes(bytes);
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	537 }
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	538
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	539 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	540 * Internal method to store/replace an artifact inside the database.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	541 * If an artifact with the given identifier does not exists it is
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	542 * created else only the content data is updated.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	543 * @param artifact The artifact to be store/update inside the database.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	544 * @param factory The factory that created the artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	545 * @param ttl The initial time to life of the artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	546 * @return The database id of the stored/updated artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	547 */
80 8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	548 protected int storeOrReplaceDatabase(
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	549 Artifact artifact,
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	550 ArtifactFactory factory,
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	551 Long ttl
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	552 ) {
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	553 String uuid = artifact.identifier();
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	554
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	555 if (!StringUtils.checkUUID(uuid)) {
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	556 throw new RuntimeException("No valid UUID");
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	557 }
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	558
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	559 Connection connection = null;
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	560 PreparedStatement stmnt = null;
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	561 ResultSet result = null;
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	562
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	563 DataSource dataSource = DBConnection.getDataSource();
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	564 try {
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	565 connection = dataSource.getConnection();
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	566 try {
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	567 connection.setAutoCommit(false);
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	568
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	569 stmnt = connection.prepareStatement(SQL_GET_ID);
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	570
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	571 stmnt.setString(1, uuid);
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	572 result = stmnt.executeQuery();
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	573
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	574 Integer ID = result.next()
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	575 ? Integer.valueOf(result.getInt(1))
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	576 : null;
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	577
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	578 result.close(); result = null;
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	579 stmnt.close(); stmnt = null;
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	580
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	581 if (ID != null) { // already in database
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	582 int id = ID.intValue();
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	583
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	584 stmnt = connection.prepareStatement(SQL_REPLACE);
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	585
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	586 if (ttl == null) {
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	587 stmnt.setNull(1, Types.BIGINT);
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	588 }
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	589 else {
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	590 stmnt.setLong(1, ttl.longValue());
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	591 }
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	592
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	593 stmnt.setString(2, factory.getName());
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	594 stmnt.setBytes(
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	595 3,
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	596 factory.getSerializer().toBytes(artifact));
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	597 stmnt.setInt(4, id);
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	598
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	599 stmnt.execute();
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	600 connection.commit();
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	601 return id;
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	602 }
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	603
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	604 stmnt = connection.prepareStatement(SQL_NEXT_ID);
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	605 result = stmnt.executeQuery();
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	606
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	607 if (!result.next()) {
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	608 throw new RuntimeException("No id generated");
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	609 }
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	610
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	611 int id = result.getInt(1);
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	612
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	613 result.close(); result = null;
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	614 stmnt.close(); stmnt = null;
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	615
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	616 stmnt = connection.prepareStatement(SQL_INSERT);
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	617
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	618 stmnt.setInt(1, id);
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	619 stmnt.setString(2, uuid);
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	620 if (ttl == null) {
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	621 stmnt.setNull(3, Types.BIGINT);
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	622 }
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	623 else {
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	624 stmnt.setLong(3, ttl.longValue());
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	625 }
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	626
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	627 stmnt.setString(4, factory.getName());
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	628
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	629 stmnt.setBytes(
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	630 5,
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	631 factory.getSerializer().toBytes(artifact));
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	632
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	633 stmnt.execute();
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	634 connection.commit();
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	635 return id;
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	636 }
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	637 catch (SQLException sqle) {
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	638 connection.rollback();
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	639 throw sqle;
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	640 }
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	641 }
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	642 catch (SQLException sqle) {
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	643 logger.error(sqle.getLocalizedMessage(), sqle);
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	644 }
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	645 finally {
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	646 if (result != null) {
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	647 try { result.close(); }
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	648 catch (SQLException sqle) {}
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	649 }
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	650 if (stmnt != null) {
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	651 try { stmnt.close(); }
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	652 catch (SQLException sqle) {}
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	653 }
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	654 if (connection != null) {
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	655 try { connection.close(); }
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	656 catch (SQLException sqle) {}
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	657 }
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	658 }
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	659 throw new RuntimeException("failed insert artifact into database");
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	660 }
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	661
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	662 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	663 * Internal method to store an artifact inside the database.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	664 * @param artifact The artifact to be stored.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	665 * @param factory The factory which created the artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	666 * @param ttl The initial time to live of the artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	667 * @return The database id of the stored artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	668 */
41 5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	669 protected int insertDatabase(
47 4ae4dc99127d Removed trailing whitespace. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 46 diff changeset	670 Artifact artifact,
41 5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	671 ArtifactFactory factory,
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	672 Long ttl
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	673 ) {
32 c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	674 String uuid = artifact.identifier();
c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	675
14 0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	676 Connection connection = null;
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	677 PreparedStatement stmnt_next_id = null;
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	678 PreparedStatement stmnt_insert = null;
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	679 ResultSet res_id = null;
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	680
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	681 DataSource dataSource = DBConnection.getDataSource();
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	682 try {
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	683 connection = dataSource.getConnection();
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	684 try {
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	685 connection.setAutoCommit(false);
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	686
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	687 stmnt_next_id = connection.prepareStatement(SQL_NEXT_ID);
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	688 stmnt_insert = connection.prepareStatement(SQL_INSERT);
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	689
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	690 res_id = stmnt_next_id.executeQuery();
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	691
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	692 if (!res_id.next()) {
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	693 throw new RuntimeException("No id generated");
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	694 }
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	695
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	696 int id = res_id.getInt(1);
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	697
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	698 stmnt_insert.setInt(1, id);
32 c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	699 stmnt_insert.setString(2, uuid);
14 0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	700 if (ttl == null) {
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	701 stmnt_insert.setNull(3, Types.BIGINT);
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	702 }
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	703 else {
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	704 stmnt_insert.setLong(3, ttl.longValue());
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	705 }
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	706
41 5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	707 stmnt_insert.setString(4, factory.getName());
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	708
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	709 stmnt_insert.setBytes(
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	710 5,
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	711 factory.getSerializer().toBytes(artifact));
32 c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	712
14 0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	713 stmnt_insert.execute();
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	714
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	715 connection.commit();
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	716
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	717 return id;
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	718 }
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	719 catch (SQLException sqle) {
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	720 connection.rollback();
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	721 throw sqle;
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	722 }
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	723 }
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	724 catch (SQLException sqle) {
17 5a6b6a3debc7 Integrated logging into artifact database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 15 diff changeset	725 logger.error(sqle.getLocalizedMessage(), sqle);
14 0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	726 }
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	727 finally {
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	728 if (res_id != null) {
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	729 try { res_id.close(); }
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	730 catch (SQLException sqle) {}
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	731 }
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	732 if (stmnt_insert != null) {
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	733 try { stmnt_insert.close(); }
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	734 catch (SQLException sqle) {}
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	735 }
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	736 if (stmnt_next_id != null) {
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	737 try { stmnt_next_id.close(); }
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	738 catch (SQLException sqle) {}
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	739 }
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	740 if (connection != null) {
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	741 try { connection.close(); }
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	742 catch (SQLException sqle) {}
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	743 }
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	744 }
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	745 throw new RuntimeException("failed insert artifact into database");
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	746 }
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	747
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	748 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	749 * Touches the access timestamp of a given artifact to prevent
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	750 * that it will be removed from the database by the database cleaner.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	751 * @param artifact The persistent wrapper around the living artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	752 */
32 c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	753 public void touch(PersistentArtifact artifact) {
26 83a059c204f8 Connected /create with artifact db. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 24 diff changeset	754
14 0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	755 try {
26 83a059c204f8 Connected /create with artifact db. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 24 diff changeset	756 Connection connection = null;
83a059c204f8 Connected /create with artifact db. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 24 diff changeset	757 PreparedStatement stmnt_touch = null;
83a059c204f8 Connected /create with artifact db. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 24 diff changeset	758 DataSource dataSource = DBConnection.getDataSource();
14 0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	759 try {
26 83a059c204f8 Connected /create with artifact db. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 24 diff changeset	760 connection = dataSource.getConnection();
83a059c204f8 Connected /create with artifact db. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 24 diff changeset	761 try {
83a059c204f8 Connected /create with artifact db. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 24 diff changeset	762 connection.setAutoCommit(false);
41 5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	763 stmnt_touch = connection.prepareStatement(SQL_TOUCH);
32 c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	764 stmnt_touch.setInt(1, artifact.getId());
26 83a059c204f8 Connected /create with artifact db. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 24 diff changeset	765 stmnt_touch.execute();
83a059c204f8 Connected /create with artifact db. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 24 diff changeset	766 connection.commit();
83a059c204f8 Connected /create with artifact db. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 24 diff changeset	767 }
83a059c204f8 Connected /create with artifact db. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 24 diff changeset	768 catch (SQLException sqle) {
83a059c204f8 Connected /create with artifact db. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 24 diff changeset	769 connection.rollback();
83a059c204f8 Connected /create with artifact db. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 24 diff changeset	770 }
14 0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	771 }
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	772 catch (SQLException sqle) {
26 83a059c204f8 Connected /create with artifact db. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 24 diff changeset	773 logger.error(sqle.getLocalizedMessage(), sqle);
83a059c204f8 Connected /create with artifact db. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 24 diff changeset	774 }
83a059c204f8 Connected /create with artifact db. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 24 diff changeset	775 finally {
83a059c204f8 Connected /create with artifact db. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 24 diff changeset	776 if (stmnt_touch != null) {
83a059c204f8 Connected /create with artifact db. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 24 diff changeset	777 try { stmnt_touch.close(); }
83a059c204f8 Connected /create with artifact db. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 24 diff changeset	778 catch (SQLException sqle) {}
83a059c204f8 Connected /create with artifact db. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 24 diff changeset	779 }
83a059c204f8 Connected /create with artifact db. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 24 diff changeset	780 if (connection != null) {
83a059c204f8 Connected /create with artifact db. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 24 diff changeset	781 try { connection.close(); }
83a059c204f8 Connected /create with artifact db. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 24 diff changeset	782 catch (SQLException sqle) {}
83a059c204f8 Connected /create with artifact db. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 24 diff changeset	783 }
14 0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	784 }
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	785 }
26 83a059c204f8 Connected /create with artifact db. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 24 diff changeset	786 catch (Exception e) {
83a059c204f8 Connected /create with artifact db. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 24 diff changeset	787 logger.error(e.getLocalizedMessage(), e);
14 0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	788 }
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	789 }
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	790
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	791 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	792 * Writes modification of an artifact back to the database.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	793 * @param artifact The persistent wrapper around a living
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	794 * artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	795 */
32 c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	796 public void store(PersistentArtifact artifact) {
26 83a059c204f8 Connected /create with artifact db. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 24 diff changeset	797
14 0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	798 try {
26 83a059c204f8 Connected /create with artifact db. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 24 diff changeset	799 Connection connection = null;
83a059c204f8 Connected /create with artifact db. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 24 diff changeset	800 PreparedStatement stmnt_update = null;
83a059c204f8 Connected /create with artifact db. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 24 diff changeset	801 DataSource dataSource = DBConnection.getDataSource();
14 0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	802 try {
26 83a059c204f8 Connected /create with artifact db. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 24 diff changeset	803 connection = dataSource.getConnection();
83a059c204f8 Connected /create with artifact db. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 24 diff changeset	804 try {
83a059c204f8 Connected /create with artifact db. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 24 diff changeset	805 connection.setAutoCommit(false);
83a059c204f8 Connected /create with artifact db. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 24 diff changeset	806 stmnt_update = connection.prepareStatement(SQL_UPDATE);
32 c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	807 stmnt_update.setInt(2, artifact.getId());
26 83a059c204f8 Connected /create with artifact db. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 24 diff changeset	808
41 5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	809 byte [] bytes = artifact
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	810 .getSerializer()
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	811 .toBytes(artifact.getArtifact());
26 83a059c204f8 Connected /create with artifact db. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 24 diff changeset	812
83a059c204f8 Connected /create with artifact db. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 24 diff changeset	813 stmnt_update.setBytes(1, bytes);
83a059c204f8 Connected /create with artifact db. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 24 diff changeset	814 stmnt_update.execute();
83a059c204f8 Connected /create with artifact db. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 24 diff changeset	815 connection.commit();
83a059c204f8 Connected /create with artifact db. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 24 diff changeset	816 }
83a059c204f8 Connected /create with artifact db. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 24 diff changeset	817 catch (SQLException sqle) {
83a059c204f8 Connected /create with artifact db. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 24 diff changeset	818 connection.rollback();
83a059c204f8 Connected /create with artifact db. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 24 diff changeset	819 }
14 0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	820 }
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	821 catch (SQLException sqle) {
26 83a059c204f8 Connected /create with artifact db. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 24 diff changeset	822 logger.error(sqle.getLocalizedMessage(), sqle);
83a059c204f8 Connected /create with artifact db. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 24 diff changeset	823 }
83a059c204f8 Connected /create with artifact db. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 24 diff changeset	824 finally {
83a059c204f8 Connected /create with artifact db. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 24 diff changeset	825 if (stmnt_update != null) {
83a059c204f8 Connected /create with artifact db. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 24 diff changeset	826 try { stmnt_update.close(); }
83a059c204f8 Connected /create with artifact db. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 24 diff changeset	827 catch (SQLException sqle) {}
83a059c204f8 Connected /create with artifact db. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 24 diff changeset	828 }
83a059c204f8 Connected /create with artifact db. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 24 diff changeset	829 if (connection != null) {
83a059c204f8 Connected /create with artifact db. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 24 diff changeset	830 try { connection.close(); }
83a059c204f8 Connected /create with artifact db. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 24 diff changeset	831 catch (SQLException sqle) {}
83a059c204f8 Connected /create with artifact db. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 24 diff changeset	832 }
14 0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	833 }
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	834 }
26 83a059c204f8 Connected /create with artifact db. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 24 diff changeset	835 catch (Exception e) {
83a059c204f8 Connected /create with artifact db. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 24 diff changeset	836 logger.error(e.getLocalizedMessage(), e);
14 0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	837 }
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	838 }
133 2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	839
2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	840 public User createUser(
157 6e6965873a48 Simplified creation of users. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 156 diff changeset	841 String name,
6e6965873a48 Simplified creation of users. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 156 diff changeset	842 Document role,
6e6965873a48 Simplified creation of users. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 156 diff changeset	843 UserFactory factory,
6e6965873a48 Simplified creation of users. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 156 diff changeset	844 Object context
133 2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	845 ) {
138 b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	846 Connection connection = null;
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	847 PreparedStatement stmnt_next_id = null;
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	848 PreparedStatement stmnt_insert = null;
145 c0d025df722d Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 144 diff changeset	849 ResultSet result = null;
138 b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	850
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	851 String identifier = newIdentifier();
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	852
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	853 DataSource dataSource = DBConnection.getDataSource();
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	854 try {
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	855 connection = dataSource.getConnection();
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	856 try {
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	857 connection.setAutoCommit(false);
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	858
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	859 stmnt_next_id = connection.prepareStatement(SQL_USERS_NEXT_ID);
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	860 stmnt_insert = connection.prepareStatement(SQL_USERS_INSERT);
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	861
145 c0d025df722d Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 144 diff changeset	862 result = stmnt_next_id.executeQuery();
138 b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	863
146 967dc552455d Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 145 diff changeset	864 if (!result.next()) {
138 b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	865 throw new RuntimeException("No id generated");
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	866 }
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	867
145 c0d025df722d Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 144 diff changeset	868 int id = result.getInt(1);
138 b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	869
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	870 stmnt_insert.setInt(1, id);
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	871 stmnt_insert.setString(2, identifier);
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	872 stmnt_insert.setString(3, name);
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	873
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	874 byte [] roleData = role == null
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	875 ? null
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	876 : XMLUtils.toByteArray(role);
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	877
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	878 if (roleData == null) {
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	879 stmnt_insert.setNull(4, Types.BIGINT);
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	880 }
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	881 else {
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	882 stmnt_insert.setBytes(4, roleData);
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	883 }
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	884
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	885 stmnt_insert.execute();
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	886
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	887 connection.commit();
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	888
157 6e6965873a48 Simplified creation of users. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 156 diff changeset	889 return factory.createUser(identifier, name, role, context);
138 b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	890 }
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	891 catch (SQLException sqle) {
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	892 connection.rollback();
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	893 throw sqle;
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	894 }
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	895 }
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	896 catch (SQLException sqle) {
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	897 logger.error(sqle.getLocalizedMessage(), sqle);
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	898 }
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	899 finally {
145 c0d025df722d Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 144 diff changeset	900 if (result != null) {
c0d025df722d Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 144 diff changeset	901 try { result.close(); }
138 b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	902 catch (SQLException sqle) {}
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	903 }
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	904 if (stmnt_insert != null) {
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	905 try { stmnt_insert.close(); }
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	906 catch (SQLException sqle) {}
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	907 }
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	908 if (stmnt_next_id != null) {
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	909 try { stmnt_next_id.close(); }
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	910 catch (SQLException sqle) {}
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	911 }
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	912 if (connection != null) {
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	913 try { connection.close(); }
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	914 catch (SQLException sqle) {}
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	915 }
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	916 }
133 2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	917 return null;
2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	918 }
2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	919
154 1a72f08ce8d7 Propagate delete user errors correctly. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 153 diff changeset	920 public boolean deleteUser(String identifier) {
144 5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	921
147 9a64e0c1c737 Added code to load user from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 146 diff changeset	922 Connection conn = null;
9a64e0c1c737 Added code to load user from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 146 diff changeset	923 ResultSet result = null;
9a64e0c1c737 Added code to load user from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 146 diff changeset	924 PreparedStatement stmnt = null;
144 5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	925
147 9a64e0c1c737 Added code to load user from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 146 diff changeset	926 if (!StringUtils.checkUUID(identifier)) {
154 1a72f08ce8d7 Propagate delete user errors correctly. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 153 diff changeset	927 return false;
147 9a64e0c1c737 Added code to load user from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 146 diff changeset	928 }
9a64e0c1c737 Added code to load user from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 146 diff changeset	929
144 5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	930 DataSource dataSource = DBConnection.getDataSource();
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	931 try {
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	932 conn = dataSource.getConnection();
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	933 try {
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	934 conn.setAutoCommit(false);
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	935
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	936 // fetch user id
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	937 stmnt = conn.prepareStatement(SQL_USERS_SELECT_ID_BY_GID);
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	938
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	939 stmnt.setString(1, identifier);
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	940 result = stmnt.executeQuery();
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	941
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	942 if (!result.next()) { // No such user
154 1a72f08ce8d7 Propagate delete user errors correctly. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 153 diff changeset	943 return false;
144 5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	944 }
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	945
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	946 int id = result.getInt(1);
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	947
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	948 result.close(); result = null;
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	949 stmnt.close(); stmnt = null;
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	950
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	951 // outdate the artifacts exclusively used by the user
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	952
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	953 stmnt = conn.prepareStatement(SQL_OUTDATE_ARTIFACTS_USER);
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	954 stmnt.setInt(1, id);
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	955 stmnt.setInt(2, id);
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	956 stmnt.execute();
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	957
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	958 stmnt.close(); stmnt = null;
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	959
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	960 // delete the collection items of the user
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	961
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	962 stmnt = conn.prepareStatement(SQL_DELETE_USER_COLLECTION_ITEMS);
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	963 stmnt.setInt(1, id);
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	964 stmnt.execute();
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	965 stmnt.close(); stmnt = null;
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	966
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	967 // delete the collections of the user
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	968
151 3d70de111af1 Bugfix: Replaced wrong SQL statements with the correct ones. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 148 diff changeset	969 stmnt = conn.prepareStatement(SQL_USERS_DELETE_COLLECTIONS);
144 5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	970 stmnt.setInt(1, id);
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	971 stmnt.execute();
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	972 stmnt.close(); stmnt = null;
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	973
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	974 // delete the user
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	975
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	976 stmnt = conn.prepareStatement(SQL_USERS_DELETE_ID);
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	977 stmnt.setInt(1, id);
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	978 stmnt.execute();
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	979
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	980 conn.commit();
154 1a72f08ce8d7 Propagate delete user errors correctly. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 153 diff changeset	981
1a72f08ce8d7 Propagate delete user errors correctly. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 153 diff changeset	982 return true;
144 5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	983 }
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	984 catch (SQLException sqle) {
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	985 conn.rollback();
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	986 throw sqle;
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	987 }
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	988 }
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	989 catch (SQLException sqle) {
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	990 logger.error(sqle.getLocalizedMessage(), sqle);
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	991 }
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	992 finally {
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	993 if (result != null) {
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	994 try { result.close(); }
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	995 catch (SQLException sqle) {}
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	996 }
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	997 if (stmnt != null) {
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	998 try { stmnt.close(); }
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	999 catch (SQLException sqle) {}
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	1000 }
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	1001 if (conn != null) {
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	1002 try { conn.close(); }
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	1003 catch (SQLException sqle) {}
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	1004 }
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	1005 }
154 1a72f08ce8d7 Propagate delete user errors correctly. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 153 diff changeset	1006
1a72f08ce8d7 Propagate delete user errors correctly. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 153 diff changeset	1007 return false;
133 2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	1008 }
2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	1009
157 6e6965873a48 Simplified creation of users. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 156 diff changeset	1010 public User getUser(
6e6965873a48 Simplified creation of users. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 156 diff changeset	1011 String identifier,
6e6965873a48 Simplified creation of users. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 156 diff changeset	1012 UserFactory factory,
6e6965873a48 Simplified creation of users. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 156 diff changeset	1013 Object context
6e6965873a48 Simplified creation of users. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 156 diff changeset	1014 ) {
147 9a64e0c1c737 Added code to load user from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 146 diff changeset	1015 Connection conn = null;
9a64e0c1c737 Added code to load user from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 146 diff changeset	1016 ResultSet result = null;
9a64e0c1c737 Added code to load user from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 146 diff changeset	1017 PreparedStatement stmnt = null;
9a64e0c1c737 Added code to load user from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 146 diff changeset	1018
9a64e0c1c737 Added code to load user from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 146 diff changeset	1019 if (!StringUtils.checkUUID(identifier)) {
9a64e0c1c737 Added code to load user from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 146 diff changeset	1020 logger.debug("Invalid UUID: '" + identifier + "'");
9a64e0c1c737 Added code to load user from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 146 diff changeset	1021 return null;
9a64e0c1c737 Added code to load user from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 146 diff changeset	1022 }
9a64e0c1c737 Added code to load user from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 146 diff changeset	1023
9a64e0c1c737 Added code to load user from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 146 diff changeset	1024 DataSource dataSource = DBConnection.getDataSource();
9a64e0c1c737 Added code to load user from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 146 diff changeset	1025 try {
9a64e0c1c737 Added code to load user from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 146 diff changeset	1026 conn = dataSource.getConnection();
151 3d70de111af1 Bugfix: Replaced wrong SQL statements with the correct ones. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 148 diff changeset	1027 stmnt = conn.prepareStatement(SQL_USERS_SELECT_GID);
147 9a64e0c1c737 Added code to load user from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 146 diff changeset	1028 stmnt.setString(1, identifier);
9a64e0c1c737 Added code to load user from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 146 diff changeset	1029 result = stmnt.executeQuery();
9a64e0c1c737 Added code to load user from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 146 diff changeset	1030 if (!result.next()) { // no such user
9a64e0c1c737 Added code to load user from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 146 diff changeset	1031 return null;
9a64e0c1c737 Added code to load user from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 146 diff changeset	1032 }
9a64e0c1c737 Added code to load user from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 146 diff changeset	1033 // omit id
9a64e0c1c737 Added code to load user from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 146 diff changeset	1034 String name = result.getString(2);
9a64e0c1c737 Added code to load user from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 146 diff changeset	1035 byte [] roleData = result.getBytes(3);
9a64e0c1c737 Added code to load user from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 146 diff changeset	1036
9a64e0c1c737 Added code to load user from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 146 diff changeset	1037 Document role = XMLUtils.fromByteArray(roleData);
9a64e0c1c737 Added code to load user from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 146 diff changeset	1038
157 6e6965873a48 Simplified creation of users. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 156 diff changeset	1039 return factory.createUser(identifier, name, role, context);
147 9a64e0c1c737 Added code to load user from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 146 diff changeset	1040 }
9a64e0c1c737 Added code to load user from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 146 diff changeset	1041 catch (SQLException sqle) {
9a64e0c1c737 Added code to load user from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 146 diff changeset	1042 logger.error(sqle.getLocalizedMessage(), sqle);
9a64e0c1c737 Added code to load user from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 146 diff changeset	1043 }
9a64e0c1c737 Added code to load user from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 146 diff changeset	1044 finally {
9a64e0c1c737 Added code to load user from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 146 diff changeset	1045 if (result != null) {
9a64e0c1c737 Added code to load user from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 146 diff changeset	1046 try { result.close(); }
9a64e0c1c737 Added code to load user from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 146 diff changeset	1047 catch (SQLException sqle) {}
9a64e0c1c737 Added code to load user from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 146 diff changeset	1048 }
9a64e0c1c737 Added code to load user from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 146 diff changeset	1049 if (stmnt != null) {
9a64e0c1c737 Added code to load user from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 146 diff changeset	1050 try { stmnt.close(); }
9a64e0c1c737 Added code to load user from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 146 diff changeset	1051 catch (SQLException sqle) {}
9a64e0c1c737 Added code to load user from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 146 diff changeset	1052 }
9a64e0c1c737 Added code to load user from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 146 diff changeset	1053 if (conn != null) {
9a64e0c1c737 Added code to load user from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 146 diff changeset	1054 try { conn.close(); }
9a64e0c1c737 Added code to load user from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 146 diff changeset	1055 catch (SQLException sqle) {}
9a64e0c1c737 Added code to load user from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 146 diff changeset	1056 }
9a64e0c1c737 Added code to load user from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 146 diff changeset	1057 }
9a64e0c1c737 Added code to load user from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 146 diff changeset	1058
133 2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	1059 return null;
2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	1060 }
2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	1061
157 6e6965873a48 Simplified creation of users. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 156 diff changeset	1062 public User [] getUsers(UserFactory factory, Object context) {
148 101a52d3ad08 Added code to load all users from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 147 diff changeset	1063 Connection conn = null;
101a52d3ad08 Added code to load all users from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 147 diff changeset	1064 ResultSet result = null;
101a52d3ad08 Added code to load all users from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 147 diff changeset	1065 PreparedStatement stmnt = null;
101a52d3ad08 Added code to load all users from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 147 diff changeset	1066
101a52d3ad08 Added code to load all users from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 147 diff changeset	1067 DataSource dataSource = DBConnection.getDataSource();
101a52d3ad08 Added code to load all users from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 147 diff changeset	1068 try {
101a52d3ad08 Added code to load all users from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 147 diff changeset	1069 conn = dataSource.getConnection();
101a52d3ad08 Added code to load all users from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 147 diff changeset	1070 stmnt = conn.prepareStatement(SQL_USERS_SELECT_ALL);
101a52d3ad08 Added code to load all users from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 147 diff changeset	1071 result = stmnt.executeQuery();
101a52d3ad08 Added code to load all users from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 147 diff changeset	1072
101a52d3ad08 Added code to load all users from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 147 diff changeset	1073 ArrayList<User> users = new ArrayList<User>();
101a52d3ad08 Added code to load all users from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 147 diff changeset	1074
101a52d3ad08 Added code to load all users from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 147 diff changeset	1075 while (result.next()) {
101a52d3ad08 Added code to load all users from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 147 diff changeset	1076 // omit id
101a52d3ad08 Added code to load all users from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 147 diff changeset	1077 String identifier = result.getString(2);
101a52d3ad08 Added code to load all users from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 147 diff changeset	1078 String name = result.getString(3);
101a52d3ad08 Added code to load all users from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 147 diff changeset	1079 byte [] roleData = result.getBytes(4);
101a52d3ad08 Added code to load all users from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 147 diff changeset	1080
101a52d3ad08 Added code to load all users from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 147 diff changeset	1081 Document role = XMLUtils.fromByteArray(roleData);
157 6e6965873a48 Simplified creation of users. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 156 diff changeset	1082 User user =
6e6965873a48 Simplified creation of users. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 156 diff changeset	1083 factory.createUser(identifier, name, role, context);
148 101a52d3ad08 Added code to load all users from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 147 diff changeset	1084 users.add(user);
101a52d3ad08 Added code to load all users from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 147 diff changeset	1085 }
101a52d3ad08 Added code to load all users from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 147 diff changeset	1086
101a52d3ad08 Added code to load all users from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 147 diff changeset	1087 return users.toArray(new User[users.size()]);
101a52d3ad08 Added code to load all users from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 147 diff changeset	1088 }
101a52d3ad08 Added code to load all users from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 147 diff changeset	1089 catch (SQLException sqle) {
101a52d3ad08 Added code to load all users from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 147 diff changeset	1090 logger.error(sqle.getLocalizedMessage(), sqle);
101a52d3ad08 Added code to load all users from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 147 diff changeset	1091 }
101a52d3ad08 Added code to load all users from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 147 diff changeset	1092 finally {
101a52d3ad08 Added code to load all users from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 147 diff changeset	1093 if (result != null) {
101a52d3ad08 Added code to load all users from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 147 diff changeset	1094 try { result.close(); }
101a52d3ad08 Added code to load all users from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 147 diff changeset	1095 catch (SQLException sqle) {}
101a52d3ad08 Added code to load all users from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 147 diff changeset	1096 }
101a52d3ad08 Added code to load all users from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 147 diff changeset	1097 if (stmnt != null) {
101a52d3ad08 Added code to load all users from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 147 diff changeset	1098 try { stmnt.close(); }
101a52d3ad08 Added code to load all users from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 147 diff changeset	1099 catch (SQLException sqle) {}
101a52d3ad08 Added code to load all users from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 147 diff changeset	1100 }
101a52d3ad08 Added code to load all users from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 147 diff changeset	1101 if (conn != null) {
101a52d3ad08 Added code to load all users from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 147 diff changeset	1102 try { conn.close(); }
101a52d3ad08 Added code to load all users from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 147 diff changeset	1103 catch (SQLException sqle) {}
101a52d3ad08 Added code to load all users from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 147 diff changeset	1104 }
101a52d3ad08 Added code to load all users from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 147 diff changeset	1105 }
101a52d3ad08 Added code to load all users from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 147 diff changeset	1106
133 2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	1107 return null;
2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	1108 }
156 a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1109
159 db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1110 public ArtifactCollection createCollection(
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1111 String ownerIdentifier,
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1112 String name,
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1113 ArtifactCollectionFactory factory,
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1114 Document data,
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1115 Object context
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1116 ) {
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1117 if (name == null) {
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1118 logger.debug("Name is null");
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1119 return null;
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1120 }
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1121
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1122 if (!StringUtils.checkUUID(ownerIdentifier)) {
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1123 logger.debug("Invalid owner id: '" + ownerIdentifier + "'");
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1124 return null;
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1125 }
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1126
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1127 Connection conn = null;
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1128 ResultSet result = null;
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1129 PreparedStatement stmnt = null;
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1130
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1131 DataSource dataSource = DBConnection.getDataSource();
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1132 try {
161 e4a1562dfc21 Bugfixed the collection creation in the Backend. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 159 diff changeset	1133 conn = dataSource.getConnection();
159 db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1134 conn.setAutoCommit(false);
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1135 try {
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1136 // fetch owner id
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1137 stmnt = conn.prepareStatement(SQL_USERS_SELECT_ID_BY_GID);
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1138 stmnt.setString(1, ownerIdentifier);
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1139 result = stmnt.executeQuery();
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1140
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1141 if (!result.next()) { // no such user
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1142 return null;
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1143 }
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1144
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1145 int ownerId = result.getInt(1);
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1146 result.close(); result = null;
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1147 stmnt.close(); stmnt = null;
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1148
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1149 // fetch new collection seq number.
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1150 stmnt = conn.prepareStatement(SQL_COLLECTIONS_NEXT_ID);
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1151 result = stmnt.executeQuery();
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1152
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1153 if (!result.next()) { // no identifier generated
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1154 return null;
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1155 }
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1156
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1157 int id = result.getInt(1);
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1158 result.close(); result = null;
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1159 stmnt.close(); stmnt = null;
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1160
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1161 String identifier = newIdentifier();
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1162
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1163 stmnt = conn.prepareStatement(SQL_COLLECTIONS_INSERT);
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1164
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1165 stmnt.setInt(1, id);
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1166 stmnt.setString(2, identifier);
161 e4a1562dfc21 Bugfixed the collection creation in the Backend. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 159 diff changeset	1167 stmnt.setString(3, name);
e4a1562dfc21 Bugfixed the collection creation in the Backend. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 159 diff changeset	1168 stmnt.setInt(4, ownerId);
159 db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1169
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1170 // XXX: A bit odd: we don't have a collection, yet.
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1171 Long ttl = factory.timeToLiveUntouched(null, context);
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1172
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1173 if (ttl == null) {
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1174 stmnt.setNull(5, Types.BIGINT);
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1175 }
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1176 else {
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1177 stmnt.setLong(5, ttl);
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1178 }
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1179
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1180 stmnt.execute();
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1181 conn.commit();
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1182
170 ac0f8bd97277 Fix parameter propagation of creation time ond collection names. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	1183 stmnt.close(); stmnt = null;
ac0f8bd97277 Fix parameter propagation of creation time ond collection names. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	1184
ac0f8bd97277 Fix parameter propagation of creation time ond collection names. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	1185 // fetch creation time from database
ac0f8bd97277 Fix parameter propagation of creation time ond collection names. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	1186 // done this way to use the time system
ac0f8bd97277 Fix parameter propagation of creation time ond collection names. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	1187 // of the database.
ac0f8bd97277 Fix parameter propagation of creation time ond collection names. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	1188
ac0f8bd97277 Fix parameter propagation of creation time ond collection names. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	1189 stmnt = conn.prepareStatement(SQL_COLLECTIONS_CREATION_TIME);
ac0f8bd97277 Fix parameter propagation of creation time ond collection names. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	1190 stmnt.setInt(1, id);
ac0f8bd97277 Fix parameter propagation of creation time ond collection names. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	1191
ac0f8bd97277 Fix parameter propagation of creation time ond collection names. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	1192 result = stmnt.executeQuery();
ac0f8bd97277 Fix parameter propagation of creation time ond collection names. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	1193
ac0f8bd97277 Fix parameter propagation of creation time ond collection names. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	1194 Date creationTime = null;
ac0f8bd97277 Fix parameter propagation of creation time ond collection names. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	1195
ac0f8bd97277 Fix parameter propagation of creation time ond collection names. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	1196 if (result.next()) {
ac0f8bd97277 Fix parameter propagation of creation time ond collection names. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	1197 Timestamp timestamp = result.getTimestamp(1);
ac0f8bd97277 Fix parameter propagation of creation time ond collection names. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	1198 creationTime = new Date(timestamp.getTime());
ac0f8bd97277 Fix parameter propagation of creation time ond collection names. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	1199 }
ac0f8bd97277 Fix parameter propagation of creation time ond collection names. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	1200
159 db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1201 return factory.createCollection(
170 ac0f8bd97277 Fix parameter propagation of creation time ond collection names. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	1202 identifier, name, creationTime, data, context);
159 db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1203 }
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1204 catch (SQLException sqle) {
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1205 conn.rollback();
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1206 throw sqle;
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1207 }
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1208 }
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1209 catch (SQLException sqle) {
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1210 logger.error(sqle.getLocalizedMessage(), sqle);
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1211 }
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1212 finally {
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1213 if (result != null) {
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1214 try { result.close(); }
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1215 catch (SQLException sqle) {}
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1216 }
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1217 if (stmnt != null) {
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1218 try { stmnt.close(); }
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1219 catch (SQLException sqle) {}
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1220 }
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1221 if (conn != null) {
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1222 try { conn.close(); }
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1223 catch (SQLException sqle) {}
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1224 }
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1225 }
156 a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1226 return null;
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1227 }
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1228
164 268c2972d4a7 Implemented the interface method listCollections() in the artifact database. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 161 diff changeset	1229 public ArtifactCollection [] listCollections(
167 c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1230 String ownerIdentifier,
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1231 Document data,
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1232 ArtifactCollectionFactory collectionFactory,
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1233 UserFactory userFactory,
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1234 Object context
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1235 ) {
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1236 if (ownerIdentifier != null
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1237 && !StringUtils.checkUUID(ownerIdentifier)) {
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1238 logger.debug("Invalid owner id: '" + ownerIdentifier + "'");
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1239 return null;
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1240 }
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1241
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1242 Connection conn = null;
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1243 ResultSet result = null;
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1244 PreparedStatement stmnt = null;
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1245
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1246 DataSource dataSource = DBConnection.getDataSource();
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1247 try {
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1248 ArrayList<ArtifactCollection> collections =
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1249 new ArrayList<ArtifactCollection>();
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1250 conn = dataSource.getConnection();
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1251
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1252 if (ownerIdentifier != null) {
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1253 stmnt = conn.prepareStatement(SQL_COLLECTIONS_SELECT_USER);
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1254 stmnt.setString(1, ownerIdentifier);
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1255 }
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1256 else {
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1257 stmnt = conn.prepareStatement(SQL_COLLECTIONS_SELECT_ALL);
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1258 }
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1259
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1260 result = stmnt.executeQuery();
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1261
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1262 while (result.next()) {
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1263 String collectionIdentifier = result.getString(1);
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1264 String collectionName = result.getString(2);
170 ac0f8bd97277 Fix parameter propagation of creation time ond collection names. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	1265 Date creationTime =
ac0f8bd97277 Fix parameter propagation of creation time ond collection names. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	1266 new Date(result.getTimestamp(3).getTime());
167 c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1267 String userIdentifier = result.getString(4);
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1268
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1269 ArtifactCollection collection =
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1270 collectionFactory.createCollection(
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1271 collectionIdentifier,
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1272 collectionName,
170 ac0f8bd97277 Fix parameter propagation of creation time ond collection names. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	1273 creationTime,
167 c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1274 data,
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1275 context);
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1276
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1277 if (userIdentifier != null) {
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1278 collection.setUser(new LazyBackendUser(
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1279 userIdentifier, userFactory, this, context));
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1280 }
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1281
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1282 collections.add(collection);
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1283 }
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1284
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1285 return collections.toArray(
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1286 new ArtifactCollection[collections.size()]);
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1287 }
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1288 catch (SQLException sqle) {
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1289 logger.error(sqle.getLocalizedMessage(), sqle);
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1290 }
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1291 finally {
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1292 if (result != null) {
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1293 try { result.close(); }
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1294 catch (SQLException sqle) {}
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1295 }
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1296 if (stmnt != null) {
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1297 try { stmnt.close(); }
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1298 catch (SQLException sqle) {}
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1299 }
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1300 if (conn != null) {
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1301 try { conn.close(); }
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1302 catch (SQLException sqle) {}
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1303 }
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1304 }
156 a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1305 return null;
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1306 }
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1307
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1308 public boolean deleteCollection(String collectionId) {
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1309 // TODO: Implement me!
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1310 return false;
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1311 }
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1312
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1313 public Document getCollectionAttribute(
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1314 String collectionId,
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1315 String artifactId
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1316 ) {
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1317 // TODO: Implement me!
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1318 return null;
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1319 }
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1320
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1321 public boolean setCollectionAttribute(
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1322 String collectionId,
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1323 String artifactId,
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1324 Document attribute
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1325 ) {
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1326 // TODO: Implement me!
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1327 return false;
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1328 }
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1329
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1330 public boolean addCollectionArtifact(
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1331 String collectionId,
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1332 String artifactId
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1333 ) {
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1334 // TODO: Implement me!
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1335 return false;
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1336 }
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1337
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1338 public boolean removeCollectionArtifact(
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1339 String collectionId,
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1340 String artifactId
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1341 ) {
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1342 // TODO: Implement me!
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1343 return false;
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1344 }
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1345
157 6e6965873a48 Simplified creation of users. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 156 diff changeset	1346 public ArtifactCollection [] listCollectionArtifacts(String collectionId) {
156 a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1347 // TODO: Implement me!
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1348 return null;
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1349 }
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1350
13 0d6badf6af42 Added not yet working backend to artifact database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	1351 }
79 f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	1352 // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 :

Mercurial > dive4elements > framework

annotate artifact-database/src/main/java/de/intevation/artifactdatabase/Backend.java @ 170:ac0f8bd97277