connection.setAutoCommit(true); DatabaseMetaData metaData = connection.getMetaData(); _dbAdaptor = new DatabaseAdaptor(metaData); _sessionTableRowId = _dbAdaptor.getRowIdColumnName(); String tableName = _dbAdaptor.convertIdentifier(_sessionIdTable); ResultSet result = metaData.getTables(null, null, tableName, null); if (!result.next()) tableName = _dbAdaptor.convertIdentifier(_sessionTable); result = metaData.getTables(null, null, tableName, null); if (!result.next()) String blobType = _dbAdaptor.getBlobType(); String longType = _dbAdaptor.getLongType(); _createSessionTable = "create table "+_sessionTable+" ("+_sessionTableRowId+" varchar(120), sessionId varchar(120), "+ " contextPath varchar(60), virtualHost varchar(60), lastNode varchar(60), accessTime "+longType+", "+
public PreparedStatement getLoadStatement (Connection connection, String rowId, String contextPath, String virtualHosts) throws SQLException { if (_dbAdaptor == null) throw new IllegalStateException("No DB adaptor"); if (contextPath == null || "".equals(contextPath)) { if (_dbAdaptor.isEmptyStringNull()) { PreparedStatement statement = connection.prepareStatement("select * from "+getTableName()+ " where "+getIdColumn()+" = ? and "+ getContextPathColumn()+" is null and "+ getVirtualHostColumn()+" = ?"); statement.setString(1, rowId); statement.setString(2, virtualHosts); return statement; } } PreparedStatement statement = connection.prepareStatement("select * from "+getTableName()+ " where "+getIdColumn()+" = ? and "+getContextPathColumn()+ " = ? and "+getVirtualHostColumn()+" = ?"); statement.setString(1, rowId); statement.setString(2, contextPath); statement.setString(3, virtualHosts); return statement; } }
_dbAdaptor.adaptTo(metaData); _sessionTableSchema.setDatabaseAdaptor(_dbAdaptor); _sessionIdTableSchema.setDatabaseAdaptor(_dbAdaptor); String tableName = _dbAdaptor.convertIdentifier(_sessionIdTableSchema.getTableName()); try (ResultSet result = metaData.getTables(null, null, tableName, null)) tableName = _dbAdaptor.convertIdentifier(_sessionTableSchema.getTableName()); try (ResultSet result = metaData.getTables(null, null, tableName, null)) _dbAdaptor.convertIdentifier(_sessionTableSchema.getTableName()), _dbAdaptor.convertIdentifier(_sessionTableSchema.getMaxIntervalColumn()));
_dbAdaptor.adaptTo(metaData); _sessionTableSchema.setDatabaseAdaptor(_dbAdaptor); _sessionIdTableSchema.setDatabaseAdaptor(_dbAdaptor); String tableName = _dbAdaptor.convertIdentifier(_sessionIdTableSchema.getTableName()); try (ResultSet result = metaData.getTables(null, null, tableName, null)) tableName = _dbAdaptor.convertIdentifier(_sessionTableSchema.getTableName()); try (ResultSet result = metaData.getTables(null, null, tableName, null)) _dbAdaptor.convertIdentifier(_sessionTableSchema.getTableName()), _dbAdaptor.convertIdentifier(_sessionTableSchema.getMaxIntervalColumn()));
connection.setAutoCommit(true); DatabaseMetaData metaData = connection.getMetaData(); _dbAdaptor = new DatabaseAdaptor(metaData); _sessionTableRowId = _dbAdaptor.getRowIdColumnName(); String tableName = _dbAdaptor.convertIdentifier(_sessionIdTable); ResultSet result = metaData.getTables(null, null, tableName, null); if (!result.next()) tableName = _dbAdaptor.convertIdentifier(_sessionTable); result = metaData.getTables(null, null, tableName, null); if (!result.next()) String blobType = _dbAdaptor.getBlobType(); String longType = _dbAdaptor.getLongType(); _createSessionTable = "create table "+_sessionTable+" ("+_sessionTableRowId+" varchar(120), sessionId varchar(120), "+ " contextPath varchar(60), virtualHost varchar(60), lastNode varchar(60), accessTime "+longType+", "+
connection.setAutoCommit(true); DatabaseMetaData metaData = connection.getMetaData(); _dbAdaptor = new DatabaseAdaptor(metaData); _sessionTableRowId = _dbAdaptor.getRowIdColumnName(); String tableName = _dbAdaptor.convertIdentifier(_sessionIdTable); ResultSet result = metaData.getTables(null, null, tableName, null); if (!result.next()) tableName = _dbAdaptor.convertIdentifier(_sessionTable); result = metaData.getTables(null, null, tableName, null); if (!result.next()) String blobType = _dbAdaptor.getBlobType(); String longType = _dbAdaptor.getLongType(); _createSessionTable = "create table "+_sessionTable+" ("+_sessionTableRowId+" varchar(120), sessionId varchar(120), "+ " contextPath varchar(60), virtualHost varchar(60), lastNode varchar(60), accessTime "+longType+", "+
connection.setAutoCommit(true); DatabaseMetaData metaData = connection.getMetaData(); _dbAdaptor = new DatabaseAdaptor(metaData); _sessionTableRowId = _dbAdaptor.getRowIdColumnName(); String tableName = _dbAdaptor.convertIdentifier(_sessionIdTable); ResultSet result = metaData.getTables(null, null, tableName, null); if (!result.next()) tableName = _dbAdaptor.convertIdentifier(_sessionTable); result = metaData.getTables(null, null, tableName, null); if (!result.next()) String blobType = _dbAdaptor.getBlobType(); String longType = _dbAdaptor.getLongType(); _createSessionTable = "create table "+_sessionTable+" ("+_sessionTableRowId+" varchar(120), sessionId varchar(120), "+ " contextPath varchar(60), virtualHost varchar(60), lastNode varchar(60), accessTime "+longType+", "+
connection.setAutoCommit(true); DatabaseMetaData metaData = connection.getMetaData(); _dbAdaptor = new DatabaseAdaptor(metaData); _sessionTableRowId = _dbAdaptor.getRowIdColumnName(); String tableName = _dbAdaptor.convertIdentifier(_sessionIdTable); ResultSet result = metaData.getTables(null, null, tableName, null); if (!result.next()) tableName = _dbAdaptor.convertIdentifier(_sessionTable); result = metaData.getTables(null, null, tableName, null); if (!result.next()) String blobType = _dbAdaptor.getBlobType(); String longType = _dbAdaptor.getLongType(); _createSessionTable = "create table "+_sessionTable+" ("+_sessionTableRowId+" varchar(120), sessionId varchar(120), "+ " contextPath varchar(60), virtualHost varchar(60), lastNode varchar(60), accessTime "+longType+", "+
connection.setAutoCommit(true); DatabaseMetaData metaData = connection.getMetaData(); _dbAdaptor = new DatabaseAdaptor(metaData); _sessionTableRowId = _dbAdaptor.getRowIdColumnName(); String tableName = _dbAdaptor.convertIdentifier(_sessionIdTable); ResultSet result = metaData.getTables(null, null, tableName, null); if (!result.next()) tableName = _dbAdaptor.convertIdentifier(_sessionTable); result = metaData.getTables(null, null, tableName, null); if (!result.next()) String blobType = _dbAdaptor.getBlobType(); String longType = _dbAdaptor.getLongType(); _createSessionTable = "create table "+_sessionTable+" ("+_sessionTableRowId+" varchar(120), sessionId varchar(120), "+ " contextPath varchar(60), virtualHost varchar(60), lastNode varchar(60), accessTime "+longType+", "+
connection.setAutoCommit(true); DatabaseMetaData metaData = connection.getMetaData(); _dbAdaptor = new DatabaseAdaptor(metaData); _sessionTableRowId = _dbAdaptor.getRowIdColumnName(); String tableName = _dbAdaptor.convertIdentifier(_sessionIdTable); ResultSet result = metaData.getTables(null, null, tableName, null); if (!result.next()) tableName = _dbAdaptor.convertIdentifier(_sessionTable); result = metaData.getTables(null, null, tableName, null); if (!result.next()) String blobType = _dbAdaptor.getBlobType(); String longType = _dbAdaptor.getLongType(); _createSessionTable = "create table "+_sessionTable+" ("+_sessionTableRowId+" varchar(120), sessionId varchar(120), "+ " contextPath varchar(60), virtualHost varchar(60), lastNode varchar(60), accessTime "+longType+", "+
session.setVirtualHost(result.getString(_sessionTableSchema.getVirtualHostColumn())); try (InputStream is = ((JDBCSessionIdManager)getSessionIdManager())._dbAdaptor.getBlobInputStream(result, _sessionTableSchema.getMapColumn()); ClassLoadingObjectInputStream ois = new ClassLoadingObjectInputStream(is))
statement = _jdbcSessionIdMgr._dbAdaptor.getLoadStatement(connection, id, canonicalContextPath, vhost); ResultSet result = statement.executeQuery(); if (result.next()) session.setVirtualHost(result.getString("virtualHost")); InputStream is = ((JDBCSessionIdManager)getSessionIdManager())._dbAdaptor.getBlobInputStream(result, "map"); ClassLoadingObjectInputStream ois = new ClassLoadingObjectInputStream (is); Object o = ois.readObject();
statement = _jdbcSessionIdMgr._dbAdaptor.getLoadStatement(connection, id, canonicalContextPath, vhost); ResultSet result = statement.executeQuery(); if (result.next()) session.setVirtualHost(result.getString("virtualHost")); InputStream is = ((JDBCSessionIdManager)getSessionIdManager())._dbAdaptor.getBlobInputStream(result, "map"); ClassLoadingObjectInputStream ois = new ClassLoadingObjectInputStream (is); Object o = ois.readObject();
statement = _jdbcSessionIdMgr._dbAdaptor.getLoadStatement(connection, id, canonicalContextPath, vhost); ResultSet result = statement.executeQuery(); if (result.next()) session.setVirtualHost(result.getString("virtualHost")); InputStream is = ((JDBCSessionIdManager)getSessionIdManager())._dbAdaptor.getBlobInputStream(result, "map"); ClassLoadingObjectInputStream ois = new ClassLoadingObjectInputStream (is); Object o = ois.readObject();
statement = _jdbcSessionIdMgr._dbAdaptor.getLoadStatement(connection, id, canonicalContextPath, vhost); ResultSet result = statement.executeQuery(); if (result.next()) data.setVirtualHost(result.getString("virtualHost")); InputStream is = ((JDBCSessionIdManager)getSessionIdManager())._dbAdaptor.getBlobInputStream(result, "map"); ClassLoadingObjectInputStream ois = new ClassLoadingObjectInputStream (is); Object o = ois.readObject();
statement = _jdbcSessionIdMgr._dbAdaptor.getLoadStatement(connection, id, canonicalContextPath, vhost); ResultSet result = statement.executeQuery(); if (result.next()) data.setVirtualHost(result.getString("virtualHost")); InputStream is = ((JDBCSessionIdManager)getSessionIdManager())._dbAdaptor.getBlobInputStream(result, "map"); ClassLoadingObjectInputStream ois = new ClassLoadingObjectInputStream (is); Object o = ois.readObject();
statement = _jdbcSessionIdMgr._dbAdaptor.getLoadStatement(connection, id, canonicalContextPath, vhost); ResultSet result = statement.executeQuery(); if (result.next()) session.setVirtualHost(result.getString("virtualHost")); InputStream is = ((JDBCSessionIdManager)getSessionIdManager())._dbAdaptor.getBlobInputStream(result, "map"); ClassLoadingObjectInputStream ois = new ClassLoadingObjectInputStream (is); Object o = ois.readObject();
statement = _jdbcSessionIdMgr._dbAdaptor.getLoadStatement(connection, id, canonicalContextPath, vhost); ResultSet result = statement.executeQuery(); if (result.next()) session.setVirtualHost(result.getString("virtualHost")); InputStream is = ((JDBCSessionIdManager)getSessionIdManager())._dbAdaptor.getBlobInputStream(result, "map"); ClassLoadingObjectInputStream ois = new ClassLoadingObjectInputStream (is); Object o = ois.readObject();
session.setVirtualHost(result.getString(_sessionTableSchema.getVirtualHostColumn())); try (InputStream is = ((JDBCSessionIdManager)getSessionIdManager())._dbAdaptor.getBlobInputStream(result, _sessionTableSchema.getMapColumn()); ClassLoadingObjectInputStream ois = new ClassLoadingObjectInputStream(is))
public PreparedStatement getLoadStatement (Connection connection, String rowId, String contextPath, String virtualHosts) throws SQLException { if (_dbAdaptor == null) throw new IllegalStateException("No DB adaptor"); if (contextPath == null || "".equals(contextPath)) { if (_dbAdaptor.isEmptyStringNull()) { PreparedStatement statement = connection.prepareStatement("select * from "+getTableName()+ " where "+getIdColumn()+" = ? and "+ getContextPathColumn()+" is null and "+ getVirtualHostColumn()+" = ?"); statement.setString(1, rowId); statement.setString(2, virtualHosts); return statement; } } PreparedStatement statement = connection.prepareStatement("select * from "+getTableName()+ " where "+getIdColumn()+" = ? and "+getContextPathColumn()+ " = ? and "+getVirtualHostColumn()+" = ?"); statement.setString(1, rowId); statement.setString(2, contextPath); statement.setString(3, virtualHosts); return statement; } }