Mercurial > dive4elements > framework
comparison artifact-database/src/main/java/org/dive4elements/artifactdatabase/db/DBConnection.java @ 473:d0ac790a6c89 dive4elements-move
Moved directories to org.dive4elements
author | Sascha L. Teichmann <teichmann@intevation.de> |
---|---|
date | Thu, 25 Apr 2013 10:57:18 +0200 |
parents | artifact-database/src/main/java/de/intevation/artifactdatabase/db/DBConnection.java@6d239c58c636 |
children | 415df0fc4fa1 |
comparison
equal
deleted
inserted
replaced
472:783cc1b6b615 | 473:d0ac790a6c89 |
---|---|
1 package de.intevation.artifactdatabase.db; | |
2 | |
3 import javax.sql.DataSource; | |
4 | |
5 import java.io.File; | |
6 | |
7 import org.apache.commons.pool.ObjectPool; | |
8 | |
9 import org.apache.commons.pool.impl.GenericObjectPool; | |
10 | |
11 import org.apache.commons.dbcp.DriverManagerConnectionFactory; | |
12 import org.apache.commons.dbcp.PoolableConnectionFactory; | |
13 import org.apache.commons.dbcp.PoolingDataSource; | |
14 | |
15 import de.intevation.artifacts.common.utils.Config; | |
16 | |
17 import org.apache.log4j.Logger; | |
18 | |
19 public class DBConnection | |
20 { | |
21 private static Logger log = Logger.getLogger(DBConnection.class); | |
22 | |
23 public static final String DEFAULT_DRIVER = "org.h2.Driver"; | |
24 public static final String DEFAULT_USER = ""; | |
25 public static final String DEFAULT_PASSWORD = ""; | |
26 public static final String DEFAULT_DATABASE_FILE = "artifacts.db"; | |
27 public static final String DEFAULT_URL = getDefaultURL(); | |
28 | |
29 public static final String getDefaultURL() { | |
30 File configDir = Config.getConfigDirectory(); | |
31 File databaseFile = new File(configDir, DEFAULT_DATABASE_FILE); | |
32 return "jdbc:h2:" + databaseFile; | |
33 } | |
34 | |
35 protected DataSource dataSource; | |
36 | |
37 protected String driver; | |
38 protected String url; | |
39 protected String user; | |
40 protected String password; | |
41 | |
42 public DBConnection() { | |
43 } | |
44 | |
45 public DBConnection( | |
46 String driver, | |
47 String url, | |
48 String user, | |
49 String password | |
50 ) { | |
51 this.driver = driver; | |
52 this.url = url; | |
53 this.user = user; | |
54 this.password = password; | |
55 } | |
56 | |
57 public String getUser() { | |
58 return user; | |
59 } | |
60 | |
61 public void setUser(String user) { | |
62 this.user = user; | |
63 } | |
64 | |
65 public String getPassword() { | |
66 return password; | |
67 } | |
68 | |
69 public void setPassword(String password) { | |
70 this.password = password; | |
71 } | |
72 | |
73 public String getDriver() { | |
74 return driver; | |
75 } | |
76 | |
77 public void setDriver(String driver) { | |
78 this.driver = driver; | |
79 } | |
80 | |
81 public String getUrl() { | |
82 return url; | |
83 } | |
84 | |
85 public void setUrl(String url) { | |
86 this.url = url; | |
87 } | |
88 | |
89 public synchronized DataSource getDataSource() { | |
90 if (dataSource == null) { | |
91 if (log.isDebugEnabled()) { | |
92 log.debug("create new datasource:"); | |
93 log.debug(" driver: " + driver); | |
94 log.debug(" url : " + url); | |
95 log.debug(" user : " + user); | |
96 } | |
97 | |
98 try { | |
99 synchronized (DBConnection.class) { | |
100 Class.forName(driver); | |
101 } | |
102 } | |
103 catch (ClassNotFoundException cnfe) { | |
104 log.error("cannot load driver", cnfe); | |
105 return null; | |
106 } | |
107 | |
108 DriverManagerConnectionFactory dmcf = | |
109 new DriverManagerConnectionFactory(url, user, password); | |
110 | |
111 ObjectPool cp = new GenericObjectPool(); | |
112 | |
113 PoolableConnectionFactory pcf = new PoolableConnectionFactory( | |
114 dmcf, cp, null, null, false, false); | |
115 | |
116 dataSource = new PoolingDataSource(cp); | |
117 } | |
118 return dataSource; | |
119 } | |
120 } | |
121 // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 : |