org.apache.cayenne.dba.hsqldb

Class HSQLDBAdapter

java.lang.Object

org.apache.cayenne.dba.JdbcAdapter

org.apache.cayenne.dba.hsqldb.HSQLDBAdapter

All Implemented Interfaces:

DbAdapter

Direct Known Subclasses:

HSQLDBNoSchemaAdapter

public class HSQLDBAdapter
extends JdbcAdapter

DbAdapter implementation for the HSQLDB RDBMS . Sample connection settings to use with HSQLDB are shown below:

        test-hsqldb.jdbc.username = test
        test-hsqldb.jdbc.password = secret
        test-hsqldb.jdbc.url = jdbc:hsqldb:hsql://serverhostname
        test-hsqldb.jdbc.driver = org.hsqldb.jdbcDriver
 

Field Summary

Fields

Modifier and Type	Field and Description
static String	TRIM_FUNCTION

Fields inherited from class org.apache.cayenne.dba.JdbcAdapter

batchQueryBuilderFactory, caseInsensitiveCollations, ejbqlTranslatorFactory, extendedTypes, logger, quotingStrategy, resourceLocator, supportsBatchUpdates, supportsGeneratedKeys, supportsUniqueConstraints, typesHandler

Constructor Summary

Constructors

Constructor and Description
HSQLDBAdapter(RuntimeProperties runtimeProperties, List<ExtendedType> defaultExtendedTypes, List<ExtendedType> userExtendedTypes, List<ExtendedTypeFactory> extendedTypeFactories, ResourceLocator resourceLocator, ValueObjectTypeRegistry valueObjectTypeRegistry)

Method Summary

Modifier and Type	Method and Description
protected void	configureExtendedTypes(ExtendedTypeMap map) Called from JdbcAdapter.initExtendedTypes(List, List, List, ValueObjectTypeRegistry) to load adapter-specific types into the ExtendedTypeMap right after the default types are loaded, but before the DI overrides are.
protected EJBQLTranslatorFactory	createEJBQLTranslatorFactory() Creates and returns an EJBQLTranslatorFactory used to generate visitors for EJBQL to SQL translations.
String	createFkConstraint(DbRelationship rel) Adds an ADD CONSTRAINT clause to a relationship constraint.
String	createTable(DbEntity ent) Uses "CREATE CACHED TABLE" instead of "CREATE TABLE".
void	createTableAppendColumn(StringBuffer sqlBuffer, DbAttribute column) Appends SQL for column creation to CREATE TABLE buffer.
String	createUniqueConstraint(DbEntity source, Collection<DbAttribute> columns) Returns a DDL string to create a unique constraint over a set of columns.
SQLAction	getAction(Query query, DataNode node) Uses special action builder to create the right action.
QualifierTranslator	getQualifierTranslator(QueryAssembler queryAssembler) Returns a trimming translator.
protected String	getSchemaName(DbEntity entity) Returns DbEntity schema name for 1.8 and on.
SelectTranslator	getSelectTranslator(SelectQuery<?> query, EntityResolver entityResolver) Returns a SelectTranslator that works with the adapter target database.
protected String	getTableName(DbEntity entity) Generate fully-qualified name for 1.8 and on.

Methods inherited from class org.apache.cayenne.dba.JdbcAdapter

bindParameter, buildAttribute, createPkGenerator, createQuotingStrategy, createTableAppendPKClause, dropTableStatements, externalTypesForJdbcType, findResource, getBatchQueryBuilderFactory, getBatchTerminator, getEjbqlTranslatorFactory, getExtendedTypes, getJdbcEventLogger, getPkGenerator, getQuotingStrategy, getQuotingStrategy, getType, initExtendedTypes, setBatchQueryBuilderFactory, setEjbqlTranslatorFactory, setPkGenerator, setSupportsBatchUpdates, setSupportsGeneratedKeys, setSupportsUniqueConstraints, sizeAndPrecision, supportsBatchUpdates, supportsCatalogsOnReverseEngineering, supportsGeneratedKeys, supportsUniqueConstraints, tableTypeForTable, tableTypeForView, typeSupportsLength, unwrap

Methods inherited from class java.lang.Object

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

Field Detail

TRIM_FUNCTION

public static final String TRIM_FUNCTION

See Also:

Constant Field Values

Constructor Detail

HSQLDBAdapter

public HSQLDBAdapter(RuntimeProperties runtimeProperties,
                     List<ExtendedType> defaultExtendedTypes,
                     List<ExtendedType> userExtendedTypes,
                     List<ExtendedTypeFactory> extendedTypeFactories,
                     ResourceLocator resourceLocator,
                     ValueObjectTypeRegistry valueObjectTypeRegistry)

Method Detail

configureExtendedTypes

protected void configureExtendedTypes(ExtendedTypeMap map)

Description copied from class: JdbcAdapter

Called from JdbcAdapter.initExtendedTypes(List, List, List, ValueObjectTypeRegistry) to load adapter-specific types into the ExtendedTypeMap right after the default types are loaded, but before the DI overrides are. This method has specific implementations in JdbcAdapter subclasses.

Overrides:

configureExtendedTypes in class JdbcAdapter

Since:

4.0

getSelectTranslator

public SelectTranslator getSelectTranslator(SelectQuery<?> query,
                                            EntityResolver entityResolver)

Description copied from interface: DbAdapter

Returns a SelectTranslator that works with the adapter target database.

Specified by:

getSelectTranslator in interface DbAdapter

Overrides:

getSelectTranslator in class JdbcAdapter

Since:

4.0

getQualifierTranslator

public QualifierTranslator getQualifierTranslator(QueryAssembler queryAssembler)

Returns a trimming translator.

Specified by:

getQualifierTranslator in interface DbAdapter

Overrides:

getQualifierTranslator in class JdbcAdapter

Since:

4.0

createEJBQLTranslatorFactory

protected EJBQLTranslatorFactory createEJBQLTranslatorFactory()

Description copied from class: JdbcAdapter

Creates and returns an EJBQLTranslatorFactory used to generate visitors for EJBQL to SQL translations. This method should be overriden by subclasses that need to customize EJBQL generation.

Overrides:

createEJBQLTranslatorFactory in class JdbcAdapter

Since:

4.0

getTableName

protected String getTableName(DbEntity entity)

Generate fully-qualified name for 1.8 and on. Subclass generates unqualified name.

Since:

1.2

getSchemaName

protected String getSchemaName(DbEntity entity)

Returns DbEntity schema name for 1.8 and on. Subclass generates unqualified name.

Since:

1.2

getAction

public SQLAction getAction(Query query,
                           DataNode node)

Uses special action builder to create the right action.

Specified by:

getAction in interface DbAdapter

Overrides:

getAction in class JdbcAdapter

Since:

1.2

createUniqueConstraint

public String createUniqueConstraint(DbEntity source,
                                     Collection<DbAttribute> columns)

Returns a DDL string to create a unique constraint over a set of columns.

Specified by:

createUniqueConstraint in interface DbAdapter

Overrides:

createUniqueConstraint in class JdbcAdapter

Since:

1.1

createFkConstraint

public String createFkConstraint(DbRelationship rel)

Adds an ADD CONSTRAINT clause to a relationship constraint.

Specified by:

createFkConstraint in interface DbAdapter

Overrides:

createFkConstraint in class JdbcAdapter

See Also:

JdbcAdapter.createFkConstraint(DbRelationship)

createTable

public String createTable(DbEntity ent)

Uses "CREATE CACHED TABLE" instead of "CREATE TABLE".

Specified by:

createTable in interface DbAdapter

Overrides:

createTable in class JdbcAdapter

Since:

1.2

createTableAppendColumn

public void createTableAppendColumn(StringBuffer sqlBuffer,
                                    DbAttribute column)

Description copied from class: JdbcAdapter

Appends SQL for column creation to CREATE TABLE buffer.

Specified by:

createTableAppendColumn in interface DbAdapter

Overrides:

createTableAppendColumn in class JdbcAdapter

Parameters:

sqlBuffer - the StringBuffer to append the column type to

column - the DbAttribute defining the column to append type for