--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/artifact-database/src/main/java/de/intevation/artifactdatabase/DBConnection.java	Sun Sep 06 12:00:56 2009 +0000
@@ -0,0 +1,78 @@
+package de.intevation.artifactdatabase;
+
+import javax.sql.DataSource;
+
+import java.sql.SQLException;
+
+import org.apache.commons.dbcp.BasicDataSource;
+
+/**
+ *  @author Sascha L. Teichmann
+ */
+public class DBConnection
+{
+    public static final String DB_DRIVER =
+        "/artifacts-database/database/driver/text()";
+    public static final String DB_URL =
+        "/artifacts-database/database/url/text()";
+    public static final String DB_USER =
+        "/artifacts-database/database/driver/user/text()";
+    public static final String DB_PASSWORD =
+        "/artifacts-database/database/driver/password()";
+
+    public static final String DEFAULT_DRIVER =
+        "org.h2.Driver";
+
+    public static final String DEFAULT_URL =
+        "jdbc:h2:artifacts.db";
+
+    public static final String DEFAULT_USER     = "";
+    public static final String DEFAULT_PASSWORD = "";
+
+    private DBConnection() {
+    }
+
+    private static BasicDataSource dataSource;
+
+    private static final void addShutdownHook() {
+        Runtime.getRuntime().addShutdownHook(new Thread() {
+            public void run() {
+                if (dataSource != null) {
+                    try {
+                        dataSource.close();
+                    }
+                    catch (SQLException sqle) {
+                    }
+                    dataSource = null;
+                }
+            }
+        });
+    }
+
+    public static synchronized DataSource getDataSource() {
+        if (dataSource == null) {
+            dataSource = new BasicDataSource();
+
+            String driver = Config.getStringXPath(
+                DB_DRIVER, DEFAULT_DRIVER);
+
+            String url = Config.getStringXPath(
+                DB_URL, DEFAULT_URL);
+
+            String user = Config.getStringXPath(
+                DB_USER, DEFAULT_USER);
+
+            String password = Config.getStringXPath(
+                DB_PASSWORD, DEFAULT_PASSWORD);
+
+            dataSource.setDriverClassName(driver);
+            dataSource.setUsername(user);
+            dataSource.setPassword(password);
+            dataSource.setUrl(url);
+            addShutdownHook();
+        }
+
+        return dataSource;
+    }
+}
+//  vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8: