public static final String module = XaPoolConnectionFactory.class.getName();
protected static Map dsCache = new HashMap();
public static Connection getConnection(String helperName, Element jotmJdbcElement) throws SQLException, GenericEntityException {
StandardXAPoolDataSource pds = (StandardXAPoolDataSource) dsCache.get(helperName);
if (pds != null) {
if (Debug.verboseOn()) Debug.logVerbose(helperName + " pool size: " + pds.pool.getCount(), module);
return TransactionFactory.getCursorConnection(helperName, pds.getConnection());
}
synchronized (XaPoolConnectionFactory.class) {
pds = (StandardXAPoolDataSource) dsCache.get(helperName);
if (pds != null) {
return pds.getConnection();
}
// the xapool wrapper class
String wrapperClass = jotmJdbcElement.getAttribute("pool-xa-wrapper-class");
StandardXADataSource ds = null;
try {
//ds = new StandardXADataSource();
ds = (StandardXADataSource) ObjectType.getInstance(wrapperClass);
pds = new StandardXAPoolDataSource();
} catch (NoClassDefFoundError e) {
throw new GenericEntityException("Cannot find xapool.jar");
} catch (ClassNotFoundException e) {
throw new GenericEntityException("Cannot load wrapper class: " + wrapperClass, e);
} catch (InstantiationException e) {
throw new GenericEntityException("Unable to instantiate " + wrapperClass, e);
} catch (IllegalAccessException e) {
throw new GenericEntityException("Problems getting instance of " + wrapperClass, e);
}
if (ds == null)
throw new GenericEntityException("StandardXaDataSource was not created, big problem!");
ds.setDriverName(jotmJdbcElement.getAttribute("jdbc-driver"));
ds.setUrl(jotmJdbcElement.getAttribute("jdbc-uri"));
ds.setUser(jotmJdbcElement.getAttribute("jdbc-username"));
ds.setPassword(jotmJdbcElement.getAttribute("jdbc-password"));
ds.setDescription(helperName);
ds.setTransactionManager(TransactionFactory.getTransactionManager());
String transIso = jotmJdbcElement.getAttribute("isolation-level");
if (transIso != null && transIso.length() > 0) {
if ("Serializable".equals(transIso)) {
((StandardXADataSource) ds).setTransactionIsolation(Connection.TRANSACTION_SERIALIZABLE);
} else if ("RepeatableRead".equals(transIso)) {
((StandardXADataSource) ds).setTransactionIsolation(Connection.TRANSACTION_REPEATABLE_READ);
} else if ("ReadUncommitted".equals(transIso)) {
((StandardXADataSource) ds).setTransactionIsolation(Connection.TRANSACTION_READ_UNCOMMITTED);
} else if ("ReadCommitted".equals(transIso)) {
((StandardXADataSource) ds).setTransactionIsolation(Connection.TRANSACTION_READ_COMMITTED);
} else if ("None".equals(transIso)) {
((StandardXADataSource) ds).setTransactionIsolation(Connection.TRANSACTION_NONE);
}
}
// set the datasource in the pool
pds.setDataSource(ds);
pds.setDescription(ds.getDescription());
pds.setUser(ds.getUser());
pds.setPassword(ds.getPassword());
Debug.logInfo("XADataSource: " + ds.getClass().getName() + " attached to pool.", module);
// set the transaction manager in the pool
pds.setTransactionManager(TransactionFactory.getTransactionManager());
// configure the pool settings
try {
pds.setMaxSize(new Integer(jotmJdbcElement.getAttribute("pool-maxsize")).intValue());
pds.setMinSize(new Integer(jotmJdbcElement.getAttribute("pool-minsize")).intValue());
pds.setSleepTime(new Long(jotmJdbcElement.getAttribute("pool-sleeptime")).longValue());
pds.setLifeTime(new Long(jotmJdbcElement.getAttribute("pool-lifetime")).longValue());
pds.setDeadLockMaxWait(new Long(jotmJdbcElement.getAttribute("pool-deadlock-maxwait")).longValue());
pds.setDeadLockRetryWait(new Long(jotmJdbcElement.getAttribute("pool-deadlock-retrywait")).longValue());
// set the test statement to test connections
String testStmt = jotmJdbcElement.getAttribute("pool-jdbc-test-stmt");
if (testStmt != null && testStmt.length() > 0) {
pds.setJdbcTestStmt(testStmt);
Debug.logInfo("Set JDBC Test Statement : " + testStmt, module);
}
} catch (NumberFormatException nfe) {
Debug.logError(nfe, "Problems with pool settings; the values MUST be numbers, using defaults.", module);
} catch (Exception e) {
Debug.logError(e, "Problems with pool settings", module);
}
// cache the pool
dsCache.put(helperName, pds);
return TransactionFactory.getCursorConnection(helperName, pds.getConnection());
}
}