quickfix.JdbcUtil Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of quickfixj-core Show documentation
Show all versions of quickfixj-core Show documentation
The core QuickFIX/J engine
/*******************************************************************************
* Copyright (c) quickfixengine.org All rights reserved.
*
* This file is part of the QuickFIX FIX Engine
*
* This file may be distributed under the terms of the quickfixengine.org
* license as defined by quickfixengine.org and appearing in the file
* LICENSE included in the packaging of this file.
*
* This file is provided AS IS with NO WARRANTY OF ANY KIND, INCLUDING
* THE WARRANTY OF DESIGN, MERCHANTABILITY AND FITNESS FOR A
* PARTICULAR PURPOSE.
*
* See http://www.quickfixengine.org/LICENSE for licensing information.
*
* Contact [email protected] if any conditions of this licensing
* are not clear to you.
******************************************************************************/
package quickfix;
import org.logicalcobwebs.proxool.ProxoolDataSource;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.sql.DataSource;
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Map;
import java.util.concurrent.ConcurrentHashMap;
class JdbcUtil {
static final String CONNECTION_POOL_ALIAS = "quickfixj";
private static final Map dataSources = new ConcurrentHashMap<>();
private static int dataSourceCounter = 1;
static DataSource getDataSource(SessionSettings settings, SessionID sessionID)
throws ConfigError, FieldConvertError {
if (settings.isSetting(sessionID, JdbcSetting.SETTING_JDBC_DS_NAME)) {
String jndiName = settings.getString(sessionID, JdbcSetting.SETTING_JDBC_DS_NAME);
try {
return (DataSource) new InitialContext().lookup(jndiName);
} catch (NamingException e) {
throw new ConfigError(e);
}
} else {
String jdbcDriver = settings.getString(sessionID, JdbcSetting.SETTING_JDBC_DRIVER);
String connectionURL = settings.getString(sessionID,
JdbcSetting.SETTING_JDBC_CONNECTION_URL);
String user = settings.getString(sessionID, JdbcSetting.SETTING_JDBC_USER);
String password = settings.getString(sessionID, JdbcSetting.SETTING_JDBC_PASSWORD);
int maxConnCount = settings
.isSetting(JdbcSetting.SETTING_JDBC_MAX_ACTIVE_CONNECTION) ?
settings.getInt(sessionID, JdbcSetting.SETTING_JDBC_MAX_ACTIVE_CONNECTION) :
32;
int simultaneousBuildThrottle = settings
.isSetting(JdbcSetting.SETTING_JDBC_SIMULTANEOUS_BUILD_THROTTLE) ?
settings.getInt(sessionID, JdbcSetting.SETTING_JDBC_SIMULTANEOUS_BUILD_THROTTLE) :
maxConnCount;
long maxActiveTime = settings
.isSetting(JdbcSetting.SETTING_JDBC_MAX_ACTIVE_TIME) ?
settings.getLong(sessionID, JdbcSetting.SETTING_JDBC_MAX_ACTIVE_TIME) :
5000;
int maxConnLifetime = settings
.isSetting(JdbcSetting.SETTING_JDBC_MAX_CONNECTION_LIFETIME) ?
settings.getInt(sessionID, JdbcSetting.SETTING_JDBC_MAX_CONNECTION_LIFETIME) :
28800000;
return getDataSource(jdbcDriver, connectionURL, user, password, true, maxConnCount,
simultaneousBuildThrottle, maxActiveTime, maxConnLifetime);
}
}
static DataSource getDataSource(String jdbcDriver, String connectionURL, String user, String password, boolean cache) {
return getDataSource(jdbcDriver, connectionURL, user, password, cache, 10, 10, 5000, 28800000);
}
/**
* This is typically called from a single thread, but just in case we are synchronizing modification
* of the cache. The cache itself is thread safe.
*/
static synchronized DataSource getDataSource(String jdbcDriver, String connectionURL, String user, String password,
boolean cache, int maxConnCount, int simultaneousBuildThrottle,
long maxActiveTime, int maxConnLifetime) {
String key = jdbcDriver + "#" + connectionURL + "#" + user + "#" + password;
ProxoolDataSource ds = cache ? dataSources.get(key) : null;
if (ds == null) {
ds = new ProxoolDataSource(JdbcUtil.CONNECTION_POOL_ALIAS + "-" + dataSourceCounter++);
ds.setDriver(jdbcDriver);
ds.setDriverUrl(connectionURL);
// Bug in Proxool 0.9RC2. Must set both delegate properties and individual setters. :-(
ds.setDelegateProperties("user=" + user + ","
+ (password != null && !"".equals(password) ? "password=" + password : ""));
ds.setUser(user);
ds.setPassword(password);
ds.setMaximumActiveTime(maxActiveTime);
ds.setMaximumConnectionLifetime(maxConnLifetime);
ds.setMaximumConnectionCount(maxConnCount);
ds.setSimultaneousBuildThrottle(simultaneousBuildThrottle);
if (cache) {
dataSources.put(key, ds);
}
}
return ds;
}
static void close(SessionID sessionID, Connection connection) {
if (connection != null) {
try {
connection.close();
} catch (SQLException e) {
LogUtil.logThrowable(sessionID, e.getMessage(), e);
}
}
}
static void close(SessionID sessionID, PreparedStatement statement) {
if (statement != null) {
try {
statement.close();
} catch (SQLException e) {
LogUtil.logThrowable(sessionID, e.getMessage(), e);
}
}
}
static void close(SessionID sessionID, ResultSet rs) {
if (rs != null) {
try {
rs.close();
} catch (SQLException e) {
LogUtil.logThrowable(sessionID, e.getMessage(), e);
}
}
}
static boolean determineSessionIdSupport(DataSource dataSource, String tableName) throws SQLException {
try (Connection connection = dataSource.getConnection()) {
DatabaseMetaData metaData = connection.getMetaData();
String columnName = "sendersubid";
return isColumn(metaData, tableName.toUpperCase(), columnName.toUpperCase())
|| isColumn(metaData, tableName, columnName);
}
}
private static boolean isColumn(DatabaseMetaData metaData, String tableName, String columnName)
throws SQLException {
try (ResultSet columns = metaData.getColumns(null, null, tableName, columnName)) {
return columns.next();
}
}
static String getIDWhereClause(boolean isExtendedSessionID) {
return isExtendedSessionID
? ("beginstring=? and sendercompid=? and sendersubid=? and senderlocid=? and "
+ "targetcompid=? and targetsubid=? and targetlocid=? and session_qualifier=? ")
: "beginstring=? and sendercompid=? and targetcompid=? and session_qualifier=? ";
}
static String getIDColumns(boolean isExtendedSessionID) {
return isExtendedSessionID
? "beginstring,sendercompid,sendersubid,senderlocid,targetcompid,targetsubid,targetlocid,session_qualifier"
: "beginstring,sendercompid,targetcompid,session_qualifier";
}
static String getIDPlaceholders(boolean isExtendedSessionID) {
return isExtendedSessionID ? "?,?,?,?,?,?,?,?" : "?,?,?,?";
}
static int setSessionIdParameters(SessionID sessionID, PreparedStatement query, int offset, boolean isExtendedSessionID, String defaultSqlValue) throws SQLException {
if (isExtendedSessionID) {
query.setString(offset++, getSqlValue(sessionID.getBeginString(), defaultSqlValue));
query.setString(offset++, getSqlValue(sessionID.getSenderCompID(), defaultSqlValue));
query.setString(offset++, getSqlValue(sessionID.getSenderSubID(), defaultSqlValue));
query.setString(offset++, getSqlValue(sessionID.getSenderLocationID(), defaultSqlValue));
query.setString(offset++, getSqlValue(sessionID.getTargetCompID(), defaultSqlValue));
query.setString(offset++, getSqlValue(sessionID.getTargetSubID(), defaultSqlValue));
query.setString(offset++, getSqlValue(sessionID.getTargetLocationID(), defaultSqlValue));
query.setString(offset++, getSqlValue(sessionID.getSessionQualifier(), defaultSqlValue));
} else {
query.setString(offset++, getSqlValue(sessionID.getBeginString(), defaultSqlValue));
query.setString(offset++, getSqlValue(sessionID.getSenderCompID(), defaultSqlValue));
query.setString(offset++, getSqlValue(sessionID.getTargetCompID(), defaultSqlValue));
query.setString(offset++, getSqlValue(sessionID.getSessionQualifier(), defaultSqlValue));
}
return offset;
}
private static String getSqlValue(String javaValue, String defaultSqlValue) {
return !SessionID.NOT_SET.equals(javaValue) ? javaValue : defaultSqlValue;
}
}