com.goldencode.p2j.persist.dialect

Class P2JSQLServer2012Dialect

java.lang.Object

com.goldencode.p2j.persist.dialect.Dialect

com.goldencode.p2j.persist.dialect.P2JSQLServer2008Dialect

com.goldencode.p2j.persist.dialect.P2JSQLServer2012Dialect

public class P2JSQLServer2012Dialect
extends P2JSQLServer2008Dialect

Extends P2JSQLServer2008Dialect to add method implementations supported with SQL Server 2012.

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 inherited from class com.goldencode.p2j.persist.dialect.P2JSQLServer2008Dialect

indexFieldSizes

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

CASE_TYPE_TOK, DEFAULT_MAX_WIDTH, SCALE_TOK

Constructor Summary

Constructors

Constructor and Description
P2JSQLServer2012Dialect()

Method Summary

Modifier and Type	Method and Description
void	applySqlLimit(int limit, java.lang.StringBuilder buf, int selectStartPos) Given a string builder containing an SQL SELECT statement, a limit to apply, and the position in the builder at which the SELECT statement begins, augment the SQL statement to apply the given limit.
SequenceHandler	createSequenceHandler(java.lang.String ldbName) Creates and returns a SequenceHandler for a SQL Server 2012 database.
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	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	getDropSequenceString(java.lang.String name) Generate a DDL string which will drop a sequence with given properties.
static java.util.List<java.lang.String>	getReservedKeywords() Get a collection of reserved keywords specific to this dialect.
java.lang.String	getSequenceCurrValString() Generate the appropriate select statement to retrieve the current value of a sequence.
java.lang.String	getSequenceCurrValString(java.lang.String sequenceName) Generate the appropriate select statement to retrieve the current value of a sequence.
java.lang.String	getSequenceNextValString(java.lang.String sequenceName) Generate the appropriate select statement to retrieve the next value of a sequence.
java.lang.String	getSequencePrefetchString(java.lang.String sequenceName) Generate the appropriate select statement to pre-fetch multiple, ascending values from a sequence.
java.lang.String	getSequenceSetValString(java.lang.String sequenceName, long newVal) Generate the appropriate select statement to reset the value of a sequence.
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.

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

addRtrimmedExpression, blobCreator, buildRemoteURL, checkErrorFn, clobCreator, computeIndexKeySize, createContext, explicitSetCollation, extractColumnName, formatDate, getAnalyzeString, getComputedColumnFormula, getComputedColumnPrefix, getCreateIndexString, getCreateTemporaryTablePostfix, getCreateTemporaryTableString, getDatabasePrepareStatements, getDelimiter, getDriverClassName, getDropIndexString, getDropIndexString, getDropTableString, getHighDate, getIndexLengthLimit, getJdbcDatabaseType, getLowDate, getMaxParameterCount, getProcessedCharacterColumnName, getScriptRunner, getSequenceSetValString, getSequenceSetValString, getSqlMappedType, getSyntheticIndexSize, initErrorFn, injectComputedColumns, inlineLimit, isCaseInsensitiveColumn, isComputedColumn, isConnectionError, isMetadataSortAsc, isMetadataSortDesc, isNativeUDFsSupported, isQueryRangeParameterInlined, isUdfOriginatedError, isUdfOriginatedWarning, isUniqueConstraintViolation, needsComputedColumns, prepareMetadataParameter, preparePermanentDatabase, processMetadataResult, requiresExplicitCastInsideTernary, scriptSplitter, supportsBooleanDatatype, supportsFunctionOverloading, useUdf4Contains, useWordTables

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, 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

Constructor Detail

P2JSQLServer2012Dialect

public P2JSQLServer2012Dialect()

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 SQL Server 2012 reserved keywords.

See Also:

https://msdn.microsoft.com/en-us/library/ms189822%28v=sql.110%29.aspx

getCreateSequenceString

public java.lang.String getCreateSequenceString(java.lang.String name)

Generate a DDL string which will create a global sequence.

Overrides:

getCreateSequenceString in class P2JSQLServer2008Dialect

Parameters:

name - Sequence name.

Returns:

Dialect-specific string to create the sequence, or null if not supported.

getCreateSequenceString

public java.lang.String getCreateSequenceString(java.lang.String name,
                                                long start)

Generate a DDL string which will create a global sequence with the given starting value.

Overrides:

getCreateSequenceString in class P2JSQLServer2008Dialect

Parameters:

name - Sequence name.

start - Sequence starting value.

Returns:

Dialect-specific string to create the sequence.

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.

Overrides:

getCreateSequenceString in class P2JSQLServer2008Dialect

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.

getDropSequenceString

public java.lang.String getDropSequenceString(java.lang.String name)

Generate a DDL string which will drop a sequence with given properties.

Overrides:

getDropSequenceString in class P2JSQLServer2008Dialect

Parameters:

name - The name of the sequence to be dropped.

Returns:

Dialect-specific string to drop the sequence.

getSequenceSetValString

public java.lang.String getSequenceSetValString(java.lang.String sequenceName,
                                                long newVal)

Generate the appropriate select statement to reset the value of a sequence.

Overrides:

getSequenceSetValString in class P2JSQLServer2008Dialect

Parameters:

sequenceName - The name of the sequence.

newVal - The new value to be set.

Returns:

Dialect-specific string to query the sequence.

getSequenceCurrValString

public java.lang.String getSequenceCurrValString(java.lang.String sequenceName)

Generate the appropriate select statement to retrieve the current value of a sequence.

Overrides:

getSequenceCurrValString in class P2JSQLServer2008Dialect

Parameters:

sequenceName - The name of the sequence to be queried.

Returns:

Dialect-specific string to query the sequence.

getSequenceCurrValString

public java.lang.String getSequenceCurrValString()

Generate the appropriate select statement to retrieve the current value of a sequence.

Overrides:

getSequenceCurrValString in class Dialect

Returns:

Dialect-specific string to query the sequence.

getSequenceNextValString

public java.lang.String getSequenceNextValString(java.lang.String sequenceName)

Generate the appropriate select statement to retrieve the next value of a sequence.

Overrides:

getSequenceNextValString in class P2JSQLServer2008Dialect

Parameters:

sequenceName - The name of the sequence.

Returns:

MS SQL Server dialect-specific string to query the sequence.

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.

Overrides:

hasFullSequenceSupport in class P2JSQLServer2008Dialect

Returns:

true because Server 2012 supports the concept of a SEQUENCE.

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.

Overrides:

getSequencePrefetchString in class P2JSQLServer2008Dialect

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.

createSequenceHandler

public SequenceHandler createSequenceHandler(java.lang.String ldbName)

Creates and returns a SequenceHandler for a SQL Server 2012 database.

Overrides:

createSequenceHandler in class P2JSQLServer2008Dialect

Parameters:

ldbName - The logical name of the database to create the SequenceHandler for.

Returns:

A SQLServer2012SequenceHandler instance.

applySqlLimit

public void applySqlLimit(int limit,
                          java.lang.StringBuilder buf,
                          int selectStartPos)

Given a string builder containing an SQL SELECT statement, a limit to apply, and the position in the builder at which the SELECT statement begins, augment the SQL statement to apply the given limit.

This method is intended to be used only in the specialized case of a well-known subquery which always begins with the SELECT keyword and always ends with an ORDER BY clause.

This implementation inserts top keyword, followed by the given numeric limit, immediately after the SELECT keyword.

Parameters:

limit - Maximum number of records to return.

buf - String builder containing the select statement. At the time this method is invoked, the builder will contain a statement which always will begin with the SELECT keyword and will end with an ORDER BY clause.

selectStartPos - Zero-based index position in the string builder of the first character of the SELECT keyword.

id

public java.lang.String id()

Get dialect id.

Overrides:

id in class P2JSQLServer2008Dialect

Returns:

Dialect id

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.

Overrides:

generateWordTablesDDLImpl in class P2JSQLServer2008Dialect

Parameters:

dbName - The target schema.

out - The PrintStream used for output.

eoln - OS-specific end of line terminator.

wordTables - word tables by name