Package org.eclipse.jetty.session
Class JDBCSessionDataStore.SessionTableSchema
java.lang.Object
org.eclipse.jetty.session.JDBCSessionDataStore.SessionTableSchema
- Enclosing class:
- JDBCSessionDataStore
SessionTableSchema
-
Field Summary
Modifier and TypeFieldDescriptionprotected String
protected String
protected String
protected String
protected String
protected DatabaseAdaptor
protected String
protected String
protected String
protected String
protected String
protected String
protected String
protected String
protected String
protected String
static final String
static final int
-
Constructor Summary
-
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) void
Set up the tables in the databasevoid
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) 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
-