public static class ERXSQLHelper.H2SQLHelper extends ERXSQLHelper
ERXSQLHelper.ColumnIndex, ERXSQLHelper.CustomTypes, ERXSQLHelper.DB2SQLHelper, ERXSQLHelper.DerbySQLHelper, ERXSQLHelper.EROracleSQLHelper, ERXSQLHelper.FirebirdSQLHelper, ERXSQLHelper.FrontBaseSQLHelper, ERXSQLHelper.H2SQLHelper, ERXSQLHelper.MicrosoftSQLHelper, ERXSQLHelper.MySQLSQLHelper, ERXSQLHelper.NoSQLHelper, ERXSQLHelper.OpenBaseSQLHelper, ERXSQLHelper.OracleSQLHelper, ERXSQLHelper.PostgresqlSQLHelperlog| Constructor and Description |
|---|
H2SQLHelper() |
| Modifier and Type | Method and Description |
|---|---|
java.lang.String |
limitExpressionForSQL(EOSQLExpression expression,
EOFetchSpecification fetchSpecification,
java.lang.String sql,
long start,
long end) |
java.lang.String |
sqlForCreateIndex(java.lang.String indexName,
java.lang.String tableName,
ERXSQLHelper.ColumnIndex... columnIndexes)
Returns the SQL expression for creating an index on the given set
of columns
|
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
|
protected java.lang.String |
sqlForGetNextValFromSequencedNamed(java.lang.String sequenceName)
Returns the SQL required to select the next value from the given sequence.
|
java.lang.String |
sqlForRegularExpressionQuery(java.lang.String key,
java.lang.String value)
Returns the SQL expression for a regular expression query.
|
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.
|
_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, externalTypeForJDBCType, formatValueForAttribute, getNextValFromSequenceNamed, handleDatabaseException, jdbcTypeForCustomType, maximumElementPerInClause, migrationTableName, newSQLHelper, newSQLHelper, newSQLHelper, newSQLHelper, newSQLHelper, newSQLHelper, newSQLHelper, newSQLHelper, newSQLHelper, newSQLHelper, newSQLHelper, newSQLHelper, newSQLHelper, prepareConnectionForSchemaChange, quoteColumnName, readFormatForAggregateFunction, readFormatForAggregateFunction, reassignExternalTypeForValueTypeOverride, removeSelectFromExpression, restoreConnectionSettingsAfterSchemaChange, rowCountForFetchSpecification, shouldExecute, shouldPerformDistinctInMemory, splitSQLStatements, splitSQLStatementsFromFile, splitSQLStatementsFromInputStream, sqlExpressionForFetchSpecification, sqlExpressionForFetchSpecification, sqlForCountDistinct, sqlForCreateIndex, sqlForCreateUniqueIndex, sqlForFullTextQuery, sqlForSubquery, sqlWhereClauseStringForKeypublic java.lang.String limitExpressionForSQL(EOSQLExpression expression, EOFetchSpecification fetchSpecification, java.lang.String sql, long start, long end)
limitExpressionForSQL in class ERXSQLHelperpublic java.lang.String sqlForCreateUniqueIndex(java.lang.String indexName,
java.lang.String tableName,
ERXSQLHelper.ColumnIndex... columnIndexes)
ERXSQLHelpersqlForCreateUniqueIndex in class ERXSQLHelperindexName - the name of the index to createtableName - the name of the containing tablecolumnIndexes - the list of columns to index onpublic java.lang.String sqlForCreateIndex(java.lang.String indexName,
java.lang.String tableName,
ERXSQLHelper.ColumnIndex... columnIndexes)
ERXSQLHelpersqlForCreateIndex in class ERXSQLHelperindexName - the name of the index to createtableName - the name of the containing tablecolumnIndexes - the list of columns to index onprotected java.lang.String sqlForGetNextValFromSequencedNamed(java.lang.String sequenceName)
ERXSQLHelpersqlForGetNextValFromSequencedNamed in class ERXSQLHelpersequenceName - the name of the sequenceERXSQLHelper.sqlForGetNextValFromSequencedNamed(java.lang.String)public java.lang.String sqlForRegularExpressionQuery(java.lang.String key,
java.lang.String value)
ERXSQLHelpersqlForRegularExpressionQuery in class ERXSQLHelperpublic int varcharLargeJDBCType()
ERXSQLHelpervarcharLargeJDBCType in class ERXSQLHelperpublic int varcharLargeColumnWidth()
ERXSQLHelpervarcharLargeColumnWidth in class ERXSQLHelperCopyright © 2002 – 2022 Project Wonder.