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

annotate artifact-database/src/main/java/de/intevation/artifactdatabase/DBConnection.java @ 195:63f555bbdbc0

Fix a foreign key constraint violation when deleting outdated artifacts. artifacts/trunk@1425 c6561f87-3c4e-4783-a992-168aeb5c3f6f

author	Sascha L. Teichmann <sascha.teichmann@intevation.de>
date	Tue, 08 Mar 2011 10:35:40 +0000
parents	933bbc9fc11f
children	b2115f484edb

rev	line source
100 933bbc9fc11f Added license file and license headers. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 95 diff changeset	1 /*
933bbc9fc11f Added license file and license headers. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 95 diff changeset	2 * Copyright (c) 2010 by Intevation GmbH
933bbc9fc11f Added license file and license headers. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 95 diff changeset	3 *
933bbc9fc11f Added license file and license headers. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 95 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: 95 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: 95 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: 95 diff changeset	7 */
933bbc9fc11f Added license file and license headers. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 95 diff changeset	8
10 e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	9 package de.intevation.artifactdatabase;
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	10
93 e27cf9c84eb8 Unified imports. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 91 diff changeset	11 import java.io.File;
e27cf9c84eb8 Unified imports. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 91 diff changeset	12
e27cf9c84eb8 Unified imports. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 91 diff changeset	13 import java.sql.SQLException;
e27cf9c84eb8 Unified imports. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 91 diff changeset	14
10 e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	15 import javax.sql.DataSource;
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	16
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	17 import org.apache.commons.dbcp.BasicDataSource;
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	18
38 93edc04f3a10 Added postgresql support. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 19 diff changeset	19 import org.apache.log4j.Logger;
93edc04f3a10 Added postgresql support. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 19 diff changeset	20
10 e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	21 /**
87 0f48188a6e02 Added some javadoc to the artifactdatabase module. Not done yet. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	22 * This class encapsulate the creation and pooling of database connections used
0f48188a6e02 Added some javadoc to the artifactdatabase module. Not done yet. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	23 * by the artifact database. The credential to open the database connections
0f48188a6e02 Added some javadoc to the artifactdatabase module. Not done yet. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	24 * are taken from the global configuratiion.
0f48188a6e02 Added some javadoc to the artifactdatabase module. Not done yet. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	25 * @author <a href="mailto:sascha.teichmann@intevation.de">Sascha L. Teichmann</a>
10 e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	26 */
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	27 public class DBConnection
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	28 {
38 93edc04f3a10 Added postgresql support. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 19 diff changeset	29 private static Logger logger = Logger.getLogger(DBConnection.class);
93edc04f3a10 Added postgresql support. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 19 diff changeset	30
87 0f48188a6e02 Added some javadoc to the artifactdatabase module. Not done yet. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	31 /**
0f48188a6e02 Added some javadoc to the artifactdatabase module. Not done yet. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	32 * XPath to access the database driver within the global configuration.
0f48188a6e02 Added some javadoc to the artifactdatabase module. Not done yet. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	33 */
10 e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	34 public static final String DB_DRIVER =
38 93edc04f3a10 Added postgresql support. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 19 diff changeset	35 "/artifact-database/database/driver/text()";
87 0f48188a6e02 Added some javadoc to the artifactdatabase module. Not done yet. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	36 /**
0f48188a6e02 Added some javadoc to the artifactdatabase module. Not done yet. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	37 * XPath to access the database URL within the global configuration.
0f48188a6e02 Added some javadoc to the artifactdatabase module. Not done yet. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	38 */
10 e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	39 public static final String DB_URL =
38 93edc04f3a10 Added postgresql support. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 19 diff changeset	40 "/artifact-database/database/url/text()";
87 0f48188a6e02 Added some javadoc to the artifactdatabase module. Not done yet. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	41 /**
0f48188a6e02 Added some javadoc to the artifactdatabase module. Not done yet. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	42 * XPath to access the database use within the global configuration.
0f48188a6e02 Added some javadoc to the artifactdatabase module. Not done yet. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	43 */
10 e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	44 public static final String DB_USER =
38 93edc04f3a10 Added postgresql support. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 19 diff changeset	45 "/artifact-database/database/user/text()";
87 0f48188a6e02 Added some javadoc to the artifactdatabase module. Not done yet. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	46 /**
0f48188a6e02 Added some javadoc to the artifactdatabase module. Not done yet. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	47 * XPath to access the database password within the global configuration.
0f48188a6e02 Added some javadoc to the artifactdatabase module. Not done yet. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	48 */
10 e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	49 public static final String DB_PASSWORD =
38 93edc04f3a10 Added postgresql support. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 19 diff changeset	50 "/artifact-database/database/password/text()";
10 e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	51
87 0f48188a6e02 Added some javadoc to the artifactdatabase module. Not done yet. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	52 /**
0f48188a6e02 Added some javadoc to the artifactdatabase module. Not done yet. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	53 * The default database driver: H2
0f48188a6e02 Added some javadoc to the artifactdatabase module. Not done yet. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	54 */
10 e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	55 public static final String DEFAULT_DRIVER =
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	56 "org.h2.Driver";
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	57
87 0f48188a6e02 Added some javadoc to the artifactdatabase module. Not done yet. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	58 /**
0f48188a6e02 Added some javadoc to the artifactdatabase module. Not done yet. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	59 * The default database name: artifacts.db
0f48188a6e02 Added some javadoc to the artifactdatabase module. Not done yet. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	60 */
19 1259d192e3c3 * New configuration based on config directory Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 12 diff changeset	61 public static final String DEFAULT_DATABASE_FILE =
1259d192e3c3 * New configuration based on config directory Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 12 diff changeset	62 "artifacts.db";
1259d192e3c3 * New configuration based on config directory Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 12 diff changeset	63
87 0f48188a6e02 Added some javadoc to the artifactdatabase module. Not done yet. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	64 /**
0f48188a6e02 Added some javadoc to the artifactdatabase module. Not done yet. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	65 * The default database URL: This is created once by #getDefaultURL()
0f48188a6e02 Added some javadoc to the artifactdatabase module. Not done yet. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	66 */
19 1259d192e3c3 * New configuration based on config directory Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 12 diff changeset	67 public static final String DEFAULT_URL = getDefaultURL();
10 e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	68
87 0f48188a6e02 Added some javadoc to the artifactdatabase module. Not done yet. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	69 /**
0f48188a6e02 Added some javadoc to the artifactdatabase module. Not done yet. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	70 * The default database user: ""
0f48188a6e02 Added some javadoc to the artifactdatabase module. Not done yet. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	71 */
10 e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	72 public static final String DEFAULT_USER = "";
87 0f48188a6e02 Added some javadoc to the artifactdatabase module. Not done yet. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	73
0f48188a6e02 Added some javadoc to the artifactdatabase module. Not done yet. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	74 /**
0f48188a6e02 Added some javadoc to the artifactdatabase module. Not done yet. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	75 * The default database password: ""
0f48188a6e02 Added some javadoc to the artifactdatabase module. Not done yet. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	76 */
10 e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	77 public static final String DEFAULT_PASSWORD = "";
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	78
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	79 private DBConnection() {
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	80 }
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	81
87 0f48188a6e02 Added some javadoc to the artifactdatabase module. Not done yet. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	82 /**
0f48188a6e02 Added some javadoc to the artifactdatabase module. Not done yet. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	83 * Constructs the default databse URL. It concats the
0f48188a6e02 Added some javadoc to the artifactdatabase module. Not done yet. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	84 * config directory and the #DEFAULT_DATABASE_FILE
0f48188a6e02 Added some javadoc to the artifactdatabase module. Not done yet. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	85 * to the string with is needed to access H2 databases.
89 d348fe1fd822 More javadoc (fixes small glitches, too). Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 87 diff changeset	86 * @return The default URL.
87 0f48188a6e02 Added some javadoc to the artifactdatabase module. Not done yet. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	87 */
19 1259d192e3c3 * New configuration based on config directory Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 12 diff changeset	88 public static final String getDefaultURL() {
1259d192e3c3 * New configuration based on config directory Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 12 diff changeset	89 File configDir = Config.getConfigDirectory();
1259d192e3c3 * New configuration based on config directory Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 12 diff changeset	90 File databaseFile = new File(configDir, DEFAULT_DATABASE_FILE);
1259d192e3c3 * New configuration based on config directory Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 12 diff changeset	91 return "jdbc:h2:" + databaseFile;
1259d192e3c3 * New configuration based on config directory Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 12 diff changeset	92 }
1259d192e3c3 * New configuration based on config directory Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 12 diff changeset	93
10 e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	94 private static BasicDataSource dataSource;
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	95
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	96 private static final void addShutdownHook() {
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	97 Runtime.getRuntime().addShutdownHook(new Thread() {
87 0f48188a6e02 Added some javadoc to the artifactdatabase module. Not done yet. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	98 @Override
10 e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	99 public void run() {
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	100 if (dataSource != null) {
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	101 try {
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	102 dataSource.close();
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	103 }
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	104 catch (SQLException sqle) {
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	105 }
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	106 dataSource = null;
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	107 }
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	108 }
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	109 });
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	110 }
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	111
87 0f48188a6e02 Added some javadoc to the artifactdatabase module. Not done yet. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	112 /**
0f48188a6e02 Added some javadoc to the artifactdatabase module. Not done yet. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	113 * Static method to fetch a database connection.
0f48188a6e02 Added some javadoc to the artifactdatabase module. Not done yet. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	114 * @return a DataSource to access the database connection.
0f48188a6e02 Added some javadoc to the artifactdatabase module. Not done yet. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	115 */
10 e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	116 public static synchronized DataSource getDataSource() {
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	117 if (dataSource == null) {
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	118 dataSource = new BasicDataSource();
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	119
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	120 String driver = Config.getStringXPath(
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	121 DB_DRIVER, DEFAULT_DRIVER);
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	122
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	123 String url = Config.getStringXPath(
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	124 DB_URL, DEFAULT_URL);
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	125
95 0edcaf5b5c78 The path to database can be configured with a path relative to the configuration directory. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 93 diff changeset	126 url = Config.replaceConfigDir(url);
0edcaf5b5c78 The path to database can be configured with a path relative to the configuration directory. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 93 diff changeset	127
10 e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	128 String user = Config.getStringXPath(
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	129 DB_USER, DEFAULT_USER);
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	130
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	131 String password = Config.getStringXPath(
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	132 DB_PASSWORD, DEFAULT_PASSWORD);
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	133
38 93edc04f3a10 Added postgresql support. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 19 diff changeset	134 logger.info("database driver: " + driver);
93edc04f3a10 Added postgresql support. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 19 diff changeset	135 logger.info("database url: " + url);
93edc04f3a10 Added postgresql support. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 19 diff changeset	136
10 e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	137 dataSource.setDriverClassName(driver);
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	138 dataSource.setUsername(user);
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	139 dataSource.setPassword(password);
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	140 dataSource.setUrl(url);
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	141 addShutdownHook();
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	142 }
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	143
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	144 return dataSource;
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	145 }
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	146 }
91 730ff077a58c More javadoc, some code formatting. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 89 diff changeset	147 // 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/DBConnection.java @ 195:63f555bbdbc0