org.eclipse.jetty.server.session

## Class JDBCSessionIdManager.DatabaseAdaptor

- java.lang.Object
- - org.eclipse.jetty.server.session.JDBCSessionIdManager.DatabaseAdaptor

- Enclosing class:
    JDBCSessionIdManager

      public class JDBCSessionIdManager.DatabaseAdaptor
      extends Object

  DatabaseAdaptor Handles differences between databases. Postgres uses the getBytes and setBinaryStream methods to access a "bytea" datatype, which can be up to 1Gb of binary data. MySQL is happy to use the "blob" type and getBlob() methods instead. TODO if the differences become more major it would be worthwhile refactoring this class.

- - ### Constructor Summary

    Constructors
    Constructor and Description
    `JDBCSessionIdManager.DatabaseAdaptor(DatabaseMetaData dbMeta)`

  - ### Method Summary

    Methods
    Modifier and Type | Method and Description
    --- | ---
    `String` | `convertIdentifier(String identifier)` Convert a camel case identifier into either upper or lower depending on the way the db stores identifiers.
    `InputStream` | `getBlobInputStream(ResultSet result, String columnName)`
    `String` | `getBlobType()`
    `String` | `getDBName()`
    `PreparedStatement` | `getLoadStatement(Connection connection, String rowId, String contextPath, String virtualHosts)`
    `String` | `getLongType()`
    `String` | `getRowIdColumnName()` rowId is a reserved word for Oracle, so change the name of this column
    `boolean` | `isEmptyStringNull()`

    - ### Methods inherited from class java.lang.Object

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

- - ### Constructor Detail

    - #### JDBCSessionIdManager.DatabaseAdaptor

          public JDBCSessionIdManager.DatabaseAdaptor(DatabaseMetaData dbMeta)
                                               throws SQLException

      Throws:
        `SQLException`

  - ### Method Detail

    - #### convertIdentifier

          public String convertIdentifier(String identifier)

      Convert a camel case identifier into either upper or lower depending on the way the db stores identifiers.
      Parameters:
        `identifier` -
      Returns:
        the converted identifier

    - #### getDBName

          public String getDBName()

    - #### getBlobType

          public String getBlobType()

    - #### getLongType

          public String getLongType()

    - #### getBlobInputStream

          public InputStream getBlobInputStream(ResultSet result,
                                       String columnName)
                                         throws SQLException

      Throws:
        `SQLException`

    - #### getRowIdColumnName

          public String getRowIdColumnName()

      rowId is a reserved word for Oracle, so change the name of this column
      Returns:

    - #### isEmptyStringNull

          public boolean isEmptyStringNull()

    - #### getLoadStatement

          public PreparedStatement getLoadStatement(Connection connection,
                                           String rowId,
                                           String contextPath,
                                           String virtualHosts)
                                             throws SQLException

      Throws:
        `SQLException`

Copyright © 1995-2016 Mort Bay Consulting. All Rights Reserved.