org.jminor.dbms.hsqldb

Class HSQLDatabase

java.lang.Object

org.jminor.common.db.AbstractDatabase

org.jminor.dbms.hsqldb.HSQLDatabase

All Implemented Interfaces:

Database

public final class HSQLDatabase
extends AbstractDatabase

A Database implementation based on the HSQL database.

Nested Class Summary

Nested classes/interfaces inherited from interface org.jminor.common.db.Database

Database.Statistics, Database.Type

Field Summary

Fields inherited from interface org.jminor.common.db.Database

DATABASE_EMBEDDED, DATABASE_EMBEDDED_IN_MEMORY, DATABASE_HOST, DATABASE_INIT_SCRIPT, DATABASE_PORT, DATABASE_SID, DATABASE_TYPE, DEFAULT_LOGIN_TIMEOUT, PASSWORD_PROPERTY, USER_PROPERTY

Constructor Summary

Constructors

Constructor and Description
HSQLDatabase() Instantiates a new H2Database.
HSQLDatabase(java.lang.String databaseName) Instantiates a new embedded HSQLDatabase.
HSQLDatabase(java.lang.String host, java.lang.Integer port, java.lang.String sid) Instantiates a new networked HSQLDatabase.

Method Summary

Modifier and Type	Method and Description
java.lang.String	getAutoIncrementQuery(java.lang.String idSource) Returns a query string for retrieving the last automatically generated id from the given id source
java.lang.String	getSequenceQuery(java.lang.String sequenceName)
java.lang.String	getURL(java.util.Properties connectionProperties)

Methods inherited from class org.jminor.common.db.AbstractDatabase

addConnectionProperties, createConnection, getAuthenticationInfo, getCheckConnectionQuery, getDriverClassName, getErrorMessage, getHost, getLoginTimeout, getPort, getSid, getType, getUrlAppend, isAuthenticationException, isEmbedded, isReferentialIntegrityException, isUniqueConstraintException, setUrlAppend, shutdownEmbedded, supportsIsValid, supportsNowait, supportsSelectForUpdate

Methods inherited from class java.lang.Object

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

Methods inherited from interface org.jminor.common.db.Database

getDatabaseType

Constructor Detail

HSQLDatabase

public HSQLDatabase()

Instantiates a new H2Database.

HSQLDatabase

public HSQLDatabase(java.lang.String databaseName)

Instantiates a new embedded HSQLDatabase.

Parameters:

databaseName - the path to the database files

HSQLDatabase

public HSQLDatabase(java.lang.String host,
                    java.lang.Integer port,
                    java.lang.String sid)

Instantiates a new networked HSQLDatabase.

Parameters:

host - the host name

port - the port number

sid - the service identifier

Method Detail

getAutoIncrementQuery

public java.lang.String getAutoIncrementQuery(java.lang.String idSource)

Returns a query string for retrieving the last automatically generated id from the given id source

Parameters:

idSource - the source for the id, for example a sequence name or in the case of Derby, the name of the table auto generating the value

Returns:

a query string for retrieving the last auto-increment value from idSource

getSequenceQuery

public java.lang.String getSequenceQuery(java.lang.String sequenceName)

Specified by:

getSequenceQuery in interface Database

Overrides:

getSequenceQuery in class AbstractDatabase

Parameters:

sequenceName - the name of the sequence

Returns:

a query for selecting the next value from the given sequence

getURL

public java.lang.String getURL(java.util.Properties connectionProperties)

Parameters:

connectionProperties - the connection properties, used primarily to provide embedded databases with user info for authentication purposes

Returns:

the database url of the active database, based on system properties