org.jminor.dbms.sqlite

Class SQLiteDatabase

java.lang.Object

org.jminor.common.db.AbstractDatabase

org.jminor.dbms.sqlite.SQLiteDatabase

All Implemented Interfaces:

Database

public final class SQLiteDatabase
extends AbstractDatabase

A SQLite embedded database implementation, quite experimental, based on the xerial/sqlite-jdbc driver.

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
SQLiteDatabase() Instantiates a new embedded SQLiteDatabase, using Database.DATABASE_HOST for database file path.
SQLiteDatabase(java.lang.String databaseFilePath) Instantiates a new embedded SQLiteDatabase

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	getURL(java.util.Properties connectionProperties)
boolean	isReferentialIntegrityException(java.sql.SQLException exception) This default implementation returns false
boolean	supportsNowait() Returns true if the dbms supports the select for update NOWAIT option

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

addConnectionProperties, createConnection, getAuthenticationInfo, getCheckConnectionQuery, getDriverClassName, getErrorMessage, getHost, getLoginTimeout, getPort, getSequenceQuery, getSid, getType, getUrlAppend, isAuthenticationException, isEmbedded, isUniqueConstraintException, setUrlAppend, shutdownEmbedded, supportsIsValid, 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

SQLiteDatabase

public SQLiteDatabase()

Instantiates a new embedded SQLiteDatabase, using Database.DATABASE_HOST for database file path.

SQLiteDatabase

public SQLiteDatabase(java.lang.String databaseFilePath)

Instantiates a new embedded SQLiteDatabase

Parameters:

databaseFilePath - the path to the database file

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

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

supportsNowait

public boolean supportsNowait()

Returns true if the dbms supports the select for update NOWAIT option

Specified by:

supportsNowait in interface Database

Overrides:

supportsNowait in class AbstractDatabase

Returns:

true if NOWAIT is supported for select for update

isReferentialIntegrityException

public boolean isReferentialIntegrityException(java.sql.SQLException exception)

Description copied from class: AbstractDatabase

This default implementation returns false

Specified by:

isReferentialIntegrityException in interface Database

Overrides:

isReferentialIntegrityException in class AbstractDatabase

Parameters:

exception - the exception

Returns:

true if this exception is a referential integrity error