P2JH2Dialect (P2J - Progress 4GL to Java Conversion and Runtime)

java.lang.Object
- com.goldencode.p2j.persist.dialect.Dialect
- - com.goldencode.p2j.persist.dialect.P2JH2Dialect

public class P2JH2Dialect
extends Dialect

Extends abstract Dialect for an H2 backend.

Nested Class Summary

Nested Classes
Modifier and Type Class and Description

static class P2JH2Dialect.SumAggregator
Helper interface for weights' aggregation
- Nested classes/interfaces inherited from class com.goldencode.p2j.persist.dialect.Dialect
  Dialect.WeightAggregator

Nested Classes
Modifier and Type	Class and Description
`static class`	`P2JH2Dialect.SumAggregator` Helper interface for weights' aggregation

Field Summary

Fields
Modifier and Type	Field and Description
`private static java.util.List<java.lang.String>`	`AFTER_INSERT_TRIGGER` AFTER INSERT trigger for words tables' support template
`private static java.util.List<java.lang.String>`	`AFTER_UPDATE_TRIGGER` AFTER UPDATE trigger for words tables' support template
`private static java.lang.String`	`DROP_TRIGGER` DROP TRIGGER statement
`private static java.util.Map<java.lang.String,java.lang.String>`	`fwd2sql` Mapping between the FWD possible field/column types and their SQL counterparts.
`private static CentralLogger`	`LOG` Logger
`private static java.lang.String`	`PK` Name of the primary key column.
`static java.util.regex.Pattern`	`UDF_ERROR_MESSAGE` Regex Pattern for parsing message cased by error raised by UDF.
`private static Dialect.WeightAggregator`	`WEIGHT_AGGREGATOR` Weights' aggregator

Fields inherited from class com.goldencode.p2j.persist.dialect.Dialect
CASE_TYPE_TOK, DEFAULT_MAX_WIDTH, SCALE_TOK

Constructor Summary

Constructors
Constructor and Description

P2JH2Dialect()
Default constructor.

Constructors
Constructor and Description
`P2JH2Dialect()` Default constructor.

Method Summary

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`void`	`addRtrimmedExpression(java.lang.String expr, java.lang.StringBuilder sb)` Composes a rtrim equivalent call for a specified expression.
`boolean`	`allowBindParamsInRecursiveCTE()` Check if bind parameters in recursive CTEs are supported.
`boolean`	`allowDBUniqueCheck()` Determine if the `Dialect` supports index validation (with the VALIDATE keyword).
`boolean`	`allowSelectWildcard()` Check if this dialect allows the selection of fields using * wildcard.
`void`	`beforeDriverLoad()` Set any database parameters before, to be available when the database driver is loaded.
`java.sql.Blob`	`blobCreator(java.sql.Connection conn, byte[] bytes)` Create a `Blob` instance from the specified bytes.
`java.lang.String`	`buildRemoteURL(java.lang.String url, Database database)` Build the URL to be used for a remote connection, based on the given URL and database.
`java.sql.Clob`	`clobCreator(java.sql.Connection conn, java.lang.String value)` Create a `Clob` instance from the specified value.
`java.lang.String`	`containsUdfName()` Return the name of the CONTAINS UDF
`java.lang.Object`	`createContext(Persistence persistence)` Create a data object, the purpose of which is specific to a particular dialect implementation, to be stored as a context-local object.
`SequenceHandler`	`createSequenceHandler(java.lang.String ldbName)` Creates and returns a `SequenceHandler` for a H2 database.
`ErrorManager.ErrorEntry`	`errorEntry(java.lang.String message)` Create the error descriptor from the SQLException message
`boolean`	`explicitSetCollation()` Check if the dialect needs to set an explicit collation during schema DDL generation.
`java.lang.String`	`extractColumnName(java.lang.String expr)` Given a native column name as queried from database metadata, extract the root name of a column.
`java.lang.String`	`formatDate(date d)` Format a date object as a string which is appropriate for use in an SQL statement.
`void`	`generateWordTablesDDLImpl(java.lang.String dbName, java.io.PrintStream out, java.lang.String eoln, java.util.Collection<WordTable> wordTables)` Worker method for `generateTriggerDDLs()`.
`java.lang.String`	`getAddForeignKeyConstraintString(java.lang.String table, java.lang.String fkName, java.lang.String fkFields, java.lang.String refTable, java.lang.String refFields, java.lang.String indent, java.lang.String eoln)` Creates and returns a string which represent the `alter table` statement for adding a new foreign key constraint.
`java.lang.String`	`getAnalyzeString(java.lang.String table)` Construct and return a string which represents the `analyze` or similar statements for this dialect.
`java.lang.String`	`getCodepage(java.sql.Connection conn)` Use the provided database connection to extract the codepage/CharSet used by the database and report it back to the caller.
`java.lang.String`	`getCollation(java.sql.Connection conn)` Use the provided database connection to extract the collation used by the database and report it back to the caller.
`java.lang.String`	`getCreateIndexString(boolean unique, boolean softUnique)` Returns the beginning of the DDL statement for creating an index.
`java.lang.String`	`getCreateSequenceString(java.lang.String name)` Generate a DDL string which will create a global sequence.
`java.lang.String`	`getCreateSequenceString(java.lang.String name, boolean isTemporary)` Generate a DDL string which will create a global sequence.
`java.lang.String`	`getCreateSequenceString(java.lang.String name, long start)` Generate a DDL string which will create a global sequence with the given starting value.
`java.lang.String`	`getCreateSequenceString(java.lang.String name, java.lang.Long init, java.lang.Long increment, java.lang.Long minVal, java.lang.Long maxVal, java.lang.Boolean cycle)` Generate a DDL string which will create a sequence with given properties.
`java.lang.String`	`getCreateTemporaryTablePostfix(boolean noUndo)` Return the ending of the DDL statement that creates a temporary table.
`java.lang.String`	`getCreateTemporaryTableString(boolean ifNotExist)` Return the beginning of the DDL statement that creates a temporary table.
`java.util.List<java.lang.String>`	`getDatabasePrepareStatements(Database database)` Get a list of database prepare DDL statements.
`java.lang.String`	`getDelimiter()` Get the statement delimiter for this dialect.
`java.lang.String`	`getDriverClassName()` Get the name of the JDBC driver class associated with this dialect.
`java.lang.String`	`getDropIndexString(boolean ifExists, java.lang.String idxName, java.lang.String tableName)` Obtain a DDL statement which drops a SQL index.
`java.lang.String`	`getDropIndexString(P2JIndex index)` Build the DDL to drop an index based upon the specified definition.
`java.lang.String`	`getDropSequenceString(java.lang.String name)` Generate a DDL string which will drop a sequence.
`java.lang.String`	`getDropTableString(boolean ifExists, java.lang.String tableName)` Obtain a DDL statement which drops a SQL table.
`int`	`getIndexLengthLimit()` Some dialects do have constraints about the maximum size of fields that compose an index.
`java.lang.String`	`getInvisibleSpecificator()` Return a string which marks that a column is computed, so it should be marked as invisible to allow implicit skipping of it when using wildcard selection (*) or direct access.
`java.lang.String`	`getJdbcDatabaseType()` Get the name of the JDBC database type (as in JBC URL).
`int`	`getMaxParameterCount()` Obtain the number of parameters a query of this dialect is allowed by the SQL server.
`java.lang.String`	`getProcessedCharacterColumnName(java.lang.String name, boolean ignoreCase)` Adjust a character column name appropriate to this dialect, such that it can be inserted into an index.
`static java.util.List<java.lang.String>`	`getReservedKeywords()` Get a collection of reserved keywords specific to this dialect.
`ScriptRunner`	`getScriptRunner()` Get a ScriptRunner instance for the dialect.
`java.lang.String`	`getSequenceCurrValString()` Generate the appropriate select statement to retrieve the current value of a sequence.
`java.lang.String`	`getSequenceCurrValString(java.lang.String sequenceName)` Generate the appropriate select statement to retrieve the current value of a sequence.
`java.lang.String`	`getSequenceNextValString(java.lang.String sequenceName)` Generate the appropriate select statement to retrieve the next value of a sequence.
`java.lang.String`	`getSequencePrefetchString(java.lang.String sequenceName)` Generate the appropriate select statement to pre-fetch multiple, ascending values from a sequence.
`java.lang.String`	`getSequenceSetValString()` Generate the appropriate select statement to reset the value of a sequence.
`java.lang.String`	`getSequenceSetValString(java.lang.String sequenceName)` Generate the appropriate select statement to reset the value of a sequence.
`java.lang.String`	`getSequenceSetValString(java.lang.String sequenceName, long newVal)` Generate the appropriate select statement to reset the value of a sequence.
`java.lang.String`	`getSpecificTypeAsString(FqlType type)` Converts and return the specified `FqlType` to a string representation which can be used in a SQL query (`cast` or other construct).
`java.lang.String`	`getSqlIndexName(P2JIndex index)` Obtain the name of an index.
`java.lang.String`	`getSqlMappedType(java.lang.String fwdType, int scale, java.lang.Boolean caseSensitive)` Get the SQL mapping for a specific FWD data type.
`int`	`getSyntheticIndexSize(boolean unique)` Returns the size of the synthetic part of the index.
`boolean`	`hasFullSequenceSupport()` Returns `true` if this dialect fully support the sequences as 4GL language (most important: bounded values, cycle).
`java.lang.String`	`id()` Get dialect id.
`boolean`	`injectComputedColumns()` Report whether the computed columns should be injected on table creating.
`void`	`inlineLimit(boolean on)` Enable/disable limit clause inlining.
`boolean`	`isAutoCi()` Returns `true` if the dialect handles case-insensitive compare operations for case-insensitive character columns
`boolean`	`isAutoRtrim()` Returns `true` if the dialect handles automatically rtrimming for character columns.
`boolean`	`isCaseInsensitiveColumn(java.lang.String name)` Report whether the given column name represents an alias or an expression which indicates the column is case insensitive.
`boolean`	`isConnectionError(java.lang.Exception exc)` Given an exception, this method will check if it indicates a database connectivity error.
`boolean`	`isMetadataSortAsc(java.lang.String value)` Check if the given value is an asceding clause for a column index.
`boolean`	`isMetadataSortDesc(java.lang.String value)` Check if the given value is a desceding clause for a column index.
`boolean`	`isNativeUDFsSupported()` Check if native UDFs are supported for the dialect
`boolean`	`isQueryRangeParameterInlined()` Indicate whether a query parameter which is part of a range check should be inlined into the where clause, or whether it should be substituted into a prepared statement.
`boolean`	`isUdfContains(java.lang.String name)` Check if the provided name is the name of the CONTAINS UDF
`boolean`	`isUdfOriginatedError(java.sql.SQLException e)` Check if UDF should be used for converted CONTAINS operator
`boolean`	`isUdfOriginatedWarning(java.sql.SQLException e)` Check if the exception was caused by a warning in UDF.
`boolean`	`isUniqueConstraintViolation(java.sql.SQLException sqle)` Checks if the SQLState of the SQLException matches the dialect specific UNIQUE_VIOLATION code for H2 (23505).
`private static java.lang.String`	`mapCP(java.lang.String h2Charset)` Maps the H2 specific charset names to 4GL codepage names.
`boolean`	`needsComputedColumns()` Indicate whether this dialect requires computed columns to participate within index definitions, instead of embedded expressions.
`int`	`orderByNulls(java.lang.StringBuilder sb, java.lang.String expression, java.lang.String field, boolean asc, boolean forceAsc)` Determine if the sort component or index needs to be augmented with a NULLS FIRST/LAST option and add the required expression.
`void`	`postTransaction(Persistence persistence, java.lang.Object context, boolean rollback)` A dialect-specific callback hook which is invoked by the persistence runtime framework after a transaction is complete.
`java.lang.String`	`prepareMetadataParameter(java.lang.String param)` Prepare the given metadata query parameter by making it uppercase.
`void`	`preparePermanentDatabase(Database db)` Prepare the specified database by creating all necessary function aliases and setting global parameters.
`java.lang.String`	`processMetadataResult(java.lang.String value)` Process the given metadata query result, by making it lowercase.
`boolean`	`requiresExplicitCastInsideTernary()` Determines whether substitution parameters should be explicitly casted to their datatypes inside "then ? else ?" statement.
`ScriptSplitter`	`scriptSplitter()` Get the splitter for DDL scripts.
`boolean`	`supportsBooleanDatatype()` Indicates whether this dialect supports boolean datatype.
`boolean`	`supportsFunctionOverloading()` Indicate whether this dialect natively supports the overloading of user defined functions by parameter number and data type.
`boolean`	`supportsLazyQueryResultsMode()` Determine if this `Dialect` supports queries executed in a lazy manner.
`boolean`	`useCTE4Contains()` Check if Common Table Expressions should be used for converted CONTAINS operator
`boolean`	`useMixedNode4Contains()` Check if mixed mode re-write should be used for converted CONTAINS operator
`boolean`	`useNullEquality()` Returns `true` if the dialect handles null equality.
`boolean`	`useUdf4Contains()` Check if UDF should be used for converted CONTAINS operator
`boolean`	`useWordTables()` Check if word tables should be used for converted CONTAINS operator
`java.util.Optional<Dialect.WeightAggregator>`	`weightAggregator()` Get the WeightAggregator instance for the dialect if defined

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- Field Detail
  - LOG
```
private static final CentralLogger LOG
```
    Logger
  - PK
```
private static final java.lang.String PK
```
    Name of the primary key column.
  - fwd2sql
```
private static final java.util.Map<java.lang.String,java.lang.String> fwd2sql
```
    Mapping between the FWD possible field/column types and their SQL counterparts.
  - WEIGHT_AGGREGATOR
```
private static final Dialect.WeightAggregator WEIGHT_AGGREGATOR
```
    Weights' aggregator
  - UDF_ERROR_MESSAGE
```
public static final java.util.regex.Pattern UDF_ERROR_MESSAGE
```
    Regex Pattern for parsing message cased by error raised by UDF.
  - AFTER_INSERT_TRIGGER
```
private static final java.util.List<java.lang.String> AFTER_INSERT_TRIGGER
```
    AFTER INSERT trigger for words tables' support template
  - AFTER_UPDATE_TRIGGER
```
private static final java.util.List<java.lang.String> AFTER_UPDATE_TRIGGER
```
    AFTER UPDATE trigger for words tables' support template
  - DROP_TRIGGER
```
private static final java.lang.String DROP_TRIGGER
```
    DROP TRIGGER statement
    
    See Also:
    
    Constant Field Values
- Constructor Detail
  - P2JH2Dialect
```
public P2JH2Dialect()
```
    Default constructor. This constructor is for Hibernate's use. Use code should not construct instances of this class.
    We provide this constructor to override the superclass' mapping of Types.VARCHAR, in order to force this type to map to PostgreSQL's text data type.
- Method Detail
  - getReservedKeywords
```
public static java.util.List<java.lang.String> getReservedKeywords()
```
    Get a collection of reserved keywords specific to this dialect. The NameConverter uses thes list to create an exclusion list of names so there will not be schema collisions with identifiers (tables, fields) from the generated schema.
    
    Returns:
    
    A list with H2 1.3.176 reserved keywords.
    
    See Also:
    
    http://www.h2database.com/html/advanced.html#compatibility
  - getDriverClassName
```
public java.lang.String getDriverClassName()
```
    Get the name of the JDBC driver class associated with this dialect.
    
    Specified by:
    
    getDriverClassName in class Dialect
    
    Returns:
    
    Fully qualified driver class name.
  - getJdbcDatabaseType
```
public java.lang.String getJdbcDatabaseType()
```
    Get the name of the JDBC database type (as in JBC URL).
    
    Specified by:
    
    getJdbcDatabaseType in class Dialect
    
    Returns:
    
    The name of the JDBC database type.
  - needsComputedColumns
```
public boolean needsComputedColumns()
```
    Indicate whether this dialect requires computed columns to participate within index definitions, instead of embedded expressions.
    
    Specified by:
    
    needsComputedColumns in class Dialect
    
    Returns:
    
    true to indicate computed columns are required.
  - supportsFunctionOverloading
```
public boolean supportsFunctionOverloading()
```
    Indicate whether this dialect natively supports the overloading of user defined functions by parameter number and data type.
    
    Specified by:
    
    supportsFunctionOverloading in class Dialect
    
    Returns:
    
    false.
  - supportsBooleanDatatype
```
public boolean supportsBooleanDatatype()
```
    Indicates whether this dialect supports boolean datatype. Support includes:
    - usage of true and false literals;
    - operations with boolean values;
    - allowing functions to have booleans as parameters and return datatype.
    Specified by:
    
    supportsBooleanDatatype in class Dialect
    
    Returns:
    
    Always true, all the above mentioned items are supported.
  - createContext
```
public java.lang.Object createContext(Persistence persistence)
```
    Create a data object, the purpose of which is specific to a particular dialect implementation, to be stored as a context-local object. This allows a dialect to establish context-local data which is stored by the persistence runtime framework, without the overhead of a separate, context-local variable. This object will be handed back to the dialect in callback methods when the services of certain hooks are required.
    Since the context-local data is specific to a particular dialect implementation, it is optional. Dialect implementations which do not have a need for this data should simply return null.
    
    Overrides:
    
    createContext in class Dialect
    
    Parameters:
    
    persistence - Provider of persistence services.
    
    Returns:
    
    Dialect-specific, context-local data, or null.
  - postTransaction
```
public void postTransaction(Persistence persistence,
                            java.lang.Object context,
                            boolean rollback)
                     throws PersistenceException
```
    A dialect-specific callback hook which is invoked by the persistence runtime framework after a transaction is complete. The Hibernate session will have been closed by the time this method is invoked.
    
    Overrides:
    
    postTransaction in class Dialect
    
    Parameters:
    
    persistence - Provider of persistence services.
    
    context - Optional, context-local data created previously by createContext(com.goldencode.p2j.persist.Persistence).
    
    rollback - true if transaction ended with a rollback; false if transaction ended with a commit.
    
    Throws:
    
    PersistenceException - if any persistence-related error occurs.
  - formatDate
```
public java.lang.String formatDate(date d)
```
    Format a date object as a string which is appropriate for use in an SQL statement.
    
    Specified by:
    
    formatDate in class Dialect
    
    Parameters:
    
    d - Date to be formatted as a string.
    
    Returns:
    
    Formatted representation of the given date.
  - extractColumnName
```
public java.lang.String extractColumnName(java.lang.String expr)
```
    Given a native column name as queried from database metadata, extract the root name of a column. For example, a column name as found within an index in metadata might be represented as:
```
    __my_column
 
```
    We are interested only in the my_column root name, so we strip away the leading __ prefix.
    Specified by:
    
    extractColumnName in class Dialect
    
    Parameters:
    
    expr - Column name as natively represented by the database dialect.
    
    Returns:
    
    Root column name.
  - getProcessedCharacterColumnName
```
public java.lang.String getProcessedCharacterColumnName(java.lang.String name,
                                                        boolean ignoreCase)
```
    Adjust a character column name appropriate to this dialect, such that it can be inserted into an index. This involves prepending a special prefix to designate a computed column.
    
    Specified by:
    
    getProcessedCharacterColumnName in class Dialect
    
    Parameters:
    
    name - Base column name.
    
    ignoreCase - true to cause case to be ignored, else false.
    
    Returns:
    
    Processed column name.
  - isCaseInsensitiveColumn
```
public boolean isCaseInsensitiveColumn(java.lang.String name)
```
    Report whether the given column name represents an alias or an expression which indicates the column is case insensitive. Assume the column represented by name is already determined to be the appropriate data type for textual data.
    
    Specified by:
    
    isCaseInsensitiveColumn in class Dialect
    
    Parameters:
    
    name - Column name, alias, or expression.
    
    Returns:
    
    true if name represents case-insensitive data.
  - getCreateSequenceString
```
public java.lang.String getCreateSequenceString(java.lang.String name)
```
    Generate a DDL string which will create a global sequence.
    
    Specified by:
    
    getCreateSequenceString in class Dialect
    
    Parameters:
    
    name - Sequence name.
    
    Returns:
    
    Dialect-specific string to create the sequence, or null if not supported.
  - getCreateSequenceString
```
public java.lang.String getCreateSequenceString(java.lang.String name,
                                                boolean isTemporary)
```
    Generate a DDL string which will create a global sequence.
    
    Overrides:
    
    getCreateSequenceString in class Dialect
    
    Parameters:
    
    name - Sequence name.
    
    isTemporary - If the sequence should be temporary or not.
    
    Returns:
    
    Dialect-specific string to create the sequence, or null if not supported.
  - getCreateSequenceString
```
public java.lang.String getCreateSequenceString(java.lang.String name,
                                                long start)
```
    Generate a DDL string which will create a global sequence with the given starting value.
    
    Specified by:
    
    getCreateSequenceString in class Dialect
    
    Parameters:
    
    name - Sequence name.
    
    start - Sequence starting value.
    
    Returns:
    
    Dialect-specific string to create the sequence, or null if not supported.
  - getCreateSequenceString
```
public java.lang.String getCreateSequenceString(java.lang.String name,
                                                java.lang.Long init,
                                                java.lang.Long increment,
                                                java.lang.Long minVal,
                                                java.lang.Long maxVal,
                                                java.lang.Boolean cycle)
```
    Generate a DDL string which will create a sequence with given properties.
    
    Specified by:
    
    getCreateSequenceString in class Dialect
    
    Parameters:
    
    name - Sequence name. Mandatory not null.
    
    init - Sequence starting value. Mandatory(not null).
    
    increment - Sequence incrementing value. Mandatory(not null).
    
    minVal - Sequence minimum value. Optional (may be null).
    
    maxVal - Sequence maximum value. Optional (may be null).
    
    cycle - Sequence cycling property. Optional, if missing assumed not cycling.
    
    Returns:
    
    Dialect-specific string to create the sequence, or null if not supported.
  - getDropSequenceString
```
public java.lang.String getDropSequenceString(java.lang.String name)
```
    Generate a DDL string which will drop a sequence.
    
    Specified by:
    
    getDropSequenceString in class Dialect
    
    Parameters:
    
    name - The name of the sequence to be dropped.
    
    Returns:
    
    Dialect-specific string to drop the sequence, or null if not supported.
  - getSequenceSetValString
```
public java.lang.String getSequenceSetValString(java.lang.String sequenceName,
                                                long newVal)
```
    Generate the appropriate select statement to reset the value of a sequence.
    
    Specified by:
    
    getSequenceSetValString in class Dialect
    
    Parameters:
    
    sequenceName - The name of the sequence.
    
    newVal - The new value to be set.
    
    Returns:
    
    Dialect-specific string to query the sequence, or null if not supported.
  - getSequenceSetValString
```
public java.lang.String getSequenceSetValString(java.lang.String sequenceName)
```
    Generate the appropriate select statement to reset the value of a sequence.
    
    Specified by:
    
    getSequenceSetValString in class Dialect
    
    Parameters:
    
    sequenceName - The name of the sequence.
    
    Returns:
    
    Dialect-specific string to query the sequence, or null if not supported.
  - getSequenceSetValString
```
public java.lang.String getSequenceSetValString()
```
    Generate the appropriate select statement to reset the value of a sequence.
    
    Specified by:
    
    getSequenceSetValString in class Dialect
    
    Returns:
    
    Dialect-specific string to query the sequence, or null if not supported.
  - getSequenceCurrValString
```
public java.lang.String getSequenceCurrValString(java.lang.String sequenceName)
```
    Generate the appropriate select statement to retrieve the current value of a sequence.
    
    Specified by:
    
    getSequenceCurrValString in class Dialect
    
    Parameters:
    
    sequenceName - The name of the sequence to be queried.
    
    Returns:
    
    Dialect-specific string to query the sequence, or null if not supported.
  - getSequenceCurrValString
```
public java.lang.String getSequenceCurrValString()
```
    Generate the appropriate select statement to retrieve the current value of a sequence.
    
    Overrides:
    
    getSequenceCurrValString in class Dialect
    
    Returns:
    
    Dialect-specific string to query the sequence, or null if not supported.
  - hasFullSequenceSupport
```
public boolean hasFullSequenceSupport()
```
    Returns true if this dialect fully support the sequences as 4GL language (most important: bounded values, cycle). If not fully supported, additional code is needed in P2J sequence class implementation to fix this.
    
    Specified by:
    
    hasFullSequenceSupport in class Dialect
    
    Returns:
    
    false as H2 dialect does not fully support 4GL sequences
  - getSequencePrefetchString
```
public java.lang.String getSequencePrefetchString(java.lang.String sequenceName)
```
    Generate the appropriate select statement to pre-fetch multiple, ascending values from a sequence. The values need not be contiguous.
    
    Specified by:
    
    getSequencePrefetchString in class Dialect
    
    Parameters:
    
    sequenceName - The name of the sequence from which the values are to be retrieved.
    
    Returns:
    
    Dialect-specific SQL expression, or null if this feature is not supported by the dialect.
  - getSequenceNextValString
```
public java.lang.String getSequenceNextValString(java.lang.String sequenceName)
```
    Generate the appropriate select statement to retrieve the next value of a sequence.
    
    Specified by:
    
    getSequenceNextValString in class Dialect
    
    Parameters:
    
    sequenceName - The name of the sequence to be queried.
    
    Returns:
    
    Dialect-specific string to query the sequence, or null if not supported.
  - isConnectionError
```
public boolean isConnectionError(java.lang.Exception exc)
```
    Given an exception, this method will check if it indicates a database connectivity error.
    Currently, as the H2 database is used only for in-memory temp-tables, this method returns false.
    
    Specified by:
    
    isConnectionError in class Dialect
    
    Parameters:
    
    exc - The exception to be checked.
    
    Returns:
    
    true if the exception indicates a database connectivity error.
  - isQueryRangeParameterInlined
```
public boolean isQueryRangeParameterInlined()
```
    Indicate whether a query parameter which is part of a range check should be inlined into the where clause, or whether it should be substituted into a prepared statement. This will result in an "inlined" substitution parameter within a where clause. For example, given a where clause of:
```
    where value ≥ ? and id = ?
 
```
    along with respective substitution parameters of 45 and 100, the inlined version would read:
```
    where value ≥ 45 and id = ?
 
```
    Only the id substitution parameter of 100 would be substituted into the prepared statement.
    Inlining in such a way can give some database dialects the opportunity to choose a better query plan, than if the parameter being tested with a range check were to be substituted at statement execution time.
    Note: this serves as a hint which may be overridden by runtime logic or other configuration settings.
    Specified by:
    
    isQueryRangeParameterInlined in class Dialect
    
    Returns:
    
    true to inline range check parameters; false to use normal parameter substitution.
  - inlineLimit
```
public void inlineLimit(boolean on)
```
    Enable/disable limit clause inlining. Inlining the limit clause will cause the limit/max value to be hard-coded into the SQL statement, rather than being bound as a substitution parameter.
    Dialects are free to treat this method as a hint. This implementation does nothing.
    
    Specified by:
    
    inlineLimit in class Dialect
    
    Parameters:
    
    on - true to enable inlining; false to disable it.
  - requiresExplicitCastInsideTernary
```
public boolean requiresExplicitCastInsideTernary()
```
    Determines whether substitution parameters should be explicitly casted to their datatypes inside "then ? else ?" statement.
    
    Specified by:
    
    requiresExplicitCastInsideTernary in class Dialect
    
    Returns:
    
    true.
  - allowBindParamsInRecursiveCTE
```
public boolean allowBindParamsInRecursiveCTE()
```
    Check if bind parameters in recursive CTEs are supported.
    
    Overrides:
    
    allowBindParamsInRecursiveCTE in class Dialect
    
    Returns:
    
    true if bind parameters in recursive CTEs are supported.
  - getDropIndexString
```
public java.lang.String getDropIndexString(P2JIndex index)
```
    Build the DDL to drop an index based upon the specified definition. The SQL is generated by using the database-specific dialect.
    
    Specified by:
    
    getDropIndexString in class Dialect
    
    Parameters:
    
    index - Definition of the index to be dropped.
    
    Returns:
    
    The DDL to drop the given index.
  - getInvisibleSpecificator
```
public java.lang.String getInvisibleSpecificator()
```
    Return a string which marks that a column is computed, so it should be marked as invisible to allow implicit skipping of it when using wildcard selection (*) or direct access.
    
    Overrides:
    
    getInvisibleSpecificator in class Dialect
    
    Returns:
    
    An SQL string specificator for invisible columns. null means that no such specificator is supported.
  - prepareMetadataParameter
```
public java.lang.String prepareMetadataParameter(java.lang.String param)
```
    Prepare the given metadata query parameter by making it uppercase.
    
    Specified by:
    
    prepareMetadataParameter in class Dialect
    
    Parameters:
    
    param - The metadata query parameter.
    
    Returns:
    
    the uppercased parameter.
  - processMetadataResult
```
public java.lang.String processMetadataResult(java.lang.String value)
```
    Process the given metadata query result, by making it lowercase.
    
    Specified by:
    
    processMetadataResult in class Dialect
    
    Parameters:
    
    value - The metadata query result.
    
    Returns:
    
    the lowercased result.
  - isMetadataSortDesc
```
public boolean isMetadataSortDesc(java.lang.String value)
```
    Check if the given value is a desceding clause for a column index.
    
    Specified by:
    
    isMetadataSortDesc in class Dialect
    
    Parameters:
    
    value - The value to be checked.
    
    Returns:
    
    true if the value is the "D" or "d" string.
  - isMetadataSortAsc
```
public boolean isMetadataSortAsc(java.lang.String value)
```
    Check if the given value is an asceding clause for a column index.
    
    Specified by:
    
    isMetadataSortAsc in class Dialect
    
    Parameters:
    
    value - The value to be checked.
    
    Returns:
    
    true if the value is the "A" or "a" string.
  - getDatabasePrepareStatements
```
public java.util.List<java.lang.String> getDatabasePrepareStatements(Database database)
```
    Get a list of database prepare DDL statements.
    
    Overrides:
    
    getDatabasePrepareStatements in class Dialect
    
    Parameters:
    
    database - The database which needs to be prepared.
    
    Returns:
    
    The statement list.
  - explicitSetCollation
```
public boolean explicitSetCollation()
```
    Check if the dialect needs to set an explicit collation during schema DDL generation.
    
    Specified by:
    
    explicitSetCollation in class Dialect
    
    Returns:
    
    always true.
  - getDelimiter
```
public java.lang.String getDelimiter()
```
    Get the statement delimiter for this dialect.
    
    Specified by:
    
    getDelimiter in class Dialect
    
    Returns:
    
    the statement delimiter.
  - beforeDriverLoad
```
public void beforeDriverLoad()
```
    Set any database parameters before, to be available when the database driver is loaded.
    The "h2.sortNullsHigh" setting was removed, as it was determined that by forcing the H2 to sort nulls high, it causes a regression in a test where 4GL seems to sort the unknown value at the end of the result set, when an descending sort clause was used (instead of sorting it at the begining of the result set).
    TODO: more testing needs to be done to determine exactly how 4GL sorts the unknown value in the temporary database (and permanent DB too). At the time of this comment, H2 has a bug which doesn't enforce the "sort nulls high" setting in cases when the query's result order is determined by the index.
    
    Overrides:
    
    beforeDriverLoad in class Dialect
  - buildRemoteURL
```
public java.lang.String buildRemoteURL(java.lang.String url,
                                       Database database)
                                throws PersistenceException
```
    Build the URL to be used for a remote connection, based on the given URL and database.
    
    Specified by:
    
    buildRemoteURL in class Dialect
    
    Parameters:
    
    url - The URL as received from the remote server. If this indicates an embedded database, a mixed mode URL which will allow secure (i.e., SSL), remote connections to that database is generated. The mixed mode port is fixed.
    
    database - The database to which this URL belongs.
    
    Returns:
    
    The built URL as to be used for a remote connection.
    
    Throws:
    
    PersistenceException - if the specified connection URL is invalid.
  - createSequenceHandler
```
public SequenceHandler createSequenceHandler(java.lang.String ldbName)
```
    Creates and returns a SequenceHandler for a H2 database.
    
    Specified by:
    
    createSequenceHandler in class Dialect
    
    Parameters:
    
    ldbName - The logical name of the database to create the SequenceHandler for.
    
    Returns:
    
    A H2SequenceHandler for respective database.
  - injectComputedColumns
```
public boolean injectComputedColumns()
```
    Report whether the computed columns should be injected on table creating.
    
    Specified by:
    
    injectComputedColumns in class Dialect
    
    Returns:
    
    true for H2 database.
  - isUniqueConstraintViolation
```
public boolean isUniqueConstraintViolation(java.sql.SQLException sqle)
```
    Checks if the SQLState of the SQLException matches the dialect specific UNIQUE_VIOLATION code for H2 (23505). It unwraps the SQLException until an SQLState matching the code is found, or there is no exception to unwrap anymore.
    
    Specified by:
    
    isUniqueConstraintViolation in class Dialect
    
    Parameters:
    
    sqle - The SQLException that is causing the unique constraint violation.
    
    Returns:
    
    true if the SQLState matches the dialect specific code for UNIQUE_VIOLATION, false otherwise.
  - getIndexLengthLimit
```
public int getIndexLengthLimit()
```
    Some dialects do have constraints about the maximum size of fields that compose an index. This method reports the dialect-specific index length limit, if any.
    
    Overrides:
    
    getIndexLengthLimit in class Dialect
    
    Returns:
    
    always 0 as this dialect do not have any known constraints about the maximum size of the fields of an index.
  - getSyntheticIndexSize
```
public int getSyntheticIndexSize(boolean unique)
```
    Returns the size of the synthetic part of the index. At this moment only the id of the record may be additionally added to an index to add custom properties (eg uniqueness) but other fields could be added. This part of the index is not visible using index reflection routines from IndexHelper. The synthetic components may differ between unique and non-unique indexes.
    See Dialect.getCreateIndexString(P2JIndex, boolean, boolean)
    
    Specified by:
    
    getSyntheticIndexSize in class Dialect
    
    Parameters:
    
    unique - true if the index is unique
    
    Returns:
    
    0 if index is unique, 8 = size of an pkid (bigint)
  - addRtrimmedExpression
```
public void addRtrimmedExpression(java.lang.String expr,
                                  java.lang.StringBuilder sb)
```
    Composes a rtrim equivalent call for a specified expression. This is dialect specific. The returned value looks like:
```
    rtrim(expr)
 
```
    The rtrimmed expression is appended to the string builder.
    Specified by:
    
    addRtrimmedExpression in class Dialect
    
    Parameters:
    
    expr - The expression to be rtrim -med. It's up to the caller if it is a qualified field or not or any other kind of character-type expression.
    
    sb - The StringBuilder to append the trimmed filed to.
  - getMaxParameterCount
```
public int getMaxParameterCount()
```
    Obtain the number of parameters a query of this dialect is allowed by the SQL server.
    
    Overrides:
    
    getMaxParameterCount in class Dialect
    
    Returns:
    
    always 0 because H2 does no have such limitation.
  - getCreateTemporaryTableString
```
public java.lang.String getCreateTemporaryTableString(boolean ifNotExist)
```
    Return the beginning of the DDL statement that creates a temporary table.
    
    Specified by:
    
    getCreateTemporaryTableString in class Dialect
    
    Parameters:
    
    ifNotExist - If true an dialect-specific, optional if not exist clause is added.
    
    Returns:
    
    A string representing the beginning of the DDL statement that creates a temporary table.
  - getCreateTemporaryTablePostfix
```
public java.lang.String getCreateTemporaryTablePostfix(boolean noUndo)
```
    Return the ending of the DDL statement that creates a temporary table.
    
    Specified by:
    
    getCreateTemporaryTablePostfix in class Dialect
    
    Parameters:
    
    noUndo - Parameter that indicates what keyword should be returned. The choices are "transactional" and "noundo".
    
    Returns:
    
    A string representing the ending of the DDL statement that creates a temporary table.
  - getDropIndexString
```
public java.lang.String getDropIndexString(boolean ifExists,
                                           java.lang.String idxName,
                                           java.lang.String tableName)
```
    Obtain a DDL statement which drops a SQL index.
    
    Specified by:
    
    getDropIndexString in class Dialect
    
    Parameters:
    
    ifExists - Flag that requires that the DDL include an optional IF EXIST clause.
    
    idxName - The name of the index to be dropped by this DDL.
    
    tableName - The name of the table to which the index belongs to. (Optional, is needed by the dialect).
    
    Returns:
    
    a DDL statement which drops a SQL index.
  - getDropTableString
```
public java.lang.String getDropTableString(boolean ifExists,
                                           java.lang.String tableName)
```
    Obtain a DDL statement which drops a SQL table.
    
    Specified by:
    
    getDropTableString in class Dialect
    
    Parameters:
    
    ifExists - Flag that requires that the DDL include an optional IF EXIST clause.
    
    tableName - The name of the table to be dropped by this DDL.
    
    Returns:
    
    a DDL statement which drops a SQL index.
  - getSpecificTypeAsString
```
public java.lang.String getSpecificTypeAsString(FqlType type)
```
    Converts and return the specified FqlType to a string representation which can be used in a SQL query (cast or other construct).
    
    Overrides:
    
    getSpecificTypeAsString in class Dialect
    
    Parameters:
    
    type - The type to be converted to string.
    
    Returns:
    
    A dialect specific string representation of the respective fql data type.
  - getSqlMappedType
```
public java.lang.String getSqlMappedType(java.lang.String fwdType,
                                         int scale,
                                         java.lang.Boolean caseSensitive)
```
    Get the SQL mapping for a specific FWD data type.
    
    Overrides:
    
    getSqlMappedType in class Dialect
    
    Parameters:
    
    fwdType - The FWD type.
    
    scale - Optional scale parameter (for decimal data type).
    
    Returns:
    
    The string representation of the SQL datatype mapped by fwdType.
  - getAnalyzeString
```
public java.lang.String getAnalyzeString(java.lang.String table)
```
    Construct and return a string which represents the analyze or similar statements for this dialect. If the table is not null the statement will analyze only the respective table. Otherwise, all the tables are analyzed.
    
    Specified by:
    
    getAnalyzeString in class Dialect
    
    Parameters:
    
    table - The name of the table to be analyzed. If null, all tables from the database will be analyzed, if possible.
    
    Returns:
    
    The analyze statement as requested. If the dialect does not support the analyze statement in the form requested null is returned.
  - orderByNulls
```
public int orderByNulls(java.lang.StringBuilder sb,
                        java.lang.String expression,
                        java.lang.String field,
                        boolean asc,
                        boolean forceAsc)
```
    Determine if the sort component or index needs to be augmented with a NULLS FIRST/LAST option and add the required expression.
    
    Overrides:
    
    orderByNulls in class Dialect
    
    Parameters:
    
    sb - The StringBuilder which contains the SQL statement to be built.
    
    expression - The field name (or expression) which is the current criterion to be augmented.
    
    field - The field name which is the base of the previous parameter (unused here).
    
    asc - The sort direction.
    
    forceAsc - If true, force the insertion of the default asc direction.
    
    Returns:
    
    1, representing the number of expressions which were added to the string builder.
  - scriptSplitter
```
public ScriptSplitter scriptSplitter()
```
    Get the splitter for DDL scripts.
    
    Specified by:
    
    scriptSplitter in class Dialect
    
    Returns:
    
    the splitter for DDL scripts
  - getScriptRunner
```
public ScriptRunner getScriptRunner()
```
    Get a ScriptRunner instance for the dialect.
    
    Specified by:
    
    getScriptRunner in class Dialect
    
    Returns:
    
    a ScriptRunner instance for the dialect.
  - blobCreator
```
public java.sql.Blob blobCreator(java.sql.Connection conn,
                                 byte[] bytes)
```
    Create a Blob instance from the specified bytes.
    
    Specified by:
    
    blobCreator in class Dialect
    
    Parameters:
    
    conn - The JDBC connection.
    
    bytes - The blob data.
    
    Returns:
    
    The blob instance.
  - clobCreator
```
public java.sql.Clob clobCreator(java.sql.Connection conn,
                                 java.lang.String value)
```
    Create a Clob instance from the specified value.
    
    Specified by:
    
    clobCreator in class Dialect
    
    Parameters:
    
    conn - The JDBC connection.
    
    value - The clob data.
    
    Returns:
    
    The clob instance.
  - useUdf4Contains
```
public boolean useUdf4Contains()
```
    Check if UDF should be used for converted CONTAINS operator
    
    Specified by:
    
    useUdf4Contains in class Dialect
    
    Returns:
    
    true if UDF should be used for converted CONTAINS operator.
  - useWordTables
```
public boolean useWordTables()
```
    Check if word tables should be used for converted CONTAINS operator
    
    Specified by:
    
    useWordTables in class Dialect
    
    Returns:
    
    true if tables should be used for converted CONTAINS operator
  - isNativeUDFsSupported
```
public boolean isNativeUDFsSupported()
```
    Check if native UDFs are supported for the dialect
    
    Specified by:
    
    isNativeUDFsSupported in class Dialect
    
    Returns:
    
    true if native UDFs are supported for the dialect
  - isUdfOriginatedError
```
public boolean isUdfOriginatedError(java.sql.SQLException e)
```
    Check if UDF should be used for converted CONTAINS operator
    
    Overrides:
    
    isUdfOriginatedError in class Dialect
    
    Parameters:
    
    e - the exception in question
    
    Returns:
    
    true if UDF should be used for converted CONTAINS operator
  - isUdfOriginatedWarning
```
public boolean isUdfOriginatedWarning(java.sql.SQLException e)
```
    Check if the exception was caused by a warning in UDF.
    
    Overrides:
    
    isUdfOriginatedWarning in class Dialect
    
    Parameters:
    
    e - the exception in question
    
    Returns:
    
    true if the exception was caused by error in UDF.
  - errorEntry
```
public ErrorManager.ErrorEntry errorEntry(java.lang.String message)
```
    Create the error descriptor from the SQLException message
    
    Overrides:
    
    errorEntry in class Dialect
    
    Parameters:
    
    message - SQLException message
    
    Returns:
    
    error descriptor.
  - useCTE4Contains
```
public boolean useCTE4Contains()
```
    Check if Common Table Expressions should be used for converted CONTAINS operator
    
    Overrides:
    
    useCTE4Contains in class Dialect
    
    Returns:
    
    true if Common Table Expressions should be used for converted CONTAINS operator
  - useMixedNode4Contains
```
public boolean useMixedNode4Contains()
```
    Check if mixed mode re-write should be used for converted CONTAINS operator
    
    Overrides:
    
    useMixedNode4Contains in class Dialect
    
    Returns:
    
    true if mixed mode re-write should be used
  - isUdfContains
```
public boolean isUdfContains(java.lang.String name)
```
    Check if the provided name is the name of the CONTAINS UDF
    
    Overrides:
    
    isUdfContains in class Dialect
    
    Parameters:
    
    name - name to be checked
    
    Returns:
    
    true if the provided name is the name of the CONTAINS UDF
  - containsUdfName
```
public java.lang.String containsUdfName()
```
    Return the name of the CONTAINS UDF
    
    Overrides:
    
    containsUdfName in class Dialect
    
    Returns:
    
    the name of the CONTAINS UDF
  - weightAggregator
```
public java.util.Optional<Dialect.WeightAggregator> weightAggregator()
```
    Get the WeightAggregator instance for the dialect if defined
    
    Overrides:
    
    weightAggregator in class Dialect
    
    Returns:
    
    the WeightAggregator instance for the dialect if defined
  - generateWordTablesDDLImpl
```
public void generateWordTablesDDLImpl(java.lang.String dbName,
                                      java.io.PrintStream out,
                                      java.lang.String eoln,
                                      java.util.Collection<WordTable> wordTables)
```
    Worker method for generateTriggerDDLs(). It generates the DDLs needed to create all triggers in a database with a specific schema and using a certain dialect.
    
    Specified by:
    
    generateWordTablesDDLImpl in class Dialect
    
    Parameters:
    
    dbName - The target schema.
    
    out - The PrintStream used for output.
    
    eoln - OS-specific end of line terminator.
    
    wordTables - word tables by name
  - supportsLazyQueryResultsMode
```
public boolean supportsLazyQueryResultsMode()
```
    Determine if this Dialect supports queries executed in a lazy manner.
    
    Overrides:
    
    supportsLazyQueryResultsMode in class Dialect
    
    Returns:
    
    true H2 does support lazy queries.
  - allowDBUniqueCheck
```
public boolean allowDBUniqueCheck()
```
    Determine if the Dialect supports index validation (with the VALIDATE keyword).
    
    Overrides:
    
    allowDBUniqueCheck in class Dialect
    
    Returns:
    
    true H2 supports this type of validation.
  - getCreateIndexString
```
public java.lang.String getCreateIndexString(boolean unique,
                                             boolean softUnique)
```
    Returns the beginning of the DDL statement for creating an index.
    
    Overrides:
    
    getCreateIndexString in class Dialect
    
    Parameters:
    
    unique - true for unique indexes.
    
    softUnique - true for soft-unique indexes.
    
    Returns:
    
    the beginning of the DDL statement for creating an index.
  - id
```
public java.lang.String id()
```
    Get dialect id.
    
    Specified by:
    
    id in class Dialect
    
    Returns:
    
    Dialect id.
  - isAutoRtrim
```
public boolean isAutoRtrim()
```
    Returns true if the dialect handles automatically rtrimming for character columns.
    
    Overrides:
    
    isAutoRtrim in class Dialect
    
    Returns:
    
    as described above.
  - useNullEquality
```
public boolean useNullEquality()
```
    Returns true if the dialect handles null equality. This is visible when doing null == null, which logically should return true, but not all dialects support this condition.
    
    Overrides:
    
    useNullEquality in class Dialect
    
    Returns:
    
    true if the dialect permits null equality.
  - isAutoCi
```
public boolean isAutoCi()
```
    Returns true if the dialect handles case-insensitive compare operations for case-insensitive character columns
    
    Overrides:
    
    isAutoCi in class Dialect
    
    Returns:
    
    as described above.
  - preparePermanentDatabase
```
public void preparePermanentDatabase(Database db)
                              throws PersistenceException
```
    Prepare the specified database by creating all necessary function aliases and setting global parameters.
    
    Overrides:
    
    preparePermanentDatabase in class Dialect
    
    Parameters:
    
    db - Database to prepare.
    
    Throws:
    
    PersistenceException - if there is any error executing DDL.
  - getSqlIndexName
```
public java.lang.String getSqlIndexName(P2JIndex index)
```
    Obtain the name of an index. This dialect overrides this method in order to make sure the name is unique among tables because in H2 the index names must be unique.
    
    Overrides:
    
    getSqlIndexName in class Dialect
    
    Parameters:
    
    index - The index structure.
    
    Returns:
    
    the unique SQL name of the index.
  - getAddForeignKeyConstraintString
```
public java.lang.String getAddForeignKeyConstraintString(java.lang.String table,
                                                         java.lang.String fkName,
                                                         java.lang.String fkFields,
                                                         java.lang.String refTable,
                                                         java.lang.String refFields,
                                                         java.lang.String indent,
                                                         java.lang.String eoln)
```
    Creates and returns a string which represent the alter table statement for adding a new foreign key constraint.
    
    Overrides:
    
    getAddForeignKeyConstraintString in class Dialect
    
    Parameters:
    
    table - The table to be altered.
    
    fkName - The name of the constraint.
    
    fkFields - Comma separated names of the fields which make the reference to parent table.
    
    refTable - The parent / referred table.
    
    refFields - Comma separated names of the fields which uniquely identify the record in parent table.
    
    indent - The indentation for pretty print the result.
    
    eoln - OS-specific end of line terminator (if the result is a multiline).
    
    Returns:
    
    A string used to create the foreign key constraint as described above.
  - allowSelectWildcard
```
public boolean allowSelectWildcard()
```
    Check if this dialect allows the selection of fields using * wildcard. Also, quantification should also be supported if this is allowed (alias.*).
    
    Overrides:
    
    allowSelectWildcard in class Dialect
    
    Returns:
    
    true if we can use * as selection wildcard.
  - getCodepage
```
public java.lang.String getCodepage(java.sql.Connection conn)
```
    Use the provided database connection to extract the codepage/CharSet used by the database and report it back to the caller.
    
    Overrides:
    
    getCodepage in class Dialect
    
    Parameters:
    
    conn - The JDBC database connection to be used.
    
    Returns:
    
    The name of the codepage/CharSet used by the database to store character data.
  - getCollation
```
public java.lang.String getCollation(java.sql.Connection conn)
```
    Use the provided database connection to extract the collation used by the database and report it back to the caller.
    
    Overrides:
    
    getCollation in class Dialect
    
    Parameters:
    
    conn - The JDBC database connection to be used.
    
    Returns:
    
    The name of the collation used by the database to store character data.
  - mapCP
```
private static java.lang.String mapCP(java.lang.String h2Charset)
```
    Maps the H2 specific charset names to 4GL codepage names.
    
    Parameters:
    
    h2Charset - A H2 specific charset name.
    
    Returns:
    
    The 4GL codepage name of h2Charset.

Class P2JH2Dialect

Nested Class Summary

Nested classes/interfaces inherited from class com.goldencode.p2j.persist.dialect.Dialect

Field Summary

Fields inherited from class com.goldencode.p2j.persist.dialect.Dialect

Constructor Summary

Method Summary

Methods inherited from class com.goldencode.p2j.persist.dialect.Dialect

Methods inherited from class java.lang.Object

Field Detail

LOG

PK

fwd2sql

WEIGHT_AGGREGATOR

UDF_ERROR_MESSAGE

AFTER_INSERT_TRIGGER

AFTER_UPDATE_TRIGGER

DROP_TRIGGER

Constructor Detail

P2JH2Dialect

Method Detail

getReservedKeywords

getDriverClassName

getJdbcDatabaseType

needsComputedColumns

supportsFunctionOverloading

supportsBooleanDatatype

createContext

postTransaction

formatDate

extractColumnName

getProcessedCharacterColumnName

isCaseInsensitiveColumn

getCreateSequenceString

getCreateSequenceString

getCreateSequenceString

getCreateSequenceString

getDropSequenceString

getSequenceSetValString

getSequenceSetValString

getSequenceSetValString

getSequenceCurrValString

getSequenceCurrValString

hasFullSequenceSupport

getSequencePrefetchString

getSequenceNextValString

isConnectionError

isQueryRangeParameterInlined

inlineLimit

requiresExplicitCastInsideTernary

allowBindParamsInRecursiveCTE

getDropIndexString

getInvisibleSpecificator

prepareMetadataParameter

processMetadataResult

isMetadataSortDesc

isMetadataSortAsc

getDatabasePrepareStatements

explicitSetCollation

getDelimiter

beforeDriverLoad

buildRemoteURL

createSequenceHandler

injectComputedColumns

isUniqueConstraintViolation

getIndexLengthLimit

getSyntheticIndexSize

addRtrimmedExpression

getMaxParameterCount

getCreateTemporaryTableString

getCreateTemporaryTablePostfix

getDropIndexString

getDropTableString

getSpecificTypeAsString

getSqlMappedType

getAnalyzeString

orderByNulls

scriptSplitter

getScriptRunner

blobCreator