Class JDBCSessionDataStore.SessionTableSchema
java.lang.Object
org.eclipse.jetty.session.JDBCSessionDataStore.SessionTableSchema
- Enclosing class:
JDBCSessionDataStore
SessionTableSchema
-
Field Summary
FieldsModifier and TypeFieldDescriptionprotected Stringprotected Stringprotected Stringprotected Stringprotected Stringprotected DatabaseAdaptorprotected Stringprotected Stringprotected Stringprotected Stringprotected Stringprotected Stringprotected Stringprotected Stringprotected Stringprotected Stringstatic final Stringstatic final int -
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptiongetCheckSessionExistsStatement(Connection connection, SessionContext context) getCleanOrphansStatement(Connection connection, long timeLimit) getCreateIndexOverExpiryStatementAsString(String indexName) getCreateIndexOverSessionStatementAsString(String indexName) getDeleteStatement(Connection connection, String id, SessionContext contextId) getExpiredSessionsStatement(Connection connection, String canonicalContextPath, String vhost, long expiry) getLoadStatement(Connection connection, String id, SessionContext contextId) getMyExpiredSessionsStatement(Connection connection, SessionContext sessionContext, long expiry) getUpdateSessionStatement(Connection connection, String id, SessionContext context) getUpdateStatement(Connection connection, String id, SessionContext contextId) voidSet up the tables in the databasevoidsetAccessTimeColumn(String accessTimeColumn) voidsetCatalogName(String catalogName) voidsetContextPathColumn(String contextPathColumn) voidsetCookieTimeColumn(String cookieTimeColumn) voidsetCreateTimeColumn(String createTimeColumn) protected voidsetDatabaseAdaptor(DatabaseAdaptor dbadaptor) voidsetExpiryTimeColumn(String expiryTimeColumn) voidsetIdColumn(String idColumn) voidsetLastAccessTimeColumn(String lastAccessTimeColumn) voidsetLastNodeColumn(String lastNodeColumn) voidsetLastSavedTimeColumn(String lastSavedTimeColumn) voidsetMapColumn(String mapColumn) voidsetMaxIntervalColumn(String maxIntervalColumn) voidsetSchemaName(String schemaName) voidsetTableName(String tableName) voidsetVirtualHostColumn(String virtualHostColumn) toString()
-
Field Details
-
MAX_INTERVAL_NOT_SET
public static final int MAX_INTERVAL_NOT_SET- See Also:
-
INFERRED
- See Also:
-
_dbAdaptor
-
_schemaName
-
_catalogName
-
_tableName
-
_idColumn
-
_contextPathColumn
-
_virtualHostColumn
-
_lastNodeColumn
-
_accessTimeColumn
-
_lastAccessTimeColumn
-
_createTimeColumn
-
_cookieTimeColumn
-
_lastSavedTimeColumn
-
_expiryTimeColumn
-
_maxIntervalColumn
-
_mapColumn
-
-
Constructor Details
-
SessionTableSchema
public SessionTableSchema()
-
-
Method Details
-
setDatabaseAdaptor
-
setCatalogName
-
getCatalogName
-
getSchemaName
-
setSchemaName
-
getTableName
-
setTableName
-
getIdColumn
-
setIdColumn
-
getContextPathColumn
-
setContextPathColumn
-
getVirtualHostColumn
-
setVirtualHostColumn
-
getLastNodeColumn
-
setLastNodeColumn
-
getAccessTimeColumn
-
setAccessTimeColumn
-
getLastAccessTimeColumn
-
setLastAccessTimeColumn
-
getCreateTimeColumn
-
setCreateTimeColumn
-
getCookieTimeColumn
-
setCookieTimeColumn
-
getLastSavedTimeColumn
-
setLastSavedTimeColumn
-
getExpiryTimeColumn
-
setExpiryTimeColumn
-
getMaxIntervalColumn
-
setMaxIntervalColumn
-
getMapColumn
-
setMapColumn
-
getCreateStatementAsString
-
getCreateIndexOverExpiryStatementAsString
-
getCreateIndexOverSessionStatementAsString
-
getAlterTableForMaxIntervalAsString
-
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
Set up the tables in the database- Throws:
SQLException- if unable to prepare tables
-
toString
-