er.extensions.jdbc
Class ERXSQLHelper.DerbySQLHelper

java.lang.Object
  er.extensions.jdbc.ERXSQLHelper
      er.extensions.jdbc.ERXSQLHelper.DerbySQLHelper

Enclosing class:

ERXSQLHelper

public static class ERXSQLHelper.DerbySQLHelper
extends ERXSQLHelper

Nested Class Summary

Nested classes/interfaces inherited from class er.extensions.jdbc.ERXSQLHelper

ERXSQLHelper.ColumnIndex, ERXSQLHelper.CustomTypes, ERXSQLHelper.DerbySQLHelper, ERXSQLHelper.EROracleSQLHelper, ERXSQLHelper.FrontBaseSQLHelper, ERXSQLHelper.H2SQLHelper, ERXSQLHelper.MicrosoftSQLHelper, ERXSQLHelper.MySQLSQLHelper, ERXSQLHelper.NoSQLHelper, ERXSQLHelper.OpenBaseSQLHelper, ERXSQLHelper.OracleSQLHelper, ERXSQLHelper.PostgresqlSQLHelper

Field Summary

Fields inherited from class er.extensions.jdbc.ERXSQLHelper

log

Constructor Summary

ERXSQLHelper.DerbySQLHelper()

Method Summary

java.lang.String	externalTypeForJDBCType(com.webobjects.jdbcadaptor.JDBCAdaptor adaptor, int jdbcType) JDBCAdaptor.externalTypeForJDBCType just returns the first type it finds instead of trying to find a best match.
java.lang.String	migrationTableName() Returns the name of the table to use for database migrations.
boolean	shouldExecute(java.lang.String sql)
java.lang.String	sqlForCreateUniqueIndex(java.lang.String indexName, java.lang.String tableName, ERXSQLHelper.ColumnIndex... columnIndexes) Returns the SQL expression for creating a unique index on the given set of columns
int	varcharLargeColumnWidth() Returns the width that should be used for a varcharLarge column in migrations.
int	varcharLargeJDBCType() Returns the JDBCType that should be used for a varcharLarge column in migrations.

Methods inherited from class er.extensions.jdbc.ERXSQLHelper

_groupByOrHavingIndex, _orderByIndex, addGroupByClauseToExpression, addGroupByClauseToExpression, addHavingCountClauseToExpression, appendItemToListString, attributesToFetchForEntity, canReliablyPerformDistinctWithSortOrderings, columnIndexesFromColumnNames, columnNamesFromColumnIndexes, commandSeparatorChar, commandSeparatorString, commentPattern, createDependentSchemaSQLForEntities, createIndexSQLForEntities, createIndexSQLForEntities, createSchemaSQLForEntitiesInDatabaseContext, createSchemaSQLForEntitiesInModel, createSchemaSQLForEntitiesInModelAndOptions, createSchemaSQLForEntitiesInModelWithName, createSchemaSQLForEntitiesInModelWithNameAndOptions, createSchemaSQLForEntitiesWithOptions, createSchemaSQLForEntitiesWithOptions, customQueryExpressionHintAsString, defaultOptionDictionary, formatValueForAttribute, getNextValFromSequenceNamed, handleDatabaseException, jdbcTypeForCustomType, limitExpressionForSQL, maximumElementPerInClause, newSQLHelper, newSQLHelper, newSQLHelper, newSQLHelper, newSQLHelper, newSQLHelper, newSQLHelper, newSQLHelper, newSQLHelper, newSQLHelper, newSQLHelper, newSQLHelper, newSQLHelper, prepareConnectionForSchemaChange, quoteColumnName, readFormatForAggregateFunction, reassignExternalTypeForValueTypeOverride, removeSelectFromExpression, restoreConnectionSettingsAfterSchemaChange, rowCountForFetchSpecification, shouldPerformDistinctInMemory, splitSQLStatements, splitSQLStatementsFromFile, splitSQLStatementsFromInputStream, sqlExpressionForFetchSpecification, sqlExpressionForFetchSpecification, sqlForCreateIndex, sqlForCreateIndex, sqlForCreateUniqueIndex, sqlForFullTextQuery, sqlForGetNextValFromSequencedNamed, sqlForRegularExpressionQuery, sqlForSubquery, sqlWhereClauseStringForKey

Methods inherited from class java.lang.Object

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

Constructor Detail

ERXSQLHelper.DerbySQLHelper

public ERXSQLHelper.DerbySQLHelper()

Method Detail

shouldExecute

public boolean shouldExecute(java.lang.String sql)

Overrides:

shouldExecute in class ERXSQLHelper

varcharLargeJDBCType

public int varcharLargeJDBCType()

Description copied from class: ERXSQLHelper

Returns the JDBCType that should be used for a varcharLarge column in migrations.

Overrides:

varcharLargeJDBCType in class ERXSQLHelper

Returns:

the JDBCType that should be used for a varcharLarge column in migrations

varcharLargeColumnWidth

public int varcharLargeColumnWidth()

Description copied from class: ERXSQLHelper

Returns the width that should be used for a varcharLarge column in migrations.

Overrides:

varcharLargeColumnWidth in class ERXSQLHelper

Returns:

the width that should be used for a varcharLarge column in migrations

sqlForCreateUniqueIndex

public java.lang.String sqlForCreateUniqueIndex(java.lang.String indexName,
                                                java.lang.String tableName,
                                                ERXSQLHelper.ColumnIndex... columnIndexes)

Description copied from class: ERXSQLHelper

Returns the SQL expression for creating a unique index on the given set of columns

Overrides:

sqlForCreateUniqueIndex in class ERXSQLHelper

Parameters:

indexName - the name of the index to create

tableName - the name of the containing table

columnIndexes - the list of columns to index on

Returns:

a SQL expression

migrationTableName

public java.lang.String migrationTableName()

Description copied from class: ERXSQLHelper

Returns the name of the table to use for database migrations.

Overrides:

migrationTableName in class ERXSQLHelper

Returns:

the name of the table to use for database migrations

externalTypeForJDBCType

public java.lang.String externalTypeForJDBCType(com.webobjects.jdbcadaptor.JDBCAdaptor adaptor,
                                                int jdbcType)

Description copied from class: ERXSQLHelper

JDBCAdaptor.externalTypeForJDBCType just returns the first type it finds instead of trying to find a best match. This can still fail, mind you, but it should be much better than the EOF default impl.

Overrides:

externalTypeForJDBCType in class ERXSQLHelper

Parameters:

adaptor - the adaptor to retrieve an external type for

jdbcType - the JDBC type number

Returns:

a guess at the external type name to use