Package org.dbunit.database

Class DatabaseConnection

java.lang.Object

org.dbunit.database.AbstractDatabaseConnection

org.dbunit.database.DatabaseConnection

All Implemented Interfaces:

IDatabaseConnection

Direct Known Subclasses:

Db2Connection, H2Connection, HsqldbConnection, MckoiConnection, MsSqlConnection, MySqlConnection, OracleConnection

public class DatabaseConnection
extends AbstractDatabaseConnection
implements IDatabaseConnection

This class adapts a JDBC Connection to a IDatabaseConnection.

Since:

Feb 21, 2002

Version:

$Revision$

Author:

Manuel Laflamme

Constructor Summary

Constructors

Constructor	Description
DatabaseConnection(Connection connection)	Creates a new DatabaseConnection.
DatabaseConnection(Connection connection, String schema)	Creates a new DatabaseConnection using a specific schema.
DatabaseConnection(Connection connection, String schema, boolean validate)	Creates a new DatabaseConnection using a specific schema.

Method Summary

Modifier and Type	Method	Description
void	close()	Close this connection.
Connection	getConnection()	Returns a JDBC database connection.
String	getSchema()	Returns the database schema name.
String	toString()

Methods inherited from class org.dbunit.database.AbstractDatabaseConnection

createDataSet, createDataSet, createQueryTable, createTable, createTable, getConfig, getRowCount, getRowCount, getStatementFactory

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

createDataSet, createDataSet, createQueryTable, createTable, createTable, getConfig, getRowCount, getRowCount, getStatementFactory

Constructor Details

DatabaseConnection

public DatabaseConnection(Connection connection)
                   throws DatabaseUnitException

Creates a new DatabaseConnection.

Parameters:

connection - the adapted JDBC connection

Throws:

DatabaseUnitException

DatabaseConnection

public DatabaseConnection(Connection connection,
 String schema)
                   throws DatabaseUnitException

Creates a new DatabaseConnection using a specific schema.

Parameters:

connection - the adapted JDBC connection

schema - the database schema. Note that the schema name is case sensitive. This is necessary because schemas with the same name but different case can coexist on one database.
Here an example that creates two users/schemas for oracle where only the case is different:
create user dbunittest identified by dbunittest; create user "dbunittest" identified by "dbunittest"; The first one creates the "default" user where everything is interpreted by oracle in uppercase. The second one is completely lowercase because of the quotes.

Throws:

DatabaseUnitException

DatabaseConnection

public DatabaseConnection(Connection connection,
 String schema,
 boolean validate)
                   throws DatabaseUnitException

Creates a new DatabaseConnection using a specific schema.

Parameters:

connection - the adapted JDBC connection

schema - the database schema. Note that the schema name is case sensitive. This is necessary because schemas with the same name but different case can coexist on one database.
Here an example that creates two users/schemas for oracle where only the case is different:
create user dbunittest identified by dbunittest; create user "dbunittest" identified by "dbunittest"; The first one creates the "default" user where everything is interpreted by oracle in uppercase. The second one is completely lowercase because of the quotes.

validate - If true an exception is thrown when the given schema does not exist according to the DatabaseMetaData. If false the validation will only print a warning if the schema was not found.

Throws:

DatabaseUnitException - If the validate parameter is true and the validation of the given connection/schema was not successful (added with 2.3.0). This can happen if the given schema does not exist or if the jdbc driver does not implement the metaData.getSchemas() method properly.

Since:

2.3.0

Method Details

getConnection

public Connection getConnection()
                         throws SQLException

Description copied from interface: IDatabaseConnection

Returns a JDBC database connection.

Specified by:

getConnection in interface IDatabaseConnection

Throws:

SQLException

getSchema

public String getSchema()

Description copied from interface: IDatabaseConnection

Returns the database schema name.

Specified by:

getSchema in interface IDatabaseConnection

close

public void close()
           throws SQLException

Description copied from interface: IDatabaseConnection

Close this connection.

Specified by:

close in interface IDatabaseConnection

Throws:

SQLException

toString

public String toString()

Overrides:

toString in class AbstractDatabaseConnection