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

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

Direct Known Subclasses:

MariaDbDialect
```
public class MariaDbLenientDialect
extends Dialect
```
Extends abstract Dialect for an MariaDb/MySql backend. This is a lenient implementation and not all 4GL features are supported. The customer which uses this is responsible for any unexpected results of processing his data in lenient (non-strict) mode.

Nested Class Summary
- Nested classes/interfaces inherited from class com.goldencode.p2j.persist.dialect.Dialect
  Dialect.WeightAggregator

Field Summary

Fields
Modifier and Type	Field and Description
`private static int`	`BPC` The number of bytes per character in the used text encoding (assuming utf8mb4 / utf32) used when computing the space requirements.
`static java.lang.String`	`DIALECT_ID` The id of this dialect variant as a string.
`protected static java.util.Map<java.lang.String,java.lang.String>`	`fwd2sql` Mapping between the FWD possible field/column types and their SQL counterparts.
`protected static java.sql.Date`	`highDate` Highest date supported by MariaDb (?)
`private static int`	`INDEX_MAX_KEY_SIZE` The maximum key size in a MariaDb index.
`private static boolean`	`inlineRangeParms` Flag indicating whether range parameters should be inlined
`private static CentralLogger`	`LOG` Logger
`protected static java.sql.Date`	`lowDate` Lowest date supported by MariaDb (?)
`protected static int`	`MAX_VARCHAR_SIZE` The maximum size of a character / VARCHAR field in MariaDb.
`protected static int`	`MIN_TEXT_SIZE` The limit at which VARCHAR columns are converted to TEXT columns in MariaDb.
`protected static java.util.regex.Pattern`	`UDF_ERROR_MESSAGE` Regex Pattern for parsing message cased by error raised by UDF.
`private static boolean`	`udf4contains`

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

Constructor Summary

Constructors
Constructor and Description

MariaDbLenientDialect()

Constructors
Constructor and Description
`MariaDbLenientDialect()`

Method Summary

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`void`	`activateErrorHandler(java.sql.Connection conn)` Activate error handler at the database side.
`void`	`addRtrimmedExpression(java.lang.String expr, java.lang.StringBuilder sb)` Composes a `rtrim` equivalent call for a specified expression.
`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.lang.String`	`checkErrorFn()` Get name of the checkError UDF.
`void`	`checkIndexConstraints(P2JIndex p2JIndex, java.util.Map<java.lang.String,P2JField> fields)` This dialect has a constraints of 3KiB on the index key size.
`java.sql.Clob`	`clobCreator(java.sql.Connection conn, java.lang.String value)` Create a `Clob` instance from the specified value.
`java.lang.Class<? extends com.mchange.v2.c3p0.AbstractConnectionCustomizer>`	`connectionCustomizer(DatabaseConfig cfg)` Get c3p0 ConnectionCustomizer class for the dialect.
`SequenceHandler`	`createSequenceHandler(java.lang.String ldbName)` Creates and returns a `SequenceHandler` for a 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 column expression 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`	`getCatalogPattern(Database database)` Provides catalog matching pattern to load data correctly from JDBC.
`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`	`getComputedColumnFormula(java.lang.String colName, boolean ignoreCase)` Returns the formula for character computed columns.
`java.lang.String`	`getComputedColumnPrefix(boolean caseSensitive)` Get the prefix, if any, which should be prepended to computed column and/or property names.
`java.lang.String`	`getCreateSequenceString(java.lang.String name)` Generate a DDL string which will create a global sequence with the given starting value.
`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.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.
`java.lang.String`	`getJdbcDatabaseType()` Get the name of the JDBC database type (as in JBC URL).
`protected CentralLogger`	`getLog()` Get the logger specific to this MariaDb dialect variant.
`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.
`java.lang.String`	`getSchemaPattern(Database database)` Provides schema matching pattern to load data correctly from JDBC.
`ScriptRunner`	`getScriptRunner()` Get a ScriptRunner instance for the dialect.
`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`	`getSequenceSQL(Database database)` Provides SQL to load sequences.
`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`	`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.
`java.util.regex.Pattern`	`getUdfErrorMessagePattern()` Get regex Pattern for parsing message cased by error raised by UDF.
`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.
`java.lang.String`	`initErrorFn()` Get name of the initError UDF.
`boolean`	`injectComputedColumns()` This MariaDb dialect variant does NOT honour the "nulls last" feature of 4GL.
`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`	`isComputedColumn(java.lang.String name)` Report whether the given column name represents an alias or an expression which indicates the column is computed.
`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 a descending clause for a column index.
`boolean`	`isMetadataSortDesc(java.lang.String value)` Check if the given value is an ascending 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`	`isUdfOriginatedError(java.sql.SQLException e)` Check if the exception was caused by an error in UDF.
`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 MariaDB (23000).
`private static java.lang.String`	`mapCollation(java.lang.String collation)` Maps the MariaDb specific collation names to 4GL collation names.
`private static java.lang.String`	`mapCP(java.lang.String collation)` Maps/extract from the MariaDb 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.
`java.lang.String`	`prepareMetadataParameter(java.lang.String param)` Prepare the given metadata query parameter.
`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.
`boolean`	`requiresExplicitCastInsideTernary()` Determines whether substitution parameters should be explicitly cast to their datatypes inside `"then ? else ?"` statement.
`void`	`resetErrorHandler(java.sql.Connection conn)` Reset error handler at the database side.
`ScriptSplitter`	`scriptSplitter()` Get a new instance of a 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.
`ParmType`	`translateToParmType(java.lang.String type, java.lang.String comment)` Translation from database column type to `ParmType`.
`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.

Methods inherited from class com.goldencode.p2j.persist.dialect.Dialect
allowBindParamsInRecursiveCTE, allowDBUniqueCheck, allowSelectWildcard, beforeDriverLoad, computeIndexKeySize, containsUdfName, createContext, dialects, getComputedColumnString, getCreateIndexString, getCreateIndexString, getCreateIndexString, getCreateSequenceString, getCreateTableString, getDatabasePrepareStatements, getDecimals, getDialect, getDialect, getDialect, getHighDate, getIndexLengthLimit, getInvisibleSpecificator, getLimitString, getLowDate, getMaxEntriesInSelect, getMaxParameterCount, getSequenceCurrValString, getSqlIndexName, getSqlMappedType, isUdfContains, orderByNulls, postTransaction, preferDisjunctiveForm, quote, resolveBooleanConstant, supportsLazyQueryResultsMode, supportsVariableLimit, udfSchema, useCTE4Contains, useMixedNode4Contains, useNullEquality, weightAggregator

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

- Field Detail
  - DIALECT_ID
```
public static final java.lang.String DIALECT_ID
```
    The id of this dialect variant as a string.
    
    See Also:
    
    Constant Field Values
  - MAX_VARCHAR_SIZE
```
protected static final int MAX_VARCHAR_SIZE
```
    The maximum size of a character / VARCHAR field in MariaDb.
    
    See Also:
    
    Constant Field Values
  - MIN_TEXT_SIZE
```
protected static final int MIN_TEXT_SIZE
```
    The limit at which VARCHAR columns are converted to TEXT columns in MariaDb.
    
    See Also:
    
    Constant Field Values
  - INDEX_MAX_KEY_SIZE
```
private static final int INDEX_MAX_KEY_SIZE
```
    The maximum key size in a MariaDb index.
    
    See Also:
    
    Constant Field Values
  - BPC
```
private static final int BPC
```
    The number of bytes per character in the used text encoding (assuming utf8mb4 / utf32) used when computing the space requirements.
    
    See Also:
    
    Constant Field Values
  - UDF_ERROR_MESSAGE
```
protected static final java.util.regex.Pattern UDF_ERROR_MESSAGE
```
    Regex Pattern for parsing message cased by error raised by UDF.
  - lowDate
```
protected static final java.sql.Date lowDate
```
    Lowest date supported by MariaDb (?)
  - highDate
```
protected static final java.sql.Date highDate
```
    Highest date supported by MariaDb (?)
  - fwd2sql
```
protected static final java.util.Map<java.lang.String,java.lang.String> fwd2sql
```
    Mapping between the FWD possible field/column types and their SQL counterparts.
  - LOG
```
private static final CentralLogger LOG
```
    Logger
  - inlineRangeParms
```
private static boolean inlineRangeParms
```
    Flag indicating whether range parameters should be inlined
  - udf4contains
```
private static boolean udf4contains
```
- Constructor Detail
  - MariaDbLenientDialect
```
public MariaDbLenientDialect()
```
- 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 MariaDb reserved keywords.
    
    See Also:
    
    https://msdn.microsoft.com/en-us/library/ms189822%28v=sql.110%29.aspx
  - id
```
public java.lang.String id()
```
    Get dialect id.
    
    Specified by:
    
    id in class Dialect
    
    Returns:
    
    the id of the dialect.
  - 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.
  - 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:
    
    The fully qualified driver class name.
    
    See Also:
    
    Download MariaDB Connector/J
  - connectionCustomizer
```
public java.lang.Class<? extends com.mchange.v2.c3p0.AbstractConnectionCustomizer> connectionCustomizer(DatabaseConfig cfg)
```
    Get c3p0 ConnectionCustomizer class for the dialect.
    
    Overrides:
    
    connectionCustomizer in class Dialect
    
    Parameters:
    
    cfg - Database configuration.
    
    Returns:
    
    c3p0 ConnectionCustomizer class for the dialect.
  - activateErrorHandler
```
public void activateErrorHandler(java.sql.Connection conn)
                          throws java.sql.SQLException
```
    Activate error handler at the database side.
    
    Overrides:
    
    activateErrorHandler in class Dialect
    
    Parameters:
    
    conn - Database connection
    
    Throws:
    
    java.sql.SQLException - on error.
  - resetErrorHandler
```
public void resetErrorHandler(java.sql.Connection conn)
                       throws java.sql.SQLException
```
    Reset error handler at the database side.
    
    Overrides:
    
    resetErrorHandler in class Dialect
    
    Parameters:
    
    conn - Database connection
    
    Throws:
    
    java.sql.SQLException - on error.
  - scriptSplitter
```
public ScriptSplitter scriptSplitter()
```
    Get a new instance of a splitter for DDL scripts. Reuses the splitter for PG dialect.
    
    Specified by:
    
    scriptSplitter in class Dialect
    
    Returns:
    
    A new instance of 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 since we want tho TEST this NEW feature.
  - checkErrorFn
```
public java.lang.String checkErrorFn()
```
    Get name of the checkError UDF.
    
    Overrides:
    
    checkErrorFn in class Dialect
    
    Returns:
    
    the name of the checkError UDF.
  - initErrorFn
```
public java.lang.String initErrorFn()
```
    Get name of the initError UDF.
    
    Overrides:
    
    initErrorFn in class Dialect
    
    Returns:
    
    the name of the initError UDF.
  - isUdfOriginatedError
```
public boolean isUdfOriginatedError(java.sql.SQLException e)
```
    Check if the exception was caused by an error in UDF.
    
    Overrides:
    
    isUdfOriginatedError in class Dialect
    
    Parameters:
    
    e - The exception in question.
    
    Returns:
    
    true if the exception was caused by error in UDF.
  - getUdfErrorMessagePattern
```
public java.util.regex.Pattern getUdfErrorMessagePattern()
```
    Get regex Pattern for parsing message cased by error raised by UDF.
    
    Returns:
    
    regex Pattern for parsing message cased by error raised by UDF.
  - 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.
  - 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 - The collection of word tables, ordered by name.
  - formatDate
```
public java.lang.String formatDate(date d)
```
    Format a date object as a string which is appropriate for use in an SQL statement. The preferred format is YYYY-MM-DD.
    
    Specified by:
    
    formatDate in class Dialect
    
    Parameters:
    
    d - Date to be formatted as a string.
    
    Returns:
    
    Formatted representation of the given date.
    
    See Also:
    
    DATE Syntax
  - extractColumnName
```
public java.lang.String extractColumnName(java.lang.String expr)
```
    Given a column expression as queried from database metadata, extract the root name of a column.
    Since the VARCHAR(n) datatype does not require the column to be processed in any way before being added to an index, this method returns the parameter unchanged.
    
    Specified by:
    
    extractColumnName in class Dialect
    
    Parameters:
    
    expr - Expression containing column name as natively represented by the database dialect.
    
    Returns:
    
    Basic 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 may involve wrapping it within one or more functions, prepending a special prefix to designate a computed column, or any other transformation appropriate to the database syntax. TODO: the case-sensitive fields might present the "binary" prefix.
    
    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. Assumes 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.
  - 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; false if the backing database can embed an expression within an index definition.
  - isAutoRtrim
```
public boolean isAutoRtrim()
```
    Returns true if the dialect handles automatically rtrimming for character columns.
    
    Overrides:
    
    isAutoRtrim in class Dialect
    
    Returns:
    
    as described above.
  - 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.
  - getComputedColumnPrefix
```
public java.lang.String getComputedColumnPrefix(boolean caseSensitive)
```
    Get the prefix, if any, which should be prepended to computed column and/or property names. In the case of this dialect the SQL server handles automatically the case-insensitive strings the same way as 4GL. The computed column is a NO-OP.
    
    Overrides:
    
    getComputedColumnPrefix in class Dialect
    
    Parameters:
    
    caseSensitive - true if this is a character field was declared with CASE-SENSITIVE attribute. In each case the column name will be name-decorated differently.
    
    Returns:
    
    Computed column/property prefix, or null if the backing database does not use computed columns.
    
    See Also:
    
    needsComputedColumns()
  - getComputedColumnFormula
```
public java.lang.String getComputedColumnFormula(java.lang.String colName,
                                                 boolean ignoreCase)
```
    Returns the formula for character computed columns. In the case of this dialect the SQL server handles automatically the case-insensitive strings the same way as 4GL. The computed column is a NO-OP. The case-sensitive cases must be handled, later, on a fully qualified column, by adding binary token.
    
    Overrides:
    
    getComputedColumnFormula in class Dialect
    
    Parameters:
    
    colName - The base column name.
    
    ignoreCase - true if this is a char field which has the "ignore case" flag set.
    
    Returns:
    
    The column name.
  - isComputedColumn
```
public boolean isComputedColumn(java.lang.String name)
```
    Report whether the given column name represents an alias or an expression which indicates the column is computed. Assume the column represented by name is already determined to be the appropriate data type for textual data.
    
    Overrides:
    
    isComputedColumn in class Dialect
    
    Parameters:
    
    name - Column name, alias, or expression.
    
    Returns:
    
    always false.
  - supportsFunctionOverloading
```
public boolean supportsFunctionOverloading()
```
    Indicate whether this dialect natively supports the overloading of user defined functions by parameter number and data type. If not, the overloaded UDFs must be decorated in some way.
    
    Specified by:
    
    supportsFunctionOverloading in class Dialect
    
    Returns:
    
    false since the backing database does not support overloading natively.
  - 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:
    
    true if the above-mentioned items are supported or false if they are handled by a replacement datatype (integer).
    
    See Also:
    
    BOOLEAN Syntax
  - getCreateSequenceString
```
public java.lang.String getCreateSequenceString(java.lang.String name)
```
    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.
    
    Returns:
    
    Dialect-specific string to create the sequence, or null if not supported.
    
    See Also:
    
    CREATE SEQUENCE Syntax
  - 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.
    
    See Also:
    
    CREATE SEQUENCE Syntax
  - 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.
    
    See Also:
    
    CREATE SEQUENCE Syntax
  - 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.
    
    See Also:
    
    DROP SEQUENCE Syntax
  - 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 set the current value of the sequence, or null if not supported.
    
    See Also:
    
    SETVAL() Function
  - 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 set the current value of the sequence, or null if not supported.
    
    See Also:
    
    SETVAL() Function
  - 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 set the current value of the sequence, or null if not supported.
    
    See Also:
    
    SETVAL() Function
  - 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.
    
    See Also:
    
    NEXT VALUE for sequence_name
  - 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.
    
    See Also:
    
    PREVIOUS VALUE for sequence_name
  - 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:
    
    true if this dialect 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:
    
    At the moment MariaDb does not support prefetch for sequences. Returning null.
    
    See Also:
    
    SEQUENCE Functions
  - isConnectionError
```
public boolean isConnectionError(java.lang.Exception exc)
```
    Given an exception, this method will check if it indicates a database connectivity error.
    
    Specified by:
    
    isConnectionError in class Dialect
    
    Parameters:
    
    exc - The exception to be checked.
    
    Returns:
    
    true if the exception indicates a database connectivity error.
    
    See Also:
    
    MariaDB Error Codes
  - 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.
    
    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 cast to their datatypes inside "then ? else ?" statement.
    
    Specified by:
    
    requiresExplicitCastInsideTernary in class Dialect
    
    Returns:
    
    true: this dialect requires casting in this case.
  - 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.
    
    See Also:
    
    DROP INDEX Syntax
  - prepareMetadataParameter
```
public java.lang.String prepareMetadataParameter(java.lang.String param)
```
    Prepare the given metadata query parameter.
    
    Specified by:
    
    prepareMetadataParameter in class Dialect
    
    Parameters:
    
    param - The metadata query parameter.
    
    Returns:
    
    the prepared parameter.
  - processMetadataResult
```
public java.lang.String processMetadataResult(java.lang.String value)
```
    Process the given metadata query result.
    
    Specified by:
    
    processMetadataResult in class Dialect
    
    Parameters:
    
    value - The metadata query result.
    
    Returns:
    
    the processed result.
  - isMetadataSortDesc
```
public boolean isMetadataSortDesc(java.lang.String value)
```
    Check if the given value is an ascending 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 "ascending" clause.
  - isMetadataSortAsc
```
public boolean isMetadataSortAsc(java.lang.String value)
```
    Check if the given value is a descending 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 "descending" clause.
  - 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:
    
    true if the collation needs to be explicitly set.
  - getDelimiter
```
public java.lang.String getDelimiter()
```
    Get the statement delimiter for this dialect.
    
    Specified by:
    
    getDelimiter in class Dialect
    
    Returns:
    
    the statement delimiter.
  - 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.
    
    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 database.
    
    Specified by:
    
    createSequenceHandler in class Dialect
    
    Parameters:
    
    ldbName - The logical name of the database to create the SequenceHandler for.
    
    Returns:
    
    A SequenceHandler for respective database.
  - injectComputedColumns
```
public boolean injectComputedColumns()
```
    This MariaDb dialect variant does NOT honour the "nulls last" feature of 4GL.
    
    Specified by:
    
    injectComputedColumns in class Dialect
    
    Returns:
    
    false.
  - isUniqueConstraintViolation
```
public boolean isUniqueConstraintViolation(java.sql.SQLException sqle)
```
    Checks if the SQLState of the SQLException matches the dialect specific UNIQUE_VIOLATION code for MariaDB (23000).
    
    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.
  - 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.
    
    Specified by:
    
    getSyntheticIndexSize in class Dialect
    
    Parameters:
    
    unique - true if the index is unique
    
    Returns:
    
    The size of synthetic part of the index, in bytes.
  - 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. Usually the returned value looks like:
```
    rtrim(expr)
 
```
    The rtrim-med expression is appended to the string builder. The return value (the number of occurrences of the initial expr added to sb) should be use by caller to count the number of possible parameters from a query.
    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 field to.
  - 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 a dialect-specific, optional if not exist clause is added.
    
    Returns:
    
    A string representing the beginning of the DDL statement that creates a temporary table.
    
    See Also:
    
    CREATE TABLE Syntax
  - 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 - This parameter is not used at the moment. The intention was to generate a keyword for no-undo tables. Only P2JH2Dialect benefits from this parameter.
    
    Returns:
    
    A string representing the ending of the DDL statement that creates a temporary table, if any, or empty string otherwise.
    
    See Also:
    
    CREATE TABLE TRANSACTIONAL
  - 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.
  - getCatalogPattern
```
public java.lang.String getCatalogPattern(Database database)
```
    Provides catalog matching pattern to load data correctly from JDBC.
    
    Overrides:
    
    getCatalogPattern in class Dialect
    
    Parameters:
    
    database - database object
    
    Returns:
    
    catalog pattern
  - getSchemaPattern
```
public java.lang.String getSchemaPattern(Database database)
```
    Provides schema matching pattern to load data correctly from JDBC.
    
    Overrides:
    
    getSchemaPattern in class Dialect
    
    Parameters:
    
    database - database object
    
    Returns:
    
    schema pattern
  - getSequenceSQL
```
public java.lang.String getSequenceSQL(Database database)
```
    Provides SQL to load sequences.
    
    Overrides:
    
    getSequenceSQL in class Dialect
    
    Parameters:
    
    database - database object
    
    Returns:
    
    sequence SQL
  - 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.
    
    See Also:
    
    DROP INDEX Syntax
  - 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.
    
    See Also:
    
    DROP TABLE Syntax
  - 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.
    
    See Also:
    
    ANALYZE TABLE Syntax
  - 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.
  - translateToParmType
```
public ParmType translateToParmType(java.lang.String type,
                                    java.lang.String comment)
```
    Translation from database column type to ParmType.
    
    Overrides:
    
    translateToParmType in class Dialect
    
    Parameters:
    
    type - Column type.
    
    comment - comment with optional specification of type
    
    Returns:
    
    ParmType
    
    Throws:
    
    java.lang.IllegalArgumentException - for unsupported types.
  - 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.
  - checkIndexConstraints
```
public void checkIndexConstraints(P2JIndex p2JIndex,
                                  java.util.Map<java.lang.String,P2JField> fields)
```
    This dialect has a constraints of 3KiB on the index key size. This method does a heuristic calculation and report a possible error/warning when the database schema is set.
    
    Overrides:
    
    checkIndexConstraints in class Dialect
    
    Parameters:
    
    p2JIndex - The index to be processed.
    
    fields - All table fields, mapped by their legacy name.
    
    See Also:
    
    Data Type Requirements
  - 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.
  - 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.
  - getLog
```
protected CentralLogger getLog()
```
    Get the logger specific to this MariaDb dialect variant.
    
    Returns:
    
    the logger specific to this MariaDb dialect variant.
  - mapCP
```
private static java.lang.String mapCP(java.lang.String collation)
```
    Maps/extract from the MariaDb specific charset names to 4GL codepage names.
    
    Parameters:
    
    collation - A MariaDb specific collation name. (Ex: "latin1_swedish_ci", "cp1250_polish_ci")
    
    Returns:
    
    The 4GL codepage name of h2Charset.
  - mapCollation
```
private static java.lang.String mapCollation(java.lang.String collation)
```
    Maps the MariaDb specific collation names to 4GL collation names.
    
    Parameters:
    
    collation - A MariaDb specific collation name. (Ex: "latin1_swedish_ci", "cp1250_polish_ci")
    
    Returns:
    
    The 4GL codepage name of h2Charset.

Class MariaDbLenientDialect

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

DIALECT_ID

MAX_VARCHAR_SIZE

MIN_TEXT_SIZE

INDEX_MAX_KEY_SIZE

BPC

UDF_ERROR_MESSAGE

lowDate

highDate

fwd2sql

LOG

inlineRangeParms

udf4contains

Constructor Detail

MariaDbLenientDialect

Method Detail

getReservedKeywords

id

getJdbcDatabaseType

getDriverClassName

connectionCustomizer

activateErrorHandler

resetErrorHandler

scriptSplitter

getScriptRunner

blobCreator

clobCreator

useUdf4Contains

useWordTables

isNativeUDFsSupported

checkErrorFn

initErrorFn

isUdfOriginatedError

getUdfErrorMessagePattern

isUdfOriginatedWarning

errorEntry

generateWordTablesDDLImpl

formatDate

extractColumnName

getProcessedCharacterColumnName

isCaseInsensitiveColumn

needsComputedColumns

isAutoRtrim

isAutoCi

getComputedColumnPrefix

getComputedColumnFormula

isComputedColumn

supportsFunctionOverloading

supportsBooleanDatatype

getCreateSequenceString

getCreateSequenceString

getCreateSequenceString

getDropSequenceString

getSequenceSetValString

getSequenceSetValString

getSequenceSetValString

getSequenceNextValString

getSequenceCurrValString

hasFullSequenceSupport

getSequencePrefetchString

isConnectionError

isQueryRangeParameterInlined

inlineLimit

requiresExplicitCastInsideTernary

getDropIndexString

prepareMetadataParameter

processMetadataResult

isMetadataSortDesc

isMetadataSortAsc

explicitSetCollation

getDelimiter