Package org.dbunit.database

Class AbstractDatabaseConnection

java.lang.Object

org.dbunit.database.AbstractDatabaseConnection

All Implemented Interfaces:

IDatabaseConnection

Direct Known Subclasses:

DatabaseConnection, DatabaseDataSourceConnection

public abstract class AbstractDatabaseConnection
extends Object
implements IDatabaseConnection

Base implementation of IDatabaseConnection that lazily creates and caches the connection's whole-database IDataSet and owns its DatabaseConfig.

Since:

Mar 6, 2002

Version:

$Revision$

Author:

Manuel Laflamme

Constructor Summary

Constructors

Constructor	Description
AbstractDatabaseConnection()	Creates a connection with a new, default DatabaseConfig.

Method Summary

Modifier and Type	Method	Description
IDataSet	createDataSet()	Creates a dataset corresponding to the entire database.
IDataSet	createDataSet(String[] tableNames)	Creates a dataset containing only the specified tables from the database.
ITable	createQueryTable(String resultName, String sql)	Creates a table with the result of the specified SQL statement.
ITable	createTable(String tableName)	Creates a table with the result of a select * from tableName SQL statement.
ITable	createTable(String resultName, PreparedStatement preparedStatement)	Creates a table using the given PreparedStatement to retrieve a ResultSet.
DatabaseConfig	getConfig()	Returns this connection database configuration
int	getRowCount(String tableName)	Returns the specified table row count.
int	getRowCount(String tableName, String whereClause)	Returns the specified table row count according specified where clause.
IStatementFactory	getStatementFactory()	Deprecated. Use getConfig()
String	toString()

Methods inherited from class java.lang.Object

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

Methods inherited from interface org.dbunit.database.IDatabaseConnection

close, getConnection, getSchema

Constructor Details

AbstractDatabaseConnection

public AbstractDatabaseConnection()

Creates a connection with a new, default DatabaseConfig.

Method Details

createDataSet

public IDataSet createDataSet()
                       throws SQLException

Description copied from interface: IDatabaseConnection

Creates a dataset corresponding to the entire database.

Specified by:

createDataSet in interface IDatabaseConnection

Returns:

the new dataset.

Throws:

SQLException - if a database access error occurs.

createDataSet

public IDataSet createDataSet(String[] tableNames)
                       throws DataSetException,
SQLException

Description copied from interface: IDatabaseConnection

Creates a dataset containing only the specified tables from the database.

Specified by:

createDataSet in interface IDatabaseConnection

Parameters:

tableNames - The tables for which a dataset shall be created

Returns:

The new dataset

Throws:

DataSetException - if a table in tableNames does not exist in the database.

SQLException - if a database access error occurs.

createQueryTable

public ITable createQueryTable(String resultName,
 String sql)
                        throws DataSetException,
SQLException

Description copied from interface: IDatabaseConnection

Creates a table with the result of the specified SQL statement. The table can be the result of a join statement.

Specified by:

createQueryTable in interface IDatabaseConnection

Parameters:

resultName - The name to be returned by ITableMetaData.getTableName().

sql - The SQL SELECT statement

Returns:

The new table

Throws:

DataSetException - if an error occurs building the table's metadata.

SQLException - if a database access error occurs.

createTable

public ITable createTable(String resultName,
 PreparedStatement preparedStatement)
                   throws DataSetException,
SQLException

Description copied from interface: IDatabaseConnection

Creates a table using the given PreparedStatement to retrieve a ResultSet.

Specified by:

createTable in interface IDatabaseConnection

Parameters:

resultName - The name to be returned by ITableMetaData.getTableName().

preparedStatement - The statement to be executed as query

Returns:

The new table

Throws:

DataSetException - if an error occurs building the table's metadata.

SQLException - if a database access error occurs.

createTable

public ITable createTable(String tableName)
                   throws DataSetException,
SQLException

Description copied from interface: IDatabaseConnection

Creates a table with the result of a select * from tableName SQL statement.

Specified by:

createTable in interface IDatabaseConnection

Parameters:

tableName - The name of the database table to be queried which is also returned by ITableMetaData.getTableName().

Returns:

The new table.

Throws:

DataSetException - if an error occurs building the table's metadata.

SQLException - if a database access error occurs.

getRowCount

public int getRowCount(String tableName)
                throws SQLException

Description copied from interface: IDatabaseConnection

Returns the specified table row count.

Specified by:

getRowCount in interface IDatabaseConnection

Parameters:

tableName - the table name

Returns:

the row count

Throws:

SQLException - if a database access error occurs.

getRowCount

public int getRowCount(String tableName,
 String whereClause)
                throws SQLException

Description copied from interface: IDatabaseConnection

Returns the specified table row count according specified where clause.

Specified by:

getRowCount in interface IDatabaseConnection

Parameters:

tableName - the table name

whereClause - the where clause

Returns:

the row count

Throws:

SQLException - if a database access error occurs.

getConfig

public DatabaseConfig getConfig()

Description copied from interface: IDatabaseConnection

Returns this connection database configuration

Specified by:

getConfig in interface IDatabaseConnection

Returns:

this connection's DatabaseConfig.

getStatementFactory

@Deprecated
public IStatementFactory getStatementFactory()

Deprecated.

Use getConfig()

Description copied from interface: IDatabaseConnection

Returns the statement factory configured on this connection.

Specified by:

getStatementFactory in interface IDatabaseConnection

Returns:

this connection's IStatementFactory.

toString

public String toString()

Overrides:

toString in class Object