org.eclipse.jetty.server.session

Class JDBCSessionIdManager.DatabaseAdaptor

java.lang.Object

org.eclipse.jetty.server.session.JDBCSessionIdManager.DatabaseAdaptor

Enclosing class:

JDBCSessionIdManager

public static 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.

Field Summary

Fields

Modifier and Type	Field and Description
protected String	_blobType
protected String	_longType

Constructor Summary

Constructors

Constructor and Description
JDBCSessionIdManager.DatabaseAdaptor()

Method Summary

Methods

Modifier and Type	Method and Description
void	adaptTo(DatabaseMetaData dbMeta)
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()
String	getLongType()
boolean	isEmptyStringNull()
boolean	isRowIdReserved() rowId is a reserved word for Oracle, so change the name of this column
void	setBlobType(String blobType)
void	setLongType(String longType)

Methods inherited from class java.lang.Object

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

Field Detail

_blobType

protected String _blobType

_longType

protected String _longType

Constructor Detail

JDBCSessionIdManager.DatabaseAdaptor

public JDBCSessionIdManager.DatabaseAdaptor()

Method Detail

adaptTo

public void adaptTo(DatabaseMetaData dbMeta)
             throws SQLException

Throws:

SQLException

setBlobType

public void setBlobType(String blobType)

getBlobType

public String getBlobType()

setLongType

public void setLongType(String longType)

getLongType

public String getLongType()

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()

getBlobInputStream

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

Throws:

SQLException

isEmptyStringNull

public boolean isEmptyStringNull()

isRowIdReserved

public boolean isRowIdReserved()

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

Returns:

true if db in use is oracle