Package org.jumpmind.db.platform.derby

Class DerbyDatabasePlatform

java.lang.Object

org.jumpmind.db.platform.AbstractDatabasePlatform

org.jumpmind.db.platform.AbstractJdbcDatabasePlatform

org.jumpmind.db.platform.derby.DerbyDatabasePlatform

All Implemented Interfaces:

IDatabasePlatform

public class DerbyDatabasePlatform
extends AbstractJdbcDatabasePlatform

Field Summary

Fields

Modifier and Type	Field	Description
static final String	JDBC_DRIVER
static final String	JDBC_DRIVER_EMBEDDED
static final String	JDBC_SUBPROTOCOL

Fields inherited from class org.jumpmind.db.platform.AbstractJdbcDatabasePlatform

dataSource, sqlTemplate, sqlTemplateDirty

Fields inherited from class org.jumpmind.db.platform.AbstractDatabasePlatform

clearCacheModelTimeoutInMs, databaseVersion, ddlBuilder, ddlReader, defaultCatalog, defaultSchema, log, metadataIgnoreCase, MODEL_DEFAULT_NAME, PERMISSION_TEST_TABLE_NAME, REQUIRED_FIELD_NULL_SUBSTITUTE, settings, sourceNodeId, storesLowerCaseIdentifiers, storesMixedCaseIdentifiers, storesUpperCaseIdentifiers, supportsMultiThreadedTransactions, supportsTransactions, supportsTruncate, tableCache, useMultiThreadSyncTriggers, ZERO_DATE_STRING

Constructor Summary

Constructors

Constructor	Description
DerbyDatabasePlatform(DataSource dataSource, SqlTemplateSettings settings)

Method Summary

Modifier and Type	Method	Description
boolean	allowsUniqueIndexDuplicatesWithNulls()
boolean	canColumnBeUsedInWhereClause(Column column)
protected DerbyDdlBuilder	createDdlBuilder()
protected DerbyDdlReader	createDdlReader()
protected DerbyJdbcSqlTemplate	createSqlTemplate()
PermissionResult	getCreateSymTriggerPermission()
String	getDefaultCatalog()
String	getDefaultSchema()
String	getName()
boolean	isClob(Column column)
String	massageForLimitOffset(String sql, int limit, int offset)
boolean	supportsLimitOffset()

Methods inherited from class org.jumpmind.db.platform.AbstractJdbcDatabasePlatform

createSqlTemplateDirty, getDataSource, getSqlTemplate, getSqlTemplateDirty, resetDataSource

Methods inherited from class org.jumpmind.db.platform.AbstractDatabasePlatform

alterCaseToMatchDatabaseDefaultCase, alterCaseToMatchDatabaseDefaultCase, alterCaseToMatchDatabaseDefaultCase, alterCaseToMatchDatabaseDefaultCase, alterCaseToMatchDatabaseDefaultCase, alterDatabase, alterDatabase, alterTables, alterTables, appendString, checkSymTablePermissions, cleanNumber, cleanTextForTextBasedColumns, createArray, createDatabase, createDmlStatement, createDmlStatement, createDmlStatement, createDmlStatement, createTables, dropDatabase, dropTables, getAlterSymTablePermission, getCharSetName, getClearCacheModelTimeoutInMs, getCreateSymFunctionPermission, getCreateSymRoutinePermission, getCreateSymTablePermission, getCsvStringValue, getDatabaseInfo, getDatabaseVersion, getDateTimeStringValue, getDdlBuilder, getDdlReader, getDeleteSql, getDropSymTablePermission, getDropSymTriggerPermission, getEstimatedRowCount, getExecuteSymPermission, getLobColumns, getLogMinePermission, getObjectValue, getObjectValues, getObjectValues, getObjectValues, getObjectValues, getPermissionTableDefinition, getSliceTableSql, getSqlScriptReplacementTokens, getStringValues, getTableFromCache, getTableFromCache, getTimestampStringValue, getTimestampTzStringValue, getTimeZone, getTransactions, getTruncateSql, hasMatchingPlatform, isBlob, isLob, isMetadataIgnoreCase, isStoresLowerCaseIdentifiers, isStoresMixedCaseQuotedIdentifiers, isStoresUpperCaseIdentifiers, isUseMultiThreadSyncTriggers, logFailedResults, makeAllColumnsPrimaryKeys, makePlatformSpecific, massageForObjectAlreadyExists, massageForObjectDoesNotExist, parseBigDecimal, parseBigInteger, parseBoolean, parseDate, parseFloat, parseInteger, parseQualifiedTableName, parseTimestamp, prefixColumnNames, prefixDatabase, prefixForeignKeys, prefixIndexes, readDatabase, readDatabaseFromXml, readDatabaseFromXml, readFromDatabase, readTableFromDatabase, readTableFromDatabase, readTableFromDatabaseAllowException, resetCachedTableModel, scrubSql, setClearCacheModelTimeoutInMs, setDatabaseVersion, setMetadataIgnoreCase, supportsMultiThreadedTransactions, supportsParametersInSelect, supportsSliceTables, supportsTransactions

Methods inherited from class java.lang.Object

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

Field Details

JDBC_DRIVER

public static final String JDBC_DRIVER

See Also:

• Constant Field Values

JDBC_DRIVER_EMBEDDED

public static final String JDBC_DRIVER_EMBEDDED

See Also:

• Constant Field Values

JDBC_SUBPROTOCOL

public static final String JDBC_SUBPROTOCOL

See Also:

• Constant Field Values

Constructor Details

DerbyDatabasePlatform

public DerbyDatabasePlatform(DataSource dataSource,
 SqlTemplateSettings settings)

Method Details

createDdlBuilder

protected DerbyDdlBuilder createDdlBuilder()

Specified by:

createDdlBuilder in class AbstractJdbcDatabasePlatform

createDdlReader

protected DerbyDdlReader createDdlReader()

Specified by:

createDdlReader in class AbstractJdbcDatabasePlatform

createSqlTemplate

protected DerbyJdbcSqlTemplate createSqlTemplate()

Overrides:

createSqlTemplate in class AbstractJdbcDatabasePlatform

allowsUniqueIndexDuplicatesWithNulls

public boolean allowsUniqueIndexDuplicatesWithNulls()

Specified by:

allowsUniqueIndexDuplicatesWithNulls in interface IDatabasePlatform

Overrides:

allowsUniqueIndexDuplicatesWithNulls in class AbstractDatabasePlatform

getName

public String getName()

Returns:

a constant that represents this database type from DatabaseNamesConstants

See Also:

• DatabaseNamesConstants

getDefaultSchema

public String getDefaultSchema()

getDefaultCatalog

public String getDefaultCatalog()

isClob

public boolean isClob(Column column)

Specified by:

isClob in interface IDatabasePlatform

Overrides:

isClob in class AbstractDatabasePlatform

canColumnBeUsedInWhereClause

public boolean canColumnBeUsedInWhereClause(Column column)

Specified by:

canColumnBeUsedInWhereClause in interface IDatabasePlatform

Overrides:

canColumnBeUsedInWhereClause in class AbstractDatabasePlatform

getCreateSymTriggerPermission

public PermissionResult getCreateSymTriggerPermission()

Overrides:

getCreateSymTriggerPermission in class AbstractDatabasePlatform

supportsLimitOffset

public boolean supportsLimitOffset()

Specified by:

supportsLimitOffset in interface IDatabasePlatform

Overrides:

supportsLimitOffset in class AbstractDatabasePlatform

massageForLimitOffset

public String massageForLimitOffset(String sql,
 int limit,
 int offset)

Specified by:

massageForLimitOffset in interface IDatabasePlatform

Overrides:

massageForLimitOffset in class AbstractDatabasePlatform