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

annotate artifact-database/src/main/java/de/intevation/artifactdatabase/DBConnection.java @ 210:b75fca1ac215

Enhanced the State interface to retrieve its output modes. artifacts/trunk@1541 c6561f87-3c4e-4783-a992-168aeb5c3f6f

author	Ingo Weinzierl <ingo.weinzierl@intevation.de>
date	Wed, 23 Mar 2011 10:45:36 +0000
parents	b2115f484edb
children

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
207 b2115f484edb Move Config and XMLUtils totally to commons package. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 100 diff changeset	11 import de.intevation.artifacts.common.utils.Config;
b2115f484edb Move Config and XMLUtils totally to commons package. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 100 diff changeset	12
93 e27cf9c84eb8 Unified imports. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 91 diff changeset	13 import java.io.File;
e27cf9c84eb8 Unified imports. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 91 diff changeset	14
e27cf9c84eb8 Unified imports. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 91 diff changeset	15 import java.sql.SQLException;
e27cf9c84eb8 Unified imports. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 91 diff changeset	16
10 e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	17 import javax.sql.DataSource;
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	18
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	19 import org.apache.commons.dbcp.BasicDataSource;
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	20
38 93edc04f3a10 Added postgresql support. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 19 diff changeset	21 import org.apache.log4j.Logger;
93edc04f3a10 Added postgresql support. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 19 diff changeset	22
10 e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	23 /**
87 0f48188a6e02 Added some javadoc to the artifactdatabase module. Not done yet. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	24 * 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	25 * 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	26 * 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	27 * @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	28 */
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	29 public class DBConnection
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	30 {
38 93edc04f3a10 Added postgresql support. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 19 diff changeset	31 private static Logger logger = Logger.getLogger(DBConnection.class);
93edc04f3a10 Added postgresql support. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 19 diff changeset	32
87 0f48188a6e02 Added some javadoc to the artifactdatabase module. Not done yet. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	33 /**
0f48188a6e02 Added some javadoc to the artifactdatabase module. Not done yet. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	34 * 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	35 */
10 e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	36 public static final String DB_DRIVER =
38 93edc04f3a10 Added postgresql support. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 19 diff changeset	37 "/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	38 /**
0f48188a6e02 Added some javadoc to the artifactdatabase module. Not done yet. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	39 * 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	40 */
10 e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	41 public static final String DB_URL =
38 93edc04f3a10 Added postgresql support. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 19 diff changeset	42 "/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	43 /**
0f48188a6e02 Added some javadoc to the artifactdatabase module. Not done yet. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	44 * 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	45 */
10 e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	46 public static final String DB_USER =
38 93edc04f3a10 Added postgresql support. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 19 diff changeset	47 "/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	48 /**
0f48188a6e02 Added some javadoc to the artifactdatabase module. Not done yet. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	49 * 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	50 */
10 e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	51 public static final String DB_PASSWORD =
38 93edc04f3a10 Added postgresql support. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 19 diff changeset	52 "/artifact-database/database/password/text()";
10 e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	53
87 0f48188a6e02 Added some javadoc to the artifactdatabase module. Not done yet. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	54 /**
0f48188a6e02 Added some javadoc to the artifactdatabase module. Not done yet. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	55 * 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	56 */
10 e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	57 public static final String DEFAULT_DRIVER =
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	58 "org.h2.Driver";
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	59
87 0f48188a6e02 Added some javadoc to the artifactdatabase module. Not done yet. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	60 /**
0f48188a6e02 Added some javadoc to the artifactdatabase module. Not done yet. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	61 * 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	62 */
19 1259d192e3c3 * New configuration based on config directory Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 12 diff changeset	63 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	64 "artifacts.db";
1259d192e3c3 * New configuration based on config directory Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 12 diff changeset	65
87 0f48188a6e02 Added some javadoc to the artifactdatabase module. Not done yet. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	66 /**
0f48188a6e02 Added some javadoc to the artifactdatabase module. Not done yet. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	67 * 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	68 */
19 1259d192e3c3 * New configuration based on config directory Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 12 diff changeset	69 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	70
87 0f48188a6e02 Added some javadoc to the artifactdatabase module. Not done yet. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	71 /**
0f48188a6e02 Added some javadoc to the artifactdatabase module. Not done yet. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	72 * 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	73 */
10 e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	74 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	75
0f48188a6e02 Added some javadoc to the artifactdatabase module. Not done yet. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	76 /**
0f48188a6e02 Added some javadoc to the artifactdatabase module. Not done yet. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	77 * 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	78 */
10 e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	79 public static final String DEFAULT_PASSWORD = "";
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 private DBConnection() {
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	82 }
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	83
87 0f48188a6e02 Added some javadoc to the artifactdatabase module. Not done yet. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	84 /**
0f48188a6e02 Added some javadoc to the artifactdatabase module. Not done yet. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	85 * 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	86 * 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	87 * 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	88 * @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	89 */
19 1259d192e3c3 * New configuration based on config directory Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 12 diff changeset	90 public static final String getDefaultURL() {
1259d192e3c3 * New configuration based on config directory Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 12 diff changeset	91 File configDir = Config.getConfigDirectory();
1259d192e3c3 * New configuration based on config directory Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 12 diff changeset	92 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	93 return "jdbc:h2:" + databaseFile;
1259d192e3c3 * New configuration based on config directory Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 12 diff changeset	94 }
1259d192e3c3 * New configuration based on config directory Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 12 diff changeset	95
10 e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	96 private static BasicDataSource dataSource;
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	97
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	98 private static final void addShutdownHook() {
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	99 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	100 @Override
10 e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	101 public void run() {
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	102 if (dataSource != null) {
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	103 try {
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	104 dataSource.close();
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 catch (SQLException sqle) {
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 dataSource = null;
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 });
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	112 }
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	113
87 0f48188a6e02 Added some javadoc to the artifactdatabase module. Not done yet. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	114 /**
0f48188a6e02 Added some javadoc to the artifactdatabase module. Not done yet. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	115 * 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	116 * @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	117 */
10 e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	118 public static synchronized DataSource getDataSource() {
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	119 if (dataSource == null) {
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	120 dataSource = new BasicDataSource();
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	121
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	122 String driver = Config.getStringXPath(
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	123 DB_DRIVER, DEFAULT_DRIVER);
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	124
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	125 String url = Config.getStringXPath(
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	126 DB_URL, DEFAULT_URL);
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	127
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	128 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	129
10 e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	130 String user = Config.getStringXPath(
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	131 DB_USER, DEFAULT_USER);
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	132
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	133 String password = Config.getStringXPath(
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	134 DB_PASSWORD, DEFAULT_PASSWORD);
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	135
38 93edc04f3a10 Added postgresql support. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 19 diff changeset	136 logger.info("database driver: " + driver);
93edc04f3a10 Added postgresql support. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 19 diff changeset	137 logger.info("database url: " + url);
93edc04f3a10 Added postgresql support. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 19 diff changeset	138
10 e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	139 dataSource.setDriverClassName(driver);
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	140 dataSource.setUsername(user);
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	141 dataSource.setPassword(password);
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	142 dataSource.setUrl(url);
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	143 addShutdownHook();
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	144 }
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 return dataSource;
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	147 }
e8626caac353 * Made Artifact life cycle symmetric: setup/endOfLife. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	148 }
91 730ff077a58c More javadoc, some code formatting. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 89 diff changeset	149 // 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 @ 210:b75fca1ac215