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

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

Direct Known Subclasses:

P2JSQLServer2012Dialect
```
public class P2JSQLServer2008Dialect
extends Dialect
```
Extends Hibernate's SQLServer2008Dialect class to add method implementations required by the abstract Dialect base class.
Note: this implementation expects a directory to be available at the time the class is loaded.

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 java.util.Map<java.lang.String,java.lang.String>`	`fwd2sql` Mapping between the FWD possible field/column types and their SQL counterparts.
`private static java.sql.Date`	`highDate` Highest date supported by SQL Server 2008 (December 31, 9999) http://msdn.microsoft.com/en-US/library/ms187819%28v=sql.100%29.aspx
`(package private) static java.util.Map<java.lang.Class<? extends BaseDataType>,java.lang.Integer>`	`indexFieldSizes`
`private static ContextLocal<java.lang.Boolean>`	`inlineLimit` Flag indicating whether to inline a record limit in an SQL SELECT
`private static CentralLogger`	`LOG` Logger
`private static java.sql.Date`	`lowDate` `datetime` is deprecated and it does not align with the SQL Standard.
`private static int`	`MAX_INDEX_SIZE` The maximum size of all fields of an index, in bytes.
`private static int`	`MAX_LENGTH` Private constant from SQLServer2005Dialect used in sql types mapping with registerColumnType().
`private static int`	`MAX_PARAMETER_COUNT` The maximum number of parameters allowed by the SQL Server is a single query.

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

Constructor Summary

Constructors
Constructor and Description

P2JSQLServer2008Dialect()
Default constructor.

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

Method Summary

All 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.
`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.
`java.sql.Clob`	`clobCreator(java.sql.Connection conn, java.lang.String value)` Create a `Clob` instance from the specified value.
`int`	`computeIndexKeySize(java.lang.Class<? extends BaseDataType> type, java.lang.Object val)` Computes the size (in bytes) occupied by this value when stored as index-key in an index.
`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 SQL Server 2008 database.
`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`	`getAnalyzeString(java.lang.String table)` Construct and return a string which represents the `analyze` or similar statements for this dialect.
`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`	`getCreateIndexString(P2JIndex index, boolean unique, boolean toFile)` Build the DDL to create an index based upon the specified definition.
`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, 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.
`java.sql.Date`	`getHighDate()` Retrieve the latest possible date value which is valid for the backing database.
`int`	`getIndexLengthLimit()` MS SQL Server has constraints about the maximum size of fields that compose an index.
`java.lang.String`	`getJdbcDatabaseType()` Get the name of the JDBC database type (as in JBC URL).
`java.sql.Date`	`getLowDate()` Retrieve the earliest possible date value which is valid for the backing database.
`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.
`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`	`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.
`java.lang.String`	`initErrorFn()` Get name of the initError UDF.
`boolean`	`injectComputedColumns()` Report whether the computed columns should be injected on table creating.
`void`	`inlineLimit(boolean on)` Enable/disable limit clause inlining.
`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 an ascending clause for a column index.
`boolean`	`isMetadataSortDesc(java.lang.String value)` Check if the given value is a descending 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 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 (23000).
`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, (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`	`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
activateErrorHandler, allowBindParamsInRecursiveCTE, allowDBUniqueCheck, allowSelectWildcard, beforeDriverLoad, checkIndexConstraints, connectionCustomizer, containsUdfName, dialects, errorEntry, getAddForeignKeyConstraintString, getCatalogPattern, getCodepage, getCollation, getComputedColumnString, getCreateIndexString, getCreateIndexString, getCreateSequenceString, getCreateTableString, getDecimals, getDialect, getDialect, getDialect, getInvisibleSpecificator, getLimitString, getMaxEntriesInSelect, getSchemaPattern, getSequenceCurrValString, getSequenceSQL, getSpecificTypeAsString, getSqlIndexName, getSqlMappedType, isAutoCi, isAutoRtrim, isUdfContains, orderByNulls, postTransaction, preferDisjunctiveForm, quote, resetErrorHandler, resolveBooleanConstant, supportsLazyQueryResultsMode, supportsVariableLimit, translateToParmType, 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
  - LOG
```
private static final CentralLogger LOG
```
    Logger
  - inlineLimit
```
private static final ContextLocal<java.lang.Boolean> inlineLimit
```
    Flag indicating whether to inline a record limit in an SQL SELECT
  - lowDate
```
private static final java.sql.Date lowDate
```
    datetime is deprecated and it does not align with the SQL Standard. We convert p4gl date-related datatypes using the MSSQL date and datetime2. For both the lower limit is January 1, 001.
    date: msdn.microsoft.com/en-us/library/bb630352(v=sql.100).aspx
    datetime2: msdn.microsoft.com/en-us/library/bb677335(v=sql.100).aspx
  - highDate
```
private static final java.sql.Date highDate
```
    Highest date supported by SQL Server 2008 (December 31, 9999) http://msdn.microsoft.com/en-US/library/ms187819%28v=sql.100%29.aspx
  - MAX_LENGTH
```
private static final int MAX_LENGTH
```
    Private constant from SQLServer2005Dialect used in sql types mapping with registerColumnType(). We need to overwrite mapping to varchar/varbinary exactly with this constant.
    
    See Also:
    
    Constant Field Values
  - MAX_INDEX_SIZE
```
private static final int MAX_INDEX_SIZE
```
    The maximum size of all fields of an index, in bytes.
    
    See Also:
    
    Constant Field Values
  - MAX_PARAMETER_COUNT
```
private static final int MAX_PARAMETER_COUNT
```
    The maximum number of parameters allowed by the SQL Server is a single query.
    
    See Also:
    
    Constant Field Values
  - 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.
  - indexFieldSizes
```
static final java.util.Map<java.lang.Class<? extends BaseDataType>,java.lang.Integer> indexFieldSizes
```
- Constructor Detail
  - P2JSQLServer2008Dialect
```
public P2JSQLServer2008Dialect()
```
    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 and Types.VARBINARY.
- Method Detail
  - 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.
  - 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.
  - getLowDate
```
public java.sql.Date getLowDate()
```
    Retrieve the earliest possible date value which is valid for the backing database.
    
    Overrides:
    
    getLowDate in class Dialect
    
    Returns:
    
    Earliest date supported by the backing database.
  - getHighDate
```
public java.sql.Date getHighDate()
```
    Retrieve the latest possible date value which is valid for the backing database.
    
    Overrides:
    
    getHighDate in class Dialect
    
    Returns:
    
    Latest date supported by the backing database.
  - 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 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.
    
    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.
  - 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:
    
    true if name represents a computed column.
  - 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.
  - getComputedColumnPrefix
```
public java.lang.String getComputedColumnPrefix(boolean caseSensitive)
```
    Get the prefix, if any, which should be prepended to computed column and/or property names.
    
    Overrides:
    
    getComputedColumnPrefix in class Dialect
    
    Parameters:
    
    caseSensitive - true if this is a character field was declared with CASE-SENSITIVE attribute.
    
    Returns:
    
    null to indicate the backing database does not use computed columns.
    
    See Also:
    
    needsComputedColumns()
  - 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 because Server 2008 does not support functions overloading ("Function names ... must be unique within the database and to its schema.")
  - 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.
    Since SQL Server uses BIT (integer datatype with 0 and 1 values) as boolean replacement, this method always returns false.
    Specified by:
    
    supportsBooleanDatatype in class Dialect
    
    Returns:
    
    Always false.
  - 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 because Server 2008 does not have the concept of a SEQUENCE. It appeared since SQL Server 2012.
  - 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.
  - isConnectionError
```
public boolean isConnectionError(java.lang.Exception exc)
```
    Given an exception, this method will check if it indicates a database connectivity error.
    For the SQLServer dialect, 08S01 - common state for disconnect and cancel.
    
    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.
    
    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:
    
    always true for SQL Server dialects.
  - 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.
  - getCreateIndexString
```
public java.lang.String getCreateIndexString(P2JIndex index,
                                             boolean unique,
                                             boolean toFile)
```
    Build the DDL to create an index based upon the specified definition. The SQL is generated by using a database-specific dialect.
    
    Overrides:
    
    getCreateIndexString in class Dialect
    
    Parameters:
    
    index - Definition of the index to be created.
    
    unique - If true, create the index as a unique index, false to omit the unique constraint.
    
    toFile - true if the string will be output to a file or false if it will be directly submitted via JDBC.
    
    Returns:
    
    The DDL which was created.
  - getComputedColumnFormula
```
public java.lang.String getComputedColumnFormula(java.lang.String colName,
                                                 boolean ignoreCase)
```
    Returns the formula for character computed columns. This will be called in two cases: when generating the ddl for permanent databases schema (this will be written to a .sql file) and when creating temp-tables (the code will be sent directly to SQL).
    
    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 formula for computed columns or null if the dialect does not support computed columns.
  - 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, (by making it lowercase ?).
    
    Specified by:
    
    processMetadataResult in class Dialect
    
    Parameters:
    
    value - The metadata query result.
    
    Returns:
    
    the result.
  - isMetadataSortDesc
```
public boolean isMetadataSortDesc(java.lang.String value)
```
    Check if the given value is a descending 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 ascending 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:
    
    an empty 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.
  - 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.
  - 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:
    
    Returning null since this dialect does not support sequences.
  - 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:
    
    Returning null since this dialect does not support sequences.
  - 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.
    
    maxVal - Sequence maximum value. Optional.
    
    cycle - Sequence cycling property. Optional, if missing assumed not cycling.
    
    Returns:
    
    Returning null since this dialect does not support sequences.
  - 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:
    
    Returning null since this dialect does not support sequences.
  - 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:
    
    Returning null since this dialect does not support sequences.
  - 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:
    
    Returning null since this dialect does not support sequences.
  - 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:
    
    Returning null since this dialect does not support sequences.
  - 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:
    
    Returning null since this dialect does not support sequences.
  - 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:
    
    Returning null since this dialect does not support sequences.
  - createSequenceHandler
```
public SequenceHandler createSequenceHandler(java.lang.String ldbName)
```
    Creates and returns a SequenceHandler for a SQL Server 2008 database.
    
    Specified by:
    
    createSequenceHandler in class Dialect
    
    Parameters:
    
    ldbName - The logical name of the database to create the SequenceHandler for.
    
    Returns:
    
    Returning null since this dialect does not support sequences. It is appeared since SQL Server 2012.
  - injectComputedColumns
```
public boolean injectComputedColumns()
```
    Report whether the computed columns should be injected on table creating.
    
    Specified by:
    
    injectComputedColumns in class Dialect
    
    Returns:
    
    always true for SQL Server.
  - isUniqueConstraintViolation
```
public boolean isUniqueConstraintViolation(java.sql.SQLException sqle)
```
    Checks if the SQLState of the SQLException matches the dialect specific UNIQUE_VIOLATION code (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.
  - getIndexLengthLimit
```
public int getIndexLengthLimit()
```
    MS SQL Server has constraints about the maximum size of fields that compose an index. All combined fields of any index must not exceed 900 bytes.
    
    Overrides:
    
    getIndexLengthLimit in class Dialect
    
    Returns:
    
    always 900.
  - computeIndexKeySize
```
public int computeIndexKeySize(java.lang.Class<? extends BaseDataType> type,
                               java.lang.Object val)
```
    Computes the size (in bytes) occupied by this value when stored as index-key in an index. It only make sense to call this method if the getIndexLengthLimit() returns positive values. If this dialect does not have index-size constraints then this method should return 0.
    
    Overrides:
    
    computeIndexKeySize in class Dialect
    
    Parameters:
    
    type - The type to be analyzed.
    
    val - The actual value. Except for the char datatype, only the type of value is used, the actual value is not needed to determine the size occupied by the value as index-key.
    
    Returns:
    
    the size (in bytes) occupied by this value when stored as index-key in 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 getCreateIndexString(P2JIndex, boolean, boolean)
    
    Specified by:
    
    getSyntheticIndexSize in class Dialect
    
    Parameters:
    
    unique - true if the index is unique, unused.
    
    Returns:
    
    Always 8 because the workaround of the multiple NULLS in UNIQUE indexes described in getCreateIndexString().
  - 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 name 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. For 2008 and 2012 the maximum number of parameters is 2100. If the query need more parameter it have to be rewritten or split and the result reassembled in memory.
    
    Overrides:
    
    getMaxParameterCount in class Dialect
    
    Returns:
    
    always 2100.
  - 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 - 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:
    
    An empty string. This dialect does not support this feature.
  - 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.
  - 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.
  - 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
  - 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 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.
  - 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.
  - 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
  - id
```
public java.lang.String id()
```
    Get dialect id.
    
    Specified by:
    
    id in class Dialect
    
    Returns:
    
    Dialect id
  - preparePermanentDatabase
```
public void preparePermanentDatabase(Database db)
```
    Prepare the specified database by creating all necessary function aliases and setting global parameters.
    
    Overrides:
    
    preparePermanentDatabase in class Dialect
    
    Parameters:
    
    db - Database to prepare.

Class P2JSQLServer2008Dialect

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

inlineLimit

lowDate

highDate

MAX_LENGTH

MAX_INDEX_SIZE

MAX_PARAMETER_COUNT

fwd2sql

indexFieldSizes

Constructor Detail

P2JSQLServer2008Dialect

Method Detail

getDriverClassName

getJdbcDatabaseType

createContext

getLowDate

getHighDate

formatDate

extractColumnName

getProcessedCharacterColumnName

isCaseInsensitiveColumn

isComputedColumn

needsComputedColumns

getComputedColumnPrefix

supportsFunctionOverloading

supportsBooleanDatatype

hasFullSequenceSupport

getSequencePrefetchString

isConnectionError

isQueryRangeParameterInlined

inlineLimit

requiresExplicitCastInsideTernary

getDropIndexString

getCreateIndexString

getComputedColumnFormula

prepareMetadataParameter

processMetadataResult

isMetadataSortDesc

isMetadataSortAsc

getDatabasePrepareStatements

explicitSetCollation

getDelimiter

buildRemoteURL

getCreateSequenceString

getCreateSequenceString

getCreateSequenceString

getDropSequenceString

getSequenceSetValString

getSequenceSetValString

getSequenceSetValString

getSequenceNextValString

getSequenceCurrValString

createSequenceHandler

injectComputedColumns

isUniqueConstraintViolation

getIndexLengthLimit

computeIndexKeySize

getSyntheticIndexSize

addRtrimmedExpression

getMaxParameterCount

getCreateTemporaryTableString

getCreateTemporaryTablePostfix

getDropIndexString

getDropTableString

getSqlMappedType

getAnalyzeString

scriptSplitter

getScriptRunner

blobCreator

clobCreator