Package org.eclipse.jetty.server.session

Class DatabaseAdaptor

java.lang.Object

org.eclipse.jetty.server.session.DatabaseAdaptor

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

Field Summary

Fields

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

Constructor Summary

Constructors

Constructor	Description
DatabaseAdaptor()

Method Summary

Modifier and Type	Method	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()
protected Connection	getConnection()	Get a connection from the driver or datasource.
String	getConnectionUrl()
DataSource	getDatasource()
String	getDatasourceName()
String	getDBName()
Driver	getDriver()
String	getDriverClassName()
String	getLongType()
String	getStringType()
void	initialize()
boolean	isEmptyStringNull()
boolean	isRowIdReserved()	rowId is a reserved word for Oracle, so change the name of this column
void	setBlobType(String blobType)
void	setDatasource(DataSource ds)
void	setDatasourceName(String jndi)
void	setDriverInfo(String driverClassName, String connectionUrl)	Configure jdbc connection information via a jdbc Driver
void	setDriverInfo(Driver driverClass, String connectionUrl)	Configure jdbc connection information via a jdbc Driver
void	setLongType(String longType)
void	setStringType(String stringType)
String	toString()

Methods inherited from class java.lang.Object

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

Field Details

_blobType

protected String _blobType

_longType

protected String _longType

_stringType

protected String _stringType

Constructor Details

DatabaseAdaptor

public DatabaseAdaptor()

Method Details

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

setStringType

public void setStringType(String stringType)

getStringType

public String getStringType()

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 - the raw 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

setDriverInfo

public void setDriverInfo(String driverClassName,
 String connectionUrl)

Configure jdbc connection information via a jdbc Driver

Parameters:

driverClassName - the driver classname

connectionUrl - the driver connection url

setDriverInfo

public void setDriverInfo(Driver driverClass,
 String connectionUrl)

Configure jdbc connection information via a jdbc Driver

Parameters:

driverClass - the driver class

connectionUrl - the driver connection url

setDatasource

public void setDatasource(DataSource ds)

setDatasourceName

public void setDatasourceName(String jndi)

getDatasourceName

public String getDatasourceName()

getDatasource

public DataSource getDatasource()

getDriverClassName

public String getDriverClassName()

getDriver

public Driver getDriver()

getConnectionUrl

public String getConnectionUrl()

initialize

public void initialize()
                throws Exception

Throws:

Exception

getConnection

protected Connection getConnection()
                            throws SQLException

Get a connection from the driver or datasource.

Returns:

the connection for the datasource

Throws:

SQLException - if unable to get the connection

toString

public String toString()

Overrides:

toString in class Object