org.alfresco.extension.environment.validation.validators.database

Class AbstractDBSpecificValidator

java.lang.Object

org.alfresco.extension.environment.validation.ValidatorCallbackHelper

org.alfresco.extension.environment.validation.validators.database.AbstractDBSpecificValidator

All Implemented Interfaces:

DBSpecificValidator

Direct Known Subclasses:

com_ibm_db2_jcc_DB2Driver, net_sourceforge_jtds_jdbc_Driver, oracle_jdbc_OracleDriver, org_gjt_mm_mysql_Driver, org_postgresql_Driver

public abstract class AbstractDBSpecificValidator
extends ValidatorCallbackHelper
implements DBSpecificValidator

This class is a useful base class for database-specific validators.

Author:

Peter Monks (pmonks@alfresco.com)

Constructor Summary

Constructors

Constructor and Description
AbstractDBSpecificValidator()

Method Summary

Methods

Modifier and Type	Method and Description
protected List	getColumnNames(ResultSetMetaData metadata)
protected ComparablePair	getJDBCDriverVersion(Connection con)
protected List	query(Connection con, String sqlSelect) Executes a SQL SELECT statement and returns the result as a List of Maps.
protected Map	singletonQuery(Connection con, String sqlSelect)
protected void	sql(Connection con, String sql) Simple method for executing any arbitrary statement and ignoring the result (including any success / failure conditions).
protected void	validateJdbcDriverVersion(ValidatorCallback callback, Connection con, ComparablePair[] supportedVersions, String[] urisForMoreInformation)

Methods inherited from class org.alfresco.extension.environment.validation.ValidatorCallbackHelper

endTest, newTopic, progress, startTest

Methods inherited from class java.lang.Object

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

Methods inherited from interface org.alfresco.extension.environment.validation.validators.database.DBSpecificValidator

validate

Constructor Detail

AbstractDBSpecificValidator

public AbstractDBSpecificValidator()

Method Detail

sql

protected void sql(Connection con,
       String sql)
            throws SQLException

Simple method for executing any arbitrary statement and ignoring the result (including any success / failure conditions).

Parameters:

con - The database connection to use (must not be null).

sqlSelect - The SQL statement to execute (must not be null, empty or blank).

Throws:

SQLException

singletonQuery

protected Map singletonQuery(Connection con,
                 String sqlSelect)
                      throws SQLException

Throws:

SQLException

query

protected List query(Connection con,
         String sqlSelect)
              throws SQLException

Executes a SQL SELECT statement and returns the result as a List of Maps.

Parameters:

con - The database connection to use (must not be null).

sqlSelect - The SQL SELECT statement to execute (must not be null, empty or blank).

Returns:

Throws:

SQLException

getColumnNames

protected List getColumnNames(ResultSetMetaData metadata)
                       throws SQLException

Throws:

SQLException

validateJdbcDriverVersion

protected void validateJdbcDriverVersion(ValidatorCallback callback,
                             Connection con,
                             ComparablePair[] supportedVersions,
                             String[] urisForMoreInformation)

getJDBCDriverVersion

protected ComparablePair getJDBCDriverVersion(Connection con)
                                       throws SQLException

Throws:

SQLException