org.plasma.sdo.jdbc.connect.RDBConnectionManager Maven / Gradle / Ivy
/**
* PlasmaSDO™ License
*
* This is a community release of PlasmaSDO™, a dual-license
* Service Data Object (SDO) 2.1 implementation.
* This particular copy of the software is released under the
* version 2 of the GNU General Public License. PlasmaSDO™ was developed by
* TerraMeta Software, Inc.
*
* Copyright (c) 2013, TerraMeta Software, Inc. All rights reserved.
*
* General License information can be found below.
*
* This distribution may include materials developed by third
* parties. For license and attribution notices for these
* materials, please refer to the documentation that accompanies
* this distribution (see the "Licenses for Third-Party Components"
* appendix) or view the online documentation at
* props = new HashMap();
for (Property property : PlasmaRuntime.getInstance()
.getDataAccessProvider(DataAccessProviderName.JDBC).getProperties())
props.put(property.getName(), property.getValue());
String driverName = props.get("org.plasma.sdo.access.provider.jdbc.ConnectionDriverName");
String url = props.get("org.plasma.sdo.access.provider.jdbc.ConnectionURL");
String user = props.get("org.plasma.sdo.access.provider.jdbc.ConnectionUserName");
String password = props.get("org.plasma.sdo.access.provider.jdbc.ConnectionPassword");
int poolMinSize = Integer.valueOf(props
.get("org.plasma.sdo.access.provider.jdbc.ConnectionPoolMinSize"));
int poolMaxSize = Integer.valueOf(props
.get("org.plasma.sdo.access.provider.jdbc.ConnectionPoolMaxSize"));
try {
java.lang.Class.forName(driverName).newInstance();
} catch (Exception e) {
log.error("Error when attempting to obtain DB Driver: " + driverName, e);
}
if (log.isDebugEnabled())
log.debug("trying to connect to database...");
try {
RDBConnectionManager.DS = setup(url, user, password, poolMinSize, poolMaxSize, props);
log.debug("Connection attempt to database succeeded.");
} catch (Exception e) {
log.error("Error when attempting to connect to DB ", e);
}
}
public static RDBConnectionManager instance() {
if (instance == null)
initInstance(); // double-checked locking pattern
return instance;
}
private static synchronized void initInstance() {
if (instance == null)
instance = new RDBConnectionManager();
}
protected void finalize() {
log.debug("Finalizing ConnectionManager");
try {
super.finalize();
} catch (Throwable ex) {
log.error("ConnectionManager finalize failed to disconnect: ", ex);
}
}
public Connection getConnection() throws SQLException {
try {
printDriverStats();
} catch (Exception e) {
log.error(e.getMessage());
}
return DS.getConnection();
}
/**
*
* @param connectURI
* - JDBC Connection URI
* @param username
* - JDBC Connection username
* @param password
* - JDBC Connection password
* @param minIdle
* - Minimum number of idel connection in the connection pool
* @param maxActive
* - Connection Pool Maximum Capacity (Size)
* @throws Exception
*/
private static DataSource setup(String connectURI, String username, String password, int minIdle,
int maxActive, Map props) throws Exception {
//
// Create an ObjectPool that serves as the
// actual pool of connections.
//
// Use a GenericObjectPool instance, although
// any ObjectPool implementation will suffice.
//
GenericObjectPool.Config config = createGenericObjectPoolConfig(props);
GenericObjectPool connectionPool = new GenericObjectPool(null, config);
connectionPool.setMinIdle(minIdle);
connectionPool.setMaxActive(maxActive);
RDBConnectionManager._pool = connectionPool;
// We keep it for two reasons
// #1 We need it for statistics/debugging
// #2 PoolingDataSource does not have getPool()
// method, for some obscure, weird reason.
//
// Create a ConnectionFactory that the
// pool will use to create Connections.
// Use the DriverManagerConnectionFactory,
// using the connect string from configuration
//
ConnectionFactory connectionFactory = new DriverManagerConnectionFactory(connectURI, username,
password);
//
// Create the PoolableConnectionFactory, which wraps
// the "real" Connections created by the ConnectionFactory with
// the classes that implement the pooling functionality.
//
PoolableConnectionFactory poolableConnectionFactory = new PoolableConnectionFactory(
connectionFactory, connectionPool, null, null, false, true);
String value = getValue(DBCP_VALIDATIONQUERY, props);
if (value != null) {
try {
poolableConnectionFactory.setValidationQuery(value);
} catch (Exception e) {
throw new JDBCServiceException(e);
}
}
PoolingDataSource dataSource = new PoolingDataSource(connectionPool);
return dataSource;
}
public static void printDriverStats() throws Exception {
ObjectPool connectionPool = RDBConnectionManager._pool;
log.debug("NumActive: " + connectionPool.getNumActive());
log.debug("NumIdle: " + connectionPool.getNumIdle());
}
/**
* getNumLockedProcesses - gets the number of currently locked processes on
* the MySQL db
*
* @return Number of locked processes
*/
public int getNumLockedProcesses() {
int num_locked_connections = 0;
Connection con = null;
PreparedStatement p_stmt = null;
ResultSet rs = null;
try {
con = RDBConnectionManager.DS.getConnection();
p_stmt = con.prepareStatement("SHOW PROCESSLIST");
rs = p_stmt.executeQuery();
while (rs.next()) {
if (rs.getString("State") != null && rs.getString("State").equals("Locked")) {
num_locked_connections++;
}
}
} catch (Exception e) {
log.debug("Failed to get get Locked Connections - Exception: " + e.toString());
} finally {
try {
rs.close();
p_stmt.close();
con.close();
} catch (java.sql.SQLException ex) {
log.error(ex.toString());
}
}
return num_locked_connections;
}
private static GenericObjectPool.Config createGenericObjectPoolConfig(Map props) {
GenericObjectPool.Config config = new GenericObjectPool.Config();
String value = getValue(DBCP_TESTONBORROW, props);
if (value != null) {
try {
config.testOnBorrow = Boolean.parseBoolean(value);
} catch (Exception e) {
throw new JDBCServiceException(e);
}
}
value = getValue(DBCP_TESTONRETURN, props);
if (value != null) {
try {
config.testOnReturn = Boolean.parseBoolean(value);
} catch (Exception e) {
throw new JDBCServiceException(e);
}
}
value = getValue(DBCP_TESTWHILEIDLE, props);
if (value != null) {
try {
config.testWhileIdle = Boolean.parseBoolean(value);
} catch (Exception e) {
throw new JDBCServiceException(e);
}
}
value = getValue(DBCP_TIMEBETWEENEVICTIONRUNSMILLIS, props);
if (value != null) {
try {
config.timeBetweenEvictionRunsMillis = Long.parseLong(value);
} catch (NumberFormatException e) {
throw new JDBCServiceException(e);
}
}
value = getValue(DBCP_NUMTESTSPEREVICTIONRUN, props);
if (value != null) {
try {
config.numTestsPerEvictionRun = Integer.parseInt(value);
} catch (NumberFormatException e) {
throw new JDBCServiceException(e);
}
}
value = getValue(DBCP_MINEVICTABLEIDLETIMEMILLIS, props);
if (value != null) {
try {
config.minEvictableIdleTimeMillis = Long.parseLong(value);
} catch (NumberFormatException e) {
throw new JDBCServiceException(e);
}
}
value = getValue(DBCP_MAXIDLE, props);
if (value != null) {
try {
config.maxIdle = Integer.parseInt(value);
} catch (NumberFormatException e) {
throw new JDBCServiceException(e);
}
}
value = getValue(DBCP_MINIDLE, props);
if (value != null) {
try {
config.minIdle = Integer.parseInt(value);
} catch (NumberFormatException e) {
throw new JDBCServiceException(e);
}
}
value = getValue(DBCP_MAXACTIVE, props);
if (value != null) {
try {
config.maxActive = Integer.parseInt(value);
} catch (NumberFormatException e) {
throw new JDBCServiceException(e);
}
}
value = getValue(DBCP_MAXWAIT, props);
if (value != null) {
try {
config.maxWait = Integer.parseInt(value);
} catch (NumberFormatException e) {
throw new JDBCServiceException(e);
}
}
return config;
}
private static String getValue(String name, Map props) {
String value = props.get(name);
if (value == null)
value = props.get("org.apache.commons.dbcp." + name);
return value;
}
}
© 2015 - 2025 Weber Informatics LLC | Privacy Policy