wt.pds.sqlServer
Class SQLServerDMLGenerator

java.lang.Object
  wt.pds.StandardDMLGenerator
      wt.pds.sqlServer.SQLServerDMLGenerator

All Implemented Interfaces:

DMLGenerator, RemoteAccess

public class SQLServerDMLGenerator

extends StandardDMLGenerator

implements RemoteAccess

Supported API: false

Extendable: false

Field Summary

private static String	CLASSNAME
private static KeywordExpression	DATETIME_EXPRESSION
private static String	FC_RESOURCE
private static String	FOR_UPDATE
private static HashMap	functionnameMap
protected static HashMap	infixMap
private static String	RESOURCE
(package private) static boolean	SERVER
private static ConstantExpression	TIMESTAMP_FORMAT_EXPRESSION
private static KeywordExpression	VARCHAR_EXPRESSION

Fields inherited from class wt.pds.StandardDMLGenerator

CLOSE_HINTS, DEBUG, LOCK_SQL_MAP, OPEN_HINTS

Fields inherited from interface wt.method.RemoteAccess

versionID

Fields inherited from interface wt.pds.DMLGenerator

AND, AUTO_NAVI_ALIAS, BIND_PLACEHOLDER, CLOSE_PAREN, COLUMNALIAS_SUFFIX, COMMA, DB_DELIMITER, DELETE, DELETE_FROM, DISTINCT, DUMMY_BINDPARAMETER, DUMMY_TABLE, EQUAL, EQUAL_PLACEHOLDER, ESCAPE, ESCAPE_CHAR, EXISTS, FALSE_CONDITION, FROM, GREATER_THAN, GROUP_BY, HAVING, INNER_JOIN, INSERT_INTO, INTERSECT, LEFT_OUTER_JOIN, MINUS, NOT, NULL, NULL_DATE, NULL_NUMBER, ON, OPEN_PAREN, OR, ORDER_BY, OUTER_JOIN, PLACEHOLDER, RIGHT_OUTER_JOIN, SELECT, SET, SET_EQUAL, SINGLE_QUOTE, SPACE, STRING_BUFFER_INITIAL_LENGTH, TIMESTAMP_FORMAT, TRUE_CONDITION, UNION, UNION_ALL, UPDATE, VIEW_PREFIX, WHERE, ZERO

Constructor Summary

SQLServerDMLGenerator()

Method Summary

protected static Object	_buildBindParameters(StatementSpec a_statementSpec, WTConnection a_connection) Supported API: false
String	buildArrayTableExpression(String a_alias, String a_type, String a_selectList, Object a_values) This method is used to build the SQL string for ArrayTableExpression.
Object	buildBindParameters(StatementSpec a_statementSpec) Supported API: false
static Object	buildBindParameters(StatementSpec a_statementSpec, WTConnection a_connection) Supported API: false
protected String	buildCallBody(String a_procedureName, int a_parameterCount, boolean a_isFunction) Supported API: false
String	buildDataStoreProcedureName(String a_procedureName) Supported API: false
protected String	buildInsertColumnForSeqeunce(ColumnDescriptor a_sequenceColumn) Supported API: false
String	buildLockStatement(ClassInfo a_classInfo) Supported API: false
String	buildSelectStatement(Vector a_tables, Vector a_aliases, ResultBuilder a_resultBuilder, boolean a_isDistinct, String a_select, String a_whereClause, String a_groupByClause, String a_havingClause, String a_orderByClause, boolean a_forUpdate, int[] a_joinOrder, Vector a_hintsVector, boolean[] a_fullPersistableTableIndicies, JoinClause a_joinClause, boolean a_useBind) Supported API: false
String[]	buildStatements(StatementSpec a_statementSpec, WTConnection a_connection) Supported API: false
String[]	buildStatements(StatementSpec a_statementSpec, WTConnection a_connection, boolean a_dummyParameter) Supported API: false
String	buildTableLockStatement(ClassInfo a_classInfo) Supported API: false
String	getFunctionExpression(String funcName, Vector args, boolean a_useBind, Vector a_tableInfos, Vector a_aliases, boolean a_outerJoin) This method returns an expression for the SQL function.
protected String	getSQLFunctionName(String a_funcName) Supported API: false
private String	getTSqlDecodeExpression(Vector args, boolean a_useBind, boolean a_outerJoin)

Methods inherited from class wt.pds.StandardDMLGenerator

appendQuote, buildArrayTableExpression, buildArrayTableSelectList, buildAttributeUpdateStatement, buildBindParameters_common, buildCall, buildCallParameterList, buildCompoundStatement, buildConditionForSelect, buildConditionForSelect, buildDeleteStatement, buildDummySubSelectStatement, buildEmptyDummySubSelectStatement, buildFromForSelect, buildInsertStatement, buildInsertStatement, buildInsertStatement, buildPartialSelect, buildStatements_common, buildSubSelectStatement, buildUpdateStatement, buildUpdateStatement, buildUpdateStatement, findTargetClass, getArgumentExpression, getAutoNaviJoinCondition, getComputedColumnName, getFunctionExpression, getInfixExpression, getInfixExpression, getTableOrder, quote, validateArguments, verifyTargetClass

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

RESOURCE

private static final String RESOURCE

See Also:

Constant Field Values

CLASSNAME

private static final String CLASSNAME

SERVER

static final boolean SERVER

FC_RESOURCE

private static final String FC_RESOURCE

See Also:

Constant Field Values

FOR_UPDATE

private static final String FOR_UPDATE

See Also:

Constant Field Values

functionnameMap

private static HashMap functionnameMap

infixMap

protected static HashMap infixMap

TIMESTAMP_FORMAT_EXPRESSION

private static final ConstantExpression TIMESTAMP_FORMAT_EXPRESSION

VARCHAR_EXPRESSION

private static final KeywordExpression VARCHAR_EXPRESSION

DATETIME_EXPRESSION

private static final KeywordExpression DATETIME_EXPRESSION

Constructor Detail

SQLServerDMLGenerator

public SQLServerDMLGenerator()

Method Detail

getFunctionExpression

public String getFunctionExpression(String funcName,
                                    Vector args,
                                    boolean a_useBind,
                                    Vector a_tableInfos,
                                    Vector a_aliases,
                                    boolean a_outerJoin)
                             throws WTException

This method returns an expression for the SQL function.

Supported API: false

Specified by:

getFunctionExpression in interface DMLGenerator

Overrides:

getFunctionExpression in class StandardDMLGenerator

Parameters:

funcName - The logic function name

args -

a_useBind -

a_tableInfos -

a_aliases -

a_outerJoin -

Returns:

String

Throws:

WTException

buildBindParameters

public Object buildBindParameters(StatementSpec a_statementSpec)
                           throws WTException

Supported API: false

Specified by:

buildBindParameters in interface DMLGenerator

Specified by:

buildBindParameters in class StandardDMLGenerator

Parameters:

a_statementSpec -

Returns:

Object

Throws:

WTException

buildStatements

public String[] buildStatements(StatementSpec a_statementSpec,
                                WTConnection a_connection)
                         throws WTException

Supported API: false

Specified by:

buildStatements in interface DMLGenerator

Specified by:

buildStatements in class StandardDMLGenerator

Parameters:

a_statementSpec -

a_connection -

Returns:

String[]

Throws:

WTException

buildStatements

public String[] buildStatements(StatementSpec a_statementSpec,
                                WTConnection a_connection,
                                boolean a_dummyParameter)
                         throws WTException

Supported API: false

Parameters:

a_statementSpec -

a_connection -

a_dummyParameter -

Returns:

String[]

Throws:

WTException

buildBindParameters

public static Object buildBindParameters(StatementSpec a_statementSpec,
                                         WTConnection a_connection)
                                  throws WTException

Supported API: false

Parameters:

a_statementSpec -

a_connection -

Returns:

Object

Throws:

WTException

_buildBindParameters

protected static Object _buildBindParameters(StatementSpec a_statementSpec,
                                             WTConnection a_connection)
                                      throws WTException

Supported API: false

Parameters:

a_statementSpec -

a_connection -

Returns:

Object

Throws:

WTException

getSQLFunctionName

protected String getSQLFunctionName(String a_funcName)

Supported API: false

Specified by:

getSQLFunctionName in class StandardDMLGenerator

Parameters:

a_funcName -

Returns:

String

buildInsertColumnForSeqeunce

protected String buildInsertColumnForSeqeunce(ColumnDescriptor a_sequenceColumn)

Supported API: false

Specified by:

buildInsertColumnForSeqeunce in class StandardDMLGenerator

Parameters:

a_sequenceColumn -

Returns:

String

buildCallBody

protected String buildCallBody(String a_procedureName,
                               int a_parameterCount,
                               boolean a_isFunction)

Supported API: false

Specified by:

buildCallBody in class StandardDMLGenerator

Parameters:

a_procedureName -

a_parameterCount -

a_isFunction -

Returns:

String

buildSelectStatement

public String buildSelectStatement(Vector a_tables,
                                   Vector a_aliases,
                                   ResultBuilder a_resultBuilder,
                                   boolean a_isDistinct,
                                   String a_select,
                                   String a_whereClause,
                                   String a_groupByClause,
                                   String a_havingClause,
                                   String a_orderByClause,
                                   boolean a_forUpdate,
                                   int[] a_joinOrder,
                                   Vector a_hintsVector,
                                   boolean[] a_fullPersistableTableIndicies,
                                   JoinClause a_joinClause,
                                   boolean a_useBind)
                            throws PersistenceException

Supported API: false

Specified by:

buildSelectStatement in interface DMLGenerator

Specified by:

buildSelectStatement in class StandardDMLGenerator

Parameters:

a_tables -

a_aliases -

a_resultBuilder -

a_isDistinct -

a_select -

a_whereClause -

a_groupByClause -

a_havingClause -

a_orderByClause -

a_forUpdate -

a_joinOrder -

a_hintsVector -

a_fullPersistableTableIndicies -

a_joinClause -

a_useBind -

Returns:

String

Throws:

PersistenceException

buildLockStatement

public String buildLockStatement(ClassInfo a_classInfo)
                          throws PersistenceException

Supported API: false

Specified by:

buildLockStatement in interface DMLGenerator

Specified by:

buildLockStatement in class StandardDMLGenerator

Parameters:

a_classInfo -

Returns:

String

Throws:

PersistenceException

buildTableLockStatement

public String buildTableLockStatement(ClassInfo a_classInfo)
                               throws PersistenceException

Supported API: false

Specified by:

buildTableLockStatement in interface DMLGenerator

Specified by:

buildTableLockStatement in class StandardDMLGenerator

Parameters:

a_classInfo -

Returns:

String

Throws:

PersistenceException

buildDataStoreProcedureName

public String buildDataStoreProcedureName(String a_procedureName)

Supported API: false

Specified by:

buildDataStoreProcedureName in class StandardDMLGenerator

Parameters:

a_procedureName -

Returns:

String

buildArrayTableExpression

public String buildArrayTableExpression(String a_alias,
                                        String a_type,
                                        String a_selectList,
                                        Object a_values)

This method is used to build the SQL string for ArrayTableExpression.

Supported API: false

Specified by:

buildArrayTableExpression in interface DMLGenerator

Specified by:

buildArrayTableExpression in class StandardDMLGenerator

Parameters:

a_alias -

a_type -

a_selectList -

a_values -

Returns:

String

getTSqlDecodeExpression

private String getTSqlDecodeExpression(Vector args,
                                       boolean a_useBind,
                                       boolean a_outerJoin)
                                throws WTException

Throws:

WTException