Class JDBCSessionDataStore.SessionTableSchema

java.lang.Object
org.eclipse.jetty.session.JDBCSessionDataStore.SessionTableSchema
Enclosing class:
JDBCSessionDataStore

public static class JDBCSessionDataStore.SessionTableSchema extends Object
SessionTableSchema
  • Field Details

    • MAX_INTERVAL_NOT_SET

      public static final int MAX_INTERVAL_NOT_SET
      See Also:
    • INFERRED

      public static final String INFERRED
      See Also:
    • _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