Package marauroa.server.db.adapter

Class H2DatabaseAdapter

java.lang.Object

marauroa.server.db.adapter.AbstractDatabaseAdapter

marauroa.server.db.adapter.H2DatabaseAdapter

All Implemented Interfaces:

DatabaseAdapter

public class H2DatabaseAdapter
extends AbstractDatabaseAdapter

abstracts from H2 specifications

Author:

hendrik

Field Summary

Fields inherited from class marauroa.server.db.adapter.AbstractDatabaseAdapter

connection, resultSets, statements

Constructor Summary

Constructors

Modifier	Constructor	Description
protected	H2DatabaseAdapter()	creates a new H2Adapter for test purposes, without connection to the DB
	H2DatabaseAdapter(Properties connInfo)	creates a new H2Adapter

Method Summary

Modifier and Type	Method	Description
protected Connection	createConnection(Properties connInfo)	This method creates the real connection to database.
boolean	doesColumnExist(String table, String column)	checks whether the specified column exists
boolean	doesTableExist(String table)	checks whether the specified table exists
int	getColumnLength(String table, String column)	Gets the length of the specified column
protected String	rewriteSql(String sql)	rewrites ALTER TABLE statements to remove the "COLUMNS (" part

Methods inherited from class marauroa.server.db.adapter.AbstractDatabaseAdapter

close, commit, execute, execute, executeBatch, getLastInsertId, isConnectionError, prepareStatement, query, querySingleCellInt, rollback, verifyConnection

Methods inherited from class java.lang.Object

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

Constructor Details

H2DatabaseAdapter

public H2DatabaseAdapter(Properties connInfo)
                  throws DatabaseConnectionException

creates a new H2Adapter

Parameters:

connInfo - parameters specifying the connection

Throws:

DatabaseConnectionException - if the connection cannot be established.

H2DatabaseAdapter

protected H2DatabaseAdapter()
                     throws DatabaseConnectionException

creates a new H2Adapter for test purposes, without connection to the DB

Throws:

DatabaseConnectionException - if the connection cannot be established.

Method Details

createConnection

protected Connection createConnection(Properties connInfo)
                               throws SQLException,
DatabaseConnectionException

Description copied from class: AbstractDatabaseAdapter

This method creates the real connection to database.

Overrides:

createConnection in class AbstractDatabaseAdapter

Parameters:

connInfo - connection information like url, username and password

Returns:

a connection to the database

Throws:

SQLException - if the connection cannot be established.

DatabaseConnectionException - if the connection cannot be established.

rewriteSql

protected String rewriteSql(String sql)

rewrites ALTER TABLE statements to remove the "COLUMNS (" part

Overrides:

rewriteSql in class AbstractDatabaseAdapter

Parameters:

sql - original SQL statement

Returns:

modified SQL statement

doesTableExist

public boolean doesTableExist(String table)
                       throws SQLException

Description copied from interface: DatabaseAdapter

checks whether the specified table exists

Specified by:

doesTableExist in interface DatabaseAdapter

Overrides:

doesTableExist in class AbstractDatabaseAdapter

Parameters:

table - name of table

Returns:

true, if the table exists, false otherwise

Throws:

SQLException - in case of an database error

doesColumnExist

public boolean doesColumnExist(String table,
 String column)
                        throws SQLException

Description copied from interface: DatabaseAdapter

checks whether the specified column exists

Specified by:

doesColumnExist in interface DatabaseAdapter

Overrides:

doesColumnExist in class AbstractDatabaseAdapter

Parameters:

table - name of table

column - name of column

Returns:

true, if the column exists, false otherwise

Throws:

SQLException - in case of an database error

getColumnLength

public int getColumnLength(String table,
 String column)
                    throws SQLException

Description copied from interface: DatabaseAdapter

Gets the length of the specified column

Specified by:

getColumnLength in interface DatabaseAdapter

Overrides:

getColumnLength in class AbstractDatabaseAdapter

Parameters:

table - name of table

column - name of column

Returns:

the length of the column or -1 if no column with the given name in the given table exists

Throws:

SQLException - in case of an database error