org.apache.manifoldcf.core.database

Class DBInterfaceHSQLDB

java.lang.Object

org.apache.manifoldcf.core.database.Database

org.apache.manifoldcf.core.database.DBInterfaceHSQLDB

All Implemented Interfaces:

IDBInterface

public class DBInterfaceHSQLDB
extends Database
implements IDBInterface

This is the HSQLDB implementation of the IDBInterface class.

Nested Class Summary

Nested classes/interfaces inherited from class org.apache.manifoldcf.core.database.Database

Database.ExecuteQueryThread, Database.Modifications, Database.QueryCacheExecutor

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.String	_rcsid
protected java.lang.String	cacheKey
static java.lang.String	databaseInstanceProperty
static java.lang.String	databasePathProperty
static java.lang.String	databasePortProperty
static java.lang.String	databaseProtocolProperty
static java.lang.String	databaseServerProperty
protected int	depthCount
protected int	desiredTransactionType
protected boolean	inTransaction
protected boolean	isRemote
protected java.lang.String	schemaNameForQueries
protected int	serializableDepth

Fields inherited from class org.apache.manifoldcf.core.database.Database

_TRANSACTION_, cacheManager, commitDone, connection, context, databaseName, debug, delayedTransactionDepth, doRollback, jdbcDriverClass, jdbcUrl, maxDBConnections, maxQueryTime, modificationsSet, password, random, th, userName

Fields inherited from interface org.apache.manifoldcf.core.interfaces.IDBInterface

TRANSACTION_ENCLOSING, TRANSACTION_READCOMMITTED, TRANSACTION_REPEATABLEREAD, TRANSACTION_SERIALIZED

Constructor Summary

Constructors

Constructor and Description
DBInterfaceHSQLDB(IThreadContext tc, java.lang.String databaseName, java.lang.String userName, java.lang.String password)

Method Summary

Modifier and Type	Method and Description
protected void	addIndex(java.util.Map rval, java.lang.String indexName, boolean isUnique, java.util.List<java.lang.String> indexColumns)
void	addTableIndex(java.lang.String tableName, boolean unique, java.util.List<java.lang.String> columnList) Add an index to a table.
void	analyzeTable(java.lang.String tableName) Analyze a table.
protected static void	appendDescription(java.lang.StringBuilder queryBuffer, java.lang.String columnName, ColumnDescription cd, boolean forceNull)
void	beginTransaction() Begin a database transaction.
void	beginTransaction(int transactionType) Begin a database transaction.
java.lang.String	buildConjunctionClause(java.util.List outputParameters, ClauseDescription[] clauseDescriptions)
void	closeDatabase() Uninitialize.
protected void	commitCurrentTransaction() Abstract method to commit a transaction
java.lang.String	constructCountClause(java.lang.String column) Construct a count clause.
java.lang.String	constructDistinctOnClause(java.util.List outputParameters, java.lang.String baseQuery, java.util.List baseParameters, java.lang.String[] distinctFields, java.lang.String[] orderFields, boolean[] orderFieldsAscending, java.util.Map<java.lang.String,java.lang.String> otherFields) Construct a 'distinct on (x)' filter.
java.lang.String	constructDoubleCastClause(java.lang.String value) Construct a cast to a double value.
java.lang.String	constructIndexOrderByClause(java.lang.String[] fieldNames, boolean direction) Construct ORDER-BY clause meant for reading from an index.
java.lang.String	constructOffsetLimitClause(int offset, int limit, boolean afterOrderBy) Construct an offset/limit clause.
java.lang.String	constructRegexpClause(java.lang.String column, java.lang.String regularExpression, boolean caseInsensitive) Construct a regular-expression match clause.
java.lang.String	constructSubstringClause(java.lang.String column, java.lang.String regularExpression, boolean caseInsensitive) Construct a regular-expression substring clause.
void	createUserAndDatabase(java.lang.String adminUserName, java.lang.String adminPassword, StringSet invalidateKeys) Create user and database.
void	dropUserAndDatabase(java.lang.String adminUserName, java.lang.String adminPassword, StringSet invalidateKeys) Drop user and database.
void	endTransaction() End a database transaction, either performing a commit or a rollback (depending on whether signalRollback() was called within the transaction).
protected void	explainQuery(java.lang.String query, java.util.List params) Abstract method for explaining a query
int	findConjunctionClauseMax(ClauseDescription[] otherClauseDescriptions)
StringSet	getAllTables(StringSet cacheKeys, java.lang.String queryClass) Get a database's tables.
java.lang.String	getDatabaseCacheKey() Get the database general cache key.
protected static java.lang.String	getDatabaseString(IThreadContext tc, java.lang.String databaseName)
protected static java.lang.String	getFullDatabasePath(java.lang.String databaseName)
protected static java.lang.String	getJDBCString(IThreadContext tc, java.lang.String databaseName)
int	getMaxInClause() Obtain the maximum number of individual items that should be present in an IN clause.
int	getMaxOrClause() Obtain the maximum number of individual clauses that should be present in a sequence of OR clauses.
java.util.Map<java.lang.String,IndexDescription>	getTableIndexes(java.lang.String tableName, StringSet cacheKeys, java.lang.String queryClass) Get a table's indexes.
java.util.Map<java.lang.String,ColumnDescription>	getTableSchema(java.lang.String tableName, StringSet cacheKeys, java.lang.String queryClass) Get a table's schema.
int	getWindowedReportMaxRows() For windowed report queries, e.g.
protected void	initializeConnection(java.sql.Connection connection) Initialize the connection (for HSQLDB).
protected java.lang.String	mapLabelName(java.lang.String rawLabelName) Abstract method for mapping a column name from resultset
protected static java.lang.String	mapType(java.lang.String inputType) Map a standard type into a postgresql type.
void	openDatabase() Initialize.
void	performAddIndex(java.lang.String indexName, java.lang.String tableName, IndexDescription description) Add an index to a table.
void	performAlter(java.lang.String tableName, java.util.Map<java.lang.String,ColumnDescription> columnMap, java.util.Map<java.lang.String,ColumnDescription> columnModifyMap, java.util.List<java.lang.String> columnDeleteList, StringSet invalidateKeys) Perform a table alter operation.
void	performCreate(java.lang.String tableName, java.util.Map<java.lang.String,ColumnDescription> columnMap, StringSet invalidateKeys) Perform a table creation operation.
void	performDelete(java.lang.String tableName, java.lang.String whereClause, java.util.List whereParameters, StringSet invalidateKeys) Perform a delete operation.
void	performDrop(java.lang.String tableName, StringSet invalidateKeys) Perform a table drop operation.
void	performInsert(java.lang.String tableName, java.util.Map<java.lang.String,java.lang.Object> parameterMap, StringSet invalidateKeys) Perform an insert operation.
void	performModification(java.lang.String query, java.util.List params, StringSet invalidateKeys) Perform a general database modification query.
IResultSet	performQuery(java.lang.String query, java.util.List params, StringSet cacheKeys, java.lang.String queryClass) Perform a general "data fetch" query.
IResultSet	performQuery(java.lang.String query, java.util.List params, StringSet cacheKeys, java.lang.String queryClass, int maxResults, ILimitChecker returnLimit) Perform a general "data fetch" query.
IResultSet	performQuery(java.lang.String query, java.util.List params, StringSet cacheKeys, java.lang.String queryClass, int maxResults, ResultSpecification resultSpec, ILimitChecker returnLimit) Perform a general "data fetch" query.
void	performRemoveIndex(java.lang.String indexName, java.lang.String tableName) Remove an index.
void	performUpdate(java.lang.String tableName, java.util.Map<java.lang.String,java.lang.Object> parameterMap, java.lang.String whereClause, java.util.List whereParameters, StringSet invalidateKeys) Perform an update operation.
protected static void	recursiveDelete(java.io.File f)
void	reindexTable(java.lang.String tableName) Reindex a table.
protected ManifoldCFException	reinterpretException(ManifoldCFException theException) Reinterpret an exception tossed by the database layer.
protected void	rollbackCurrentTransaction() Abstract method to roll back a transaction
void	signalRollback() Signal that a rollback should occur on the next endTransaction().
protected static void	singleDelete(java.io.File f)
protected void	startATransaction() Abstract method to start a transaction

Methods inherited from class org.apache.manifoldcf.core.database.Database

cleanupParameters, constructIndexHintClause, constructOffsetLimitClause, execute, executeQuery, executeUncachedQuery, executeViaThread, findColumn, getBLOB, getCurrentTransactionType, getData, getDatabaseName, getObject, getSleepAmt, getTransactionID, internalTransactionBegin, interruptCleanup, isBinary, isBLOB, loadPS, mapLookupName, noteModifications, noteModificationsNoTransactions, performCommit, prepareForDatabaseCreate, sleepFor, synchronizeTransactions

Methods inherited from class java.lang.Object

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

Methods inherited from interface org.apache.manifoldcf.core.interfaces.IDBInterface

constructIndexHintClause, constructOffsetLimitClause, getDatabaseName, getSleepAmt, getTransactionID, noteModifications, performCommit, sleepFor

Field Detail

_rcsid

public static final java.lang.String _rcsid

See Also:

Constant Field Values

databasePathProperty

public static final java.lang.String databasePathProperty

See Also:

Constant Field Values

databaseProtocolProperty

public static final java.lang.String databaseProtocolProperty

See Also:

Constant Field Values

databaseServerProperty

public static final java.lang.String databaseServerProperty

See Also:

Constant Field Values

databasePortProperty

public static final java.lang.String databasePortProperty

See Also:

Constant Field Values

databaseInstanceProperty

public static final java.lang.String databaseInstanceProperty

See Also:

Constant Field Values

cacheKey

protected java.lang.String cacheKey

serializableDepth

protected int serializableDepth

isRemote

protected boolean isRemote

schemaNameForQueries

protected java.lang.String schemaNameForQueries

depthCount

protected int depthCount

inTransaction

protected boolean inTransaction

desiredTransactionType

protected int desiredTransactionType

Constructor Detail

DBInterfaceHSQLDB

public DBInterfaceHSQLDB(IThreadContext tc,
                         java.lang.String databaseName,
                         java.lang.String userName,
                         java.lang.String password)
                  throws ManifoldCFException

Throws:

ManifoldCFException

Method Detail

getJDBCString

protected static java.lang.String getJDBCString(IThreadContext tc,
                                                java.lang.String databaseName)
                                         throws ManifoldCFException

Throws:

ManifoldCFException

getDatabaseString

protected static java.lang.String getDatabaseString(IThreadContext tc,
                                                    java.lang.String databaseName)
                                             throws ManifoldCFException

Throws:

ManifoldCFException

getFullDatabasePath

protected static java.lang.String getFullDatabasePath(java.lang.String databaseName)
                                               throws ManifoldCFException

Throws:

ManifoldCFException

initializeConnection

protected void initializeConnection(java.sql.Connection connection)
                             throws ManifoldCFException

Initialize the connection (for HSQLDB). HSQLDB has a great deal of session state, and no way to pool individual connections based on it. So, every time we pull a connection off the pool we have to execute a number of statements on it before it can work reliably for us. This is the abstraction that permits that to happen.

Overrides:

initializeConnection in class Database

Parameters:

connection - is the JDBC connection.

Throws:

ManifoldCFException

openDatabase

public void openDatabase()
                  throws ManifoldCFException

Initialize. This method is called once per JVM instance, in order to set up database communication.

Specified by:

openDatabase in interface IDBInterface

Throws:

ManifoldCFException

closeDatabase

public void closeDatabase()
                   throws ManifoldCFException

Uninitialize. This method is called during JVM shutdown, in order to close all database communication.

Specified by:

closeDatabase in interface IDBInterface

Throws:

ManifoldCFException

getDatabaseCacheKey

public java.lang.String getDatabaseCacheKey()

Get the database general cache key.

Specified by:

getDatabaseCacheKey in interface IDBInterface

Returns:

the general cache key for the database.

performInsert

public void performInsert(java.lang.String tableName,
                          java.util.Map<java.lang.String,java.lang.Object> parameterMap,
                          StringSet invalidateKeys)
                   throws ManifoldCFException

Perform an insert operation.

Specified by:

performInsert in interface IDBInterface

Parameters:

tableName - is the name of the table.

invalidateKeys - are the cache keys that should be invalidated.

parameterMap - is the map of column name/values to write.

Throws:

ManifoldCFException

performUpdate

public void performUpdate(java.lang.String tableName,
                          java.util.Map<java.lang.String,java.lang.Object> parameterMap,
                          java.lang.String whereClause,
                          java.util.List whereParameters,
                          StringSet invalidateKeys)
                   throws ManifoldCFException

Perform an update operation.

Specified by:

performUpdate in interface IDBInterface

Parameters:

tableName - is the name of the table.

invalidateKeys - are the cache keys that should be invalidated.

parameterMap - is the map of column name/values to write.

whereClause - is the where clause describing the match (including the WHERE), or null if none.

whereParameters - are the parameters that come with the where clause, if any.

Throws:

ManifoldCFException

performDelete

public void performDelete(java.lang.String tableName,
                          java.lang.String whereClause,
                          java.util.List whereParameters,
                          StringSet invalidateKeys)
                   throws ManifoldCFException

Perform a delete operation.

Specified by:

performDelete in interface IDBInterface

Parameters:

tableName - is the name of the table to delete from.

invalidateKeys - are the cache keys that should be invalidated.

whereClause - is the where clause describing the match (including the WHERE), or null if none.

whereParameters - are the parameters that come with the where clause, if any.

Throws:

ManifoldCFException

performCreate

public void performCreate(java.lang.String tableName,
                          java.util.Map<java.lang.String,ColumnDescription> columnMap,
                          StringSet invalidateKeys)
                   throws ManifoldCFException

Perform a table creation operation.

Specified by:

performCreate in interface IDBInterface

Parameters:

tableName - is the name of the table to create.

columnMap - is the map describing the columns and types. NOTE that these are abstract types, which will be mapped to the proper types for the actual database inside this layer.

invalidateKeys - are the cache keys that should be invalidated, if any.

Throws:

ManifoldCFException

appendDescription

protected static void appendDescription(java.lang.StringBuilder queryBuffer,
                                        java.lang.String columnName,
                                        ColumnDescription cd,
                                        boolean forceNull)

performAlter

public void performAlter(java.lang.String tableName,
                         java.util.Map<java.lang.String,ColumnDescription> columnMap,
                         java.util.Map<java.lang.String,ColumnDescription> columnModifyMap,
                         java.util.List<java.lang.String> columnDeleteList,
                         StringSet invalidateKeys)
                  throws ManifoldCFException

Perform a table alter operation.

Specified by:

performAlter in interface IDBInterface

Parameters:

tableName - is the name of the table to alter.

columnMap - is the map describing the columns and types to add. These are in the same form as for performCreate.

columnModifyMap - is the map describing the columns to be changed. The key is the existing column name, and the value is the new type of the column. Data will be copied from the old column to the new.

columnDeleteList - is the list of column names to delete.

invalidateKeys - are the cache keys that should be invalidated, if any.

Throws:

ManifoldCFException

mapType

protected static java.lang.String mapType(java.lang.String inputType)

Map a standard type into a postgresql type.

Parameters:

inputType - is the input type.

Returns:

the output type.

addTableIndex

public void addTableIndex(java.lang.String tableName,
                          boolean unique,
                          java.util.List<java.lang.String> columnList)
                   throws ManifoldCFException

Add an index to a table.

Specified by:

addTableIndex in interface IDBInterface

Parameters:

tableName - is the name of the table to add the index for.

unique - is a boolean that if true describes a unique index.

columnList - is the list of columns that need to be included in the index, in order.

Throws:

ManifoldCFException

performAddIndex

public void performAddIndex(java.lang.String indexName,
                            java.lang.String tableName,
                            IndexDescription description)
                     throws ManifoldCFException

Add an index to a table.

Specified by:

performAddIndex in interface IDBInterface

Parameters:

tableName - is the name of the table to add the index for.

indexName - is the optional name of the table index. If null, a name will be chosen automatically.

description - is the index description.

Throws:

ManifoldCFException

performRemoveIndex

public void performRemoveIndex(java.lang.String indexName,
                               java.lang.String tableName)
                        throws ManifoldCFException

Remove an index.

Specified by:

performRemoveIndex in interface IDBInterface

Parameters:

indexName - is the name of the index to remove.

tableName - is the table the index belongs to.

Throws:

ManifoldCFException

analyzeTable

public void analyzeTable(java.lang.String tableName)
                  throws ManifoldCFException

Analyze a table.

Specified by:

analyzeTable in interface IDBInterface

Parameters:

tableName - is the name of the table to analyze/calculate statistics for.

Throws:

ManifoldCFException

reindexTable

public void reindexTable(java.lang.String tableName)
                  throws ManifoldCFException

Reindex a table.

Specified by:

reindexTable in interface IDBInterface

Parameters:

tableName - is the name of the table to rebuild indexes for.

Throws:

ManifoldCFException

performDrop

public void performDrop(java.lang.String tableName,
                        StringSet invalidateKeys)
                 throws ManifoldCFException

Perform a table drop operation.

Specified by:

performDrop in interface IDBInterface

Parameters:

tableName - is the name of the table to drop.

invalidateKeys - are the cache keys that should be invalidated, if any.

Throws:

ManifoldCFException

createUserAndDatabase

public void createUserAndDatabase(java.lang.String adminUserName,
                                  java.lang.String adminPassword,
                                  StringSet invalidateKeys)
                           throws ManifoldCFException

Create user and database.

Specified by:

createUserAndDatabase in interface IDBInterface

Parameters:

adminUserName - is the admin user name.

adminPassword - is the admin password.

invalidateKeys - are the cache keys that should be invalidated, if any.

Throws:

ManifoldCFException

dropUserAndDatabase

public void dropUserAndDatabase(java.lang.String adminUserName,
                                java.lang.String adminPassword,
                                StringSet invalidateKeys)
                         throws ManifoldCFException

Drop user and database.

Specified by:

dropUserAndDatabase in interface IDBInterface

Parameters:

adminUserName - is the admin user name.

adminPassword - is the admin password.

invalidateKeys - are the cache keys that should be invalidated, if any.

Throws:

ManifoldCFException

recursiveDelete

protected static void recursiveDelete(java.io.File f)

singleDelete

protected static void singleDelete(java.io.File f)

reinterpretException

protected ManifoldCFException reinterpretException(ManifoldCFException theException)

Reinterpret an exception tossed by the database layer. We need to disambiguate the various kinds of exception that should be thrown.

Parameters:

theException - is the exception to reinterpret

Returns:

the reinterpreted exception to throw.

performModification

public void performModification(java.lang.String query,
                                java.util.List params,
                                StringSet invalidateKeys)
                         throws ManifoldCFException

Perform a general database modification query.

Specified by:

performModification in interface IDBInterface

Parameters:

query - is the query string.

params - are the parameterized values, if needed.

invalidateKeys - are the cache keys to invalidate.

Throws:

ManifoldCFException

getTableSchema

public java.util.Map<java.lang.String,ColumnDescription> getTableSchema(java.lang.String tableName,
                                                                        StringSet cacheKeys,
                                                                        java.lang.String queryClass)
                                                                 throws ManifoldCFException

Get a table's schema.

Specified by:

getTableSchema in interface IDBInterface

Parameters:

tableName - is the name of the table.

cacheKeys - are the keys against which to cache the query, or null.

queryClass - is the name of the query class, or null.

Returns:

a map of column names and ColumnDescription objects, describing the schema, or null if the table doesn't exist.

Throws:

ManifoldCFException

getTableIndexes

public java.util.Map<java.lang.String,IndexDescription> getTableIndexes(java.lang.String tableName,
                                                                        StringSet cacheKeys,
                                                                        java.lang.String queryClass)
                                                                 throws ManifoldCFException

Get a table's indexes.

Specified by:

getTableIndexes in interface IDBInterface

Parameters:

tableName - is the name of the table.

cacheKeys - are the keys against which to cache the query, or null.

queryClass - is the name of the query class, or null.

Returns:

a map of index names and IndexDescription objects, describing the indexes.

Throws:

ManifoldCFException

addIndex

protected void addIndex(java.util.Map rval,
                        java.lang.String indexName,
                        boolean isUnique,
                        java.util.List<java.lang.String> indexColumns)

getAllTables

public StringSet getAllTables(StringSet cacheKeys,
                              java.lang.String queryClass)
                       throws ManifoldCFException

Get a database's tables.

Specified by:

getAllTables in interface IDBInterface

Parameters:

cacheKeys - are the cache keys for the query, or null.

queryClass - is the name of the query class, or null.

Returns:

the set of tables.

Throws:

ManifoldCFException

performQuery

public IResultSet performQuery(java.lang.String query,
                               java.util.List params,
                               StringSet cacheKeys,
                               java.lang.String queryClass)
                        throws ManifoldCFException

Perform a general "data fetch" query.

Specified by:

performQuery in interface IDBInterface

Parameters:

query - is the query string.

params - are the parameterized values, if needed.

cacheKeys - are the cache keys, if needed (null if no cache desired).

queryClass - is the LRU class name against which this query would be cached, or null if no LRU behavior desired.

Returns:

a resultset.

Throws:

ManifoldCFException

performQuery

public IResultSet performQuery(java.lang.String query,
                               java.util.List params,
                               StringSet cacheKeys,
                               java.lang.String queryClass,
                               int maxResults,
                               ILimitChecker returnLimit)
                        throws ManifoldCFException

Perform a general "data fetch" query.

Specified by:

performQuery in interface IDBInterface

Parameters:

query - is the query string.

params - are the parameterized values, if needed.

cacheKeys - are the cache keys, if needed (null if no cache desired).

queryClass - is the LRU class name against which this query would be cached, or null if no LRU behavior desired.

maxResults - is the maximum number of results returned (-1 for all).

returnLimit - is a description of how to limit the return result, or null if no limit.

Returns:

a resultset.

Throws:

ManifoldCFException

performQuery

public IResultSet performQuery(java.lang.String query,
                               java.util.List params,
                               StringSet cacheKeys,
                               java.lang.String queryClass,
                               int maxResults,
                               ResultSpecification resultSpec,
                               ILimitChecker returnLimit)
                        throws ManifoldCFException

Perform a general "data fetch" query.

Specified by:

performQuery in interface IDBInterface

Parameters:

query - is the query string.

params - are the parameterized values, if needed.

cacheKeys - are the cache keys, if needed (null if no cache desired).

queryClass - is the LRU class name against which this query would be cached, or null if no LRU behavior desired.

maxResults - is the maximum number of results returned (-1 for all).

resultSpec - is a result specification, or null for the standard treatment.

returnLimit - is a description of how to limit the return result, or null if no limit.

Returns:

a resultset.

Throws:

ManifoldCFException

constructIndexOrderByClause

public java.lang.String constructIndexOrderByClause(java.lang.String[] fieldNames,
                                                    boolean direction)

Construct ORDER-BY clause meant for reading from an index. Supply the field names belonging to the index, in order. Also supply a corresponding boolean array, where TRUE means "ASC", and FALSE means "DESC".

Specified by:

constructIndexOrderByClause in interface IDBInterface

Overrides:

constructIndexOrderByClause in class Database

Parameters:

fieldNames - are the names of the fields in the index that is to be used.

direction - is a boolean describing the sorting order of the first term.

Returns:

a query chunk, including "ORDER BY" text, which is appropriate for at least ordering by the FIRST column supplied.

constructDoubleCastClause

public java.lang.String constructDoubleCastClause(java.lang.String value)

Construct a cast to a double value. On most databases this cast needs to be explicit, but on some it is implicit (and cannot be in fact specified).

Specified by:

constructDoubleCastClause in interface IDBInterface

Parameters:

value - is the value to be cast.

Returns:

the query chunk needed.

constructCountClause

public java.lang.String constructCountClause(java.lang.String column)

Construct a count clause. On most databases this will be COUNT(col), but on some the count needs to be cast to a BIGINT, so CAST(COUNT(col) AS BIGINT) will be emitted instead.

Specified by:

constructCountClause in interface IDBInterface

Parameters:

column - is the column string to be counted.

Returns:

the query chunk needed.

constructRegexpClause

public java.lang.String constructRegexpClause(java.lang.String column,
                                              java.lang.String regularExpression,
                                              boolean caseInsensitive)

Construct a regular-expression match clause. This method builds both the text part of a regular-expression match.

Specified by:

constructRegexpClause in interface IDBInterface

Parameters:

column - is the column specifier string.

regularExpression - is the properly-quoted regular expression string, or "?" if a parameterized value is to be used.

caseInsensitive - is true of the regular expression match is to be case insensitive.

Returns:

the query chunk needed, not padded with spaces on either side.

constructSubstringClause

public java.lang.String constructSubstringClause(java.lang.String column,
                                                 java.lang.String regularExpression,
                                                 boolean caseInsensitive)

Construct a regular-expression substring clause. This method builds an expression that extracts a specified string section from a field, based on a regular expression.

Specified by:

constructSubstringClause in interface IDBInterface

Parameters:

column - is the column specifier string.

regularExpression - is the properly-quoted regular expression string, or "?" if a parameterized value is to be used.

caseInsensitive - is true if the regular expression match is to be case insensitive.

Returns:

the expression chunk needed, not padded with spaces on either side.

constructOffsetLimitClause

public java.lang.String constructOffsetLimitClause(int offset,
                                                   int limit,
                                                   boolean afterOrderBy)

Construct an offset/limit clause. This method constructs an offset/limit clause in the proper manner for the database in question.

Specified by:

constructOffsetLimitClause in interface IDBInterface

Specified by:

constructOffsetLimitClause in class Database

Parameters:

offset - is the starting offset number.

limit - is the limit of result rows to return.

afterOrderBy - is true if this offset/limit comes after an ORDER BY.

Returns:

the proper clause, with no padding spaces on either side.

constructDistinctOnClause

public java.lang.String constructDistinctOnClause(java.util.List outputParameters,
                                                  java.lang.String baseQuery,
                                                  java.util.List baseParameters,
                                                  java.lang.String[] distinctFields,
                                                  java.lang.String[] orderFields,
                                                  boolean[] orderFieldsAscending,
                                                  java.util.Map<java.lang.String,java.lang.String> otherFields)

Construct a 'distinct on (x)' filter. This filter wraps a query and returns a new query whose results are similar to POSTGRESQL's DISTINCT-ON feature. Specifically, for each combination of the specified distinct fields in the result, only the first such row is included in the final result.

Specified by:

constructDistinctOnClause in interface IDBInterface

Parameters:

outputParameters - is a blank list into which to put parameters. Null may be used if the baseParameters parameter is null.

baseQuery - is the base query, which is another SELECT statement, without parens, e.g. "SELECT ..."

baseParameters - are the parameters corresponding to the baseQuery.

distinctFields - are the fields to consider to be distinct. These should all be keys in otherFields below.

orderFields - are the otherfield keys that determine the ordering.

orderFieldsAscending - are true for orderFields that are ordered as ASC, false for DESC.

otherFields - are the rest of the fields to return, keyed by the AS name, value being the base query column value, e.g. "value AS key"

Returns:

a revised query that performs the necessary DISTINCT ON operation. The list outputParameters will also be appropriately filled in.

findConjunctionClauseMax

public int findConjunctionClauseMax(ClauseDescription[] otherClauseDescriptions)

Specified by:

findConjunctionClauseMax in interface IDBInterface

Overrides:

findConjunctionClauseMax in class Database

buildConjunctionClause

public java.lang.String buildConjunctionClause(java.util.List outputParameters,
                                               ClauseDescription[] clauseDescriptions)

Specified by:

buildConjunctionClause in interface IDBInterface

Overrides:

buildConjunctionClause in class Database

getMaxInClause

public int getMaxInClause()

Obtain the maximum number of individual items that should be present in an IN clause. Exceeding this amount will potentially cause the query performance to drop.

Specified by:

getMaxInClause in interface IDBInterface

Specified by:

getMaxInClause in class Database

Returns:

the maximum number of IN clause members.

getMaxOrClause

public int getMaxOrClause()

Obtain the maximum number of individual clauses that should be present in a sequence of OR clauses. Exceeding this amount will potentially cause the query performance to drop.

Specified by:

getMaxOrClause in interface IDBInterface

Returns:

the maximum number of OR clause members.

getWindowedReportMaxRows

public int getWindowedReportMaxRows()

For windowed report queries, e.g. maxActivity or maxBandwidth, obtain the maximum number of rows that can reasonably be expected to complete in an acceptable time.

Specified by:

getWindowedReportMaxRows in interface IDBInterface

Returns:

the maximum number of rows.

beginTransaction

public void beginTransaction()
                      throws ManifoldCFException

Begin a database transaction. This method call MUST be paired with an endTransaction() call, or database handles will be lost. If the transaction should be rolled back, then signalRollback() should be called before the transaction is ended. It is strongly recommended that the code that uses transactions be structured so that a try block starts immediately after this method call. The body of the try block will contain all direct or indirect calls to executeQuery(). After this should be a catch for every exception type, including Error, which should call the signalRollback() method, and rethrow the exception. Then, after that a finally{} block which calls endTransaction().

Specified by:

beginTransaction in interface IDBInterface

Throws:

ManifoldCFException

beginTransaction

public void beginTransaction(int transactionType)
                      throws ManifoldCFException

Begin a database transaction. This method call MUST be paired with an endTransaction() call, or database handles will be lost. If the transaction should be rolled back, then signalRollback() should be called before the transaction is ended. It is strongly recommended that the code that uses transactions be structured so that a try block starts immediately after this method call. The body of the try block will contain all direct or indirect calls to executeQuery(). After this should be a catch for every exception type, including Error, which should call the signalRollback() method, and rethrow the exception. Then, after that a finally{} block which calls endTransaction().

Specified by:

beginTransaction in interface IDBInterface

Overrides:

beginTransaction in class Database

Parameters:

transactionType - is the kind of transaction desired.

Throws:

ManifoldCFException

signalRollback

public void signalRollback()

Signal that a rollback should occur on the next endTransaction().

Specified by:

signalRollback in interface IDBInterface

Overrides:

signalRollback in class Database

endTransaction

public void endTransaction()
                    throws ManifoldCFException

End a database transaction, either performing a commit or a rollback (depending on whether signalRollback() was called within the transaction).

Specified by:

endTransaction in interface IDBInterface

Overrides:

endTransaction in class Database

Throws:

ManifoldCFException

startATransaction

protected void startATransaction()
                          throws ManifoldCFException

Abstract method to start a transaction

Overrides:

startATransaction in class Database

Throws:

ManifoldCFException

commitCurrentTransaction

protected void commitCurrentTransaction()
                                 throws ManifoldCFException

Abstract method to commit a transaction

Overrides:

commitCurrentTransaction in class Database

Throws:

ManifoldCFException

rollbackCurrentTransaction

protected void rollbackCurrentTransaction()
                                   throws ManifoldCFException

Abstract method to roll back a transaction

Overrides:

rollbackCurrentTransaction in class Database

Throws:

ManifoldCFException

explainQuery

protected void explainQuery(java.lang.String query,
                            java.util.List params)
                     throws ManifoldCFException

Abstract method for explaining a query

Overrides:

explainQuery in class Database

Throws:

ManifoldCFException

mapLabelName

protected java.lang.String mapLabelName(java.lang.String rawLabelName)

Abstract method for mapping a column name from resultset

Overrides:

mapLabelName in class Database