Package org.eclipse.jetty.server.session

Class JDBCSessionDataStore.SessionTableSchema

java.lang.Object

org.eclipse.jetty.server.session.JDBCSessionDataStore.SessionTableSchema

Enclosing class:

JDBCSessionDataStore

public static class JDBCSessionDataStore.SessionTableSchema
extends Object

SessionTableSchema

Field Summary

Fields

Modifier and Type	Field	Description
protected String	_accessTimeColumn
protected String	_catalogName
protected String	_contextPathColumn
protected String	_cookieTimeColumn
protected String	_createTimeColumn
protected DatabaseAdaptor	_dbAdaptor
protected String	_expiryTimeColumn
protected String	_idColumn
protected String	_lastAccessTimeColumn
protected String	_lastNodeColumn
protected String	_lastSavedTimeColumn
protected String	_mapColumn
protected String	_maxIntervalColumn
protected String	_schemaName
protected String	_tableName
protected String	_virtualHostColumn
static final String	INFERRED
static final int	MAX_INTERVAL_NOT_SET

Constructor Summary

Constructors

Constructor	Description
SessionTableSchema()

Method Summary

Modifier and Type	Method	Description
String	getAccessTimeColumn()
String	getAlterTableForMaxIntervalAsString()
String	getCatalogName()
PreparedStatement	getCheckSessionExistsStatement(Connection connection, SessionContext context)
PreparedStatement	getCleanOrphansStatement(Connection connection, long timeLimit)
String	getContextPathColumn()
String	getCookieTimeColumn()
String	getCreateIndexOverExpiryStatementAsString(String indexName)
String	getCreateIndexOverSessionStatementAsString(String indexName)
String	getCreateStatementAsString()
String	getCreateTimeColumn()
PreparedStatement	getDeleteStatement(Connection connection, String id, SessionContext contextId)
PreparedStatement	getExpiredSessionsStatement(Connection connection, String canonicalContextPath, String vhost, long expiry)
String	getExpiryTimeColumn()
String	getIdColumn()
String	getInsertSessionStatementAsString()
String	getLastAccessTimeColumn()
String	getLastNodeColumn()
String	getLastSavedTimeColumn()
PreparedStatement	getLoadStatement(Connection connection, String id, SessionContext contextId)
String	getMapColumn()
String	getMaxIntervalColumn()
PreparedStatement	getMyExpiredSessionsStatement(Connection connection, SessionContext sessionContext, long expiry)
String	getSchemaName()
String	getTableName()
PreparedStatement	getUpdateSessionStatement(Connection connection, String id, SessionContext context)
PreparedStatement	getUpdateStatement(Connection connection, String id, SessionContext contextId)
String	getVirtualHostColumn()
void	prepareTables()	Set up the tables in the database
void	setAccessTimeColumn(String accessTimeColumn)
void	setCatalogName(String catalogName)
void	setContextPathColumn(String contextPathColumn)
void	setCookieTimeColumn(String cookieTimeColumn)
void	setCreateTimeColumn(String createTimeColumn)
protected void	setDatabaseAdaptor(DatabaseAdaptor dbadaptor)
void	setExpiryTimeColumn(String expiryTimeColumn)
void	setIdColumn(String idColumn)
void	setLastAccessTimeColumn(String lastAccessTimeColumn)
void	setLastNodeColumn(String lastNodeColumn)
void	setLastSavedTimeColumn(String lastSavedTimeColumn)
void	setMapColumn(String mapColumn)
void	setMaxIntervalColumn(String maxIntervalColumn)
void	setSchemaName(String schemaName)
void	setTableName(String tableName)
void	setVirtualHostColumn(String virtualHostColumn)
String	toString()

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Field Details

MAX_INTERVAL_NOT_SET

public static final int MAX_INTERVAL_NOT_SET

See Also:

• Constant Field Values

INFERRED

public static final String INFERRED

See Also:

• Constant Field Values

_dbAdaptor

protected DatabaseAdaptor _dbAdaptor

_schemaName

protected String _schemaName

_catalogName

protected String _catalogName

_tableName

protected String _tableName

_idColumn

protected String _idColumn

_contextPathColumn

protected String _contextPathColumn

_virtualHostColumn

protected String _virtualHostColumn

_lastNodeColumn

protected String _lastNodeColumn

_accessTimeColumn

protected String _accessTimeColumn

_lastAccessTimeColumn

protected String _lastAccessTimeColumn

_createTimeColumn

protected String _createTimeColumn

_cookieTimeColumn

protected String _cookieTimeColumn

_lastSavedTimeColumn

protected String _lastSavedTimeColumn

_expiryTimeColumn

protected String _expiryTimeColumn

_maxIntervalColumn

protected String _maxIntervalColumn

_mapColumn

protected String _mapColumn

Constructor Details

SessionTableSchema

public SessionTableSchema()

Method Details

setDatabaseAdaptor

protected void setDatabaseAdaptor(DatabaseAdaptor dbadaptor)

setCatalogName

public void setCatalogName(String catalogName)

getCatalogName

public String getCatalogName()

getSchemaName

public String getSchemaName()

setSchemaName

public void setSchemaName(String schemaName)

getTableName

public String getTableName()

setTableName

public void setTableName(String tableName)

getIdColumn

public String getIdColumn()

setIdColumn

public void setIdColumn(String idColumn)

getContextPathColumn

public String getContextPathColumn()

setContextPathColumn

public void setContextPathColumn(String contextPathColumn)

getVirtualHostColumn

public String getVirtualHostColumn()

setVirtualHostColumn

public void setVirtualHostColumn(String virtualHostColumn)

getLastNodeColumn

public String getLastNodeColumn()

setLastNodeColumn

public void setLastNodeColumn(String lastNodeColumn)

getAccessTimeColumn

public String getAccessTimeColumn()

setAccessTimeColumn

public void setAccessTimeColumn(String accessTimeColumn)

getLastAccessTimeColumn

public String getLastAccessTimeColumn()

setLastAccessTimeColumn

public void setLastAccessTimeColumn(String lastAccessTimeColumn)

getCreateTimeColumn

public String getCreateTimeColumn()

setCreateTimeColumn

public void setCreateTimeColumn(String createTimeColumn)

getCookieTimeColumn

public String getCookieTimeColumn()

setCookieTimeColumn

public void setCookieTimeColumn(String cookieTimeColumn)

getLastSavedTimeColumn

public String getLastSavedTimeColumn()

setLastSavedTimeColumn

public void setLastSavedTimeColumn(String lastSavedTimeColumn)

getExpiryTimeColumn

public String getExpiryTimeColumn()

setExpiryTimeColumn

public void setExpiryTimeColumn(String expiryTimeColumn)

getMaxIntervalColumn

public String getMaxIntervalColumn()

setMaxIntervalColumn

public void setMaxIntervalColumn(String maxIntervalColumn)

getMapColumn

public String getMapColumn()

setMapColumn

public void setMapColumn(String mapColumn)

getCreateStatementAsString

public String getCreateStatementAsString()

getCreateIndexOverExpiryStatementAsString

public String getCreateIndexOverExpiryStatementAsString(String indexName)

getCreateIndexOverSessionStatementAsString

public String getCreateIndexOverSessionStatementAsString(String indexName)

getAlterTableForMaxIntervalAsString

public String getAlterTableForMaxIntervalAsString()

getInsertSessionStatementAsString

public String getInsertSessionStatementAsString()

getUpdateSessionStatement

public PreparedStatement getUpdateSessionStatement(Connection connection,
 String id,
 SessionContext context)
                                            throws SQLException

Throws:

SQLException

getExpiredSessionsStatement

public PreparedStatement getExpiredSessionsStatement(Connection connection,
 String canonicalContextPath,
 String vhost,
 long expiry)
                                              throws SQLException

Throws:

SQLException

getMyExpiredSessionsStatement

public PreparedStatement getMyExpiredSessionsStatement(Connection connection,
 SessionContext sessionContext,
 long expiry)
                                                throws SQLException

Throws:

SQLException

getCheckSessionExistsStatement

public PreparedStatement getCheckSessionExistsStatement(Connection connection,
 SessionContext context)
                                                 throws SQLException

Throws:

SQLException

getLoadStatement

public PreparedStatement getLoadStatement(Connection connection,
 String id,
 SessionContext contextId)
                                   throws SQLException

Throws:

SQLException

getUpdateStatement

public PreparedStatement getUpdateStatement(Connection connection,
 String id,
 SessionContext contextId)
                                     throws SQLException

Throws:

SQLException

getDeleteStatement

public PreparedStatement getDeleteStatement(Connection connection,
 String id,
 SessionContext contextId)
                                     throws Exception

Throws:

Exception

getCleanOrphansStatement

public PreparedStatement getCleanOrphansStatement(Connection connection,
 long timeLimit)
                                           throws Exception

Throws:

Exception

prepareTables

public void prepareTables()
                   throws SQLException

Set up the tables in the database

Throws:

SQLException - if unable to prepare tables

toString

public String toString()

Overrides:

toString in class Object