broadwick.data

Class H2Database

java.lang.Object

broadwick.data.H2Database

All Implemented Interfaces:

DatabaseImpl, AutoCloseable

public final class H2Database
extends Object
implements DatabaseImpl

Implementation of a H2 database.

Field Summary

Fields

Modifier and Type	Field and Description
private Connection	connection
private org.h2.jdbcx.JdbcConnectionPool	connectionPool

Constructor Summary

Constructors

Constructor and Description
H2Database(String dbName) Create a new H2 database instance for a given database name.
H2Database(String dbName, boolean deleteDb) Create a new H2 database instance for a given database name.

Method Summary

Modifier and Type	Method and Description
void	close() Close the database connection.
Connection	getConnection() Get a connection to the database.
org.jooq.SQLDialect	getDialect() Obtain the database dialect e.g.
void	open(String database) Open the database for connection.

Methods inherited from class java.lang.Object

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

Field Detail

connection

private Connection connection

connectionPool

private org.h2.jdbcx.JdbcConnectionPool connectionPool

Constructor Detail

H2Database

public H2Database(String dbName)

Create a new H2 database instance for a given database name. If the database does not exist one is created.

Parameters:

dbName - the name of the database to which we will connect.

H2Database

public H2Database(String dbName,
                  boolean deleteDb)

Create a new H2 database instance for a given database name. If the database does not exist one is created, if one exists and the deleteDb is true then the contents of the database are deleted.

Parameters:

dbName - the name of the database to which we will connect.

deleteDb - delete the contents of the database once a connection is made.

Method Detail

open

public void open(String database)

Description copied from interface: DatabaseImpl

Open the database for connection.

Specified by:

open in interface DatabaseImpl

Parameters:

database - the name of the database to open/connect.

close

public void close()

Description copied from interface: DatabaseImpl

Close the database connection.

Specified by:

close in interface DatabaseImpl

Specified by:

close in interface AutoCloseable

getConnection

public Connection getConnection()
                         throws SQLException

Description copied from interface: DatabaseImpl

Get a connection to the database.

Specified by:

getConnection in interface DatabaseImpl

Returns:

the connection object.

Throws:

SQLException - if the connection cannot be obtained.

getDialect

public org.jooq.SQLDialect getDialect()

Description copied from interface: DatabaseImpl

Obtain the database dialect e.g. SQLDialect.MYSQL or SQLDialect.H2.

Specified by:

getDialect in interface DatabaseImpl

Returns:

the SQLDialect of the database.