Package com.adbs.syntax

Class MSSQLSyntaxProvider

java.lang.Object

java.awt.Component

com.adbs.syntax.BaseSyntaxProvider

com.adbs.syntax.MSSQLSyntaxProvider

All Implemented Interfaces:

Disposable, ImageObserver, MenuContainer, Serializable

Direct Known Subclasses:

MSSQLCESyntaxProvider

public class MSSQLSyntaxProvider
extends BaseSyntaxProvider

See Also:

• Serialized Form

Nested Class Summary

Nested classes/interfaces inherited from class com.adbs.syntax.BaseSyntaxProvider

BaseSyntaxProvider.ChangedEvent, BaseSyntaxProvider.ChangedEventListener, BaseSyntaxProvider.DestroyedEvent, BaseSyntaxProvider.DestroyedEventListener

Nested classes/interfaces inherited from class java.awt.Component

Component.AccessibleAWTComponent, Component.BaselineResizeBehavior, Component.BltBufferStrategy, Component.FlipBufferStrategy

Field Summary

Fields inherited from class com.adbs.syntax.BaseSyntaxProvider

changedEventListenerList, destroyedEventListenerList

Fields inherited from class java.awt.Component

accessibleContext, BOTTOM_ALIGNMENT, CENTER_ALIGNMENT, LEFT_ALIGNMENT, RIGHT_ALIGNMENT, TOP_ALIGNMENT

Fields inherited from interface java.awt.image.ImageObserver

ABORT, ALLBITS, ERROR, FRAMEBITS, HEIGHT, PROPERTIES, SOMEBITS, WIDTH

Constructor Summary

Constructors

Constructor	Description
MSSQLSyntaxProvider()

Method Summary

Modifier and Type	Method	Description
BaseSyntaxProvider	clone()
void	dispose()
void	doDetectServerVersion(BaseMetadataProvider metadataProvider)
void	get1ParamAggregateNames(SQLQualifiedNameList names)
void	getBuiltinFunctionNames(SQLQualifiedNameList names)
void	getComparisonOperators(List<String> list)
void	getDatabaseList(BaseSQLContext sqlContext, SQLQualifiedNameList databaseList)
SQLQualifiedName	getDefaultDatabaseName(BaseSQLContext sqlContext)
void	getDefaultSchemaNames(BaseSQLContext sqlContext, SQLIdentifiersCollection defaultSchemaNames)
String	getDescription()
Class	getEditPropsFormClass(Object forObj)
IdentCaseSensitivity	getIdentCaseSens()
protected Class	getParserClass()
void	getPrefixed1ParamAggregateNames(SQLQualifiedNameList names)
String	getQueryToLoadFieldsForObject(String fieldName, String objectExpression)
String	getQuoteBegin()
String	getQuoteEnd()
protected Class	getScannerClass()
void	getSchemaList(BaseSQLContext sqlContext, SQLIdentifiersCollection schemaList, SQLQualifiedName fromDatabase)
MSSQLServerVersion	getServerVersion()
void	getStarAggregateNames(SQLQualifiedNameList names)
void	getUnionOperatorList(List<String> sl)
boolean	isDenyIntoClause()
boolean	isDetectServerVersion()
boolean	isFixedSizeType(String type)
boolean	isInnerKeywordInLinksMandatory()
SyntaxSupportsConectedServer	isSupportConectedServer(BaseMetadataProvider metadataProvider)
boolean	isSupportCTE()
boolean	isSupportProcedures()
boolean	isSupportSchemas()
boolean	isSupportTransactSQLJoins()
void	loadFieldsForObjectFromServer(BaseSQLContext sqlContext, MetadataObject metadataObject)
void	loadMetadataCustomAggregateNames(BaseSQLContext sqlContext, MetadataContainer metadataContainer, SQLQualifiedName database)
void	loadMetadataObjects(BaseSQLContext sqlContext, MetadataContainer metadataContainer, MetadataFilter metadataFilter, SQLQualifiedName database)
void	loadMetadataRelations(BaseSQLContext sqlContext, MetadataContainer metadataContainer, MetadataFilter metadataFilter, SQLQualifiedName database)
void	resetCachedDefaultDatabaseName()
void	setDenyIntoClause(boolean value)
void	setDetectServerVersion(boolean detectServerVersion)
void	setIdentCaseSens(IdentCaseSensitivity value)
protected void	setParserParams(BaseParser parser)
void	setServerVersion(MSSQLServerVersion serverVersion)

Methods inherited from class com.adbs.syntax.BaseSyntaxProvider

addChangedEventListener, addDestroyedEventListener, assign, beginBuildWrapperForStoredProc, connectionChanged, createParser, createScanner, createWrapperForStoredProc, endBuildWrapperForStoredProc, findExtenderClass, findFieldInFieldList, fireChangedEvent, fireDestroyedEvent, getEmptySchemaName, getMultiParamAggregateNames, getObjectNameSeparator, getQueryToLoadFieldsForProcedure, getQueryToLoadFieldsForSynonym, getQueryToLoadFieldsForTable, getQueryToLoadFieldsForView, getSimpleEmptyFromSubquery, getUnionOperatorImage, getUpperCaseFunctionName, getUseObjectNamesAsDefaultAliases, isAsKeywordInExpressionAliasMandatory, isAsKeywordInObjectAliasMandatory, isColumnOfDBObject, isCreateWhereJoinsByDefault, isCteColumnNamesMandatory, isForceBinaryANSIJoins, isFromClauseMandatory, isIdentifiersCaseSensitive, isNonQuotedIdentifiersToUpperCase, isOuterKeywordInLinksMandatory, isServerVersionStored, isSupportAllTableFieldsSelection, isSupportANSIJoins, isSupportBracketsInUnions, isSupportCrossJoin, isSupportDatabases, isSupportDerivedTables, isSupportEmptyBracketsInStoredProcs, isSupportFullANSIJoin, isSupportGroupByStar, isSupportNullOrdering, isSupportOracleJoins, isSupportOrderByAlias, isSupportRecursiveCTE, isSupportSubQueryBracketsInUnions, isSupportSubQueryCTE, isSupportSubQueryDerivedTables, isSupportSubQueryUnions, isSupportSynonyms, isSupportUnions, isSupportViews, isUniversalExpressions, isVariablePrecisionType, loadFieldsForProcedureFromServer, loadFieldsForQuery, loadFieldsForSynonymFromServer, loadFieldsForTableFromServer, loadFieldsForViewFromServer, loadMetadataForProcedure, loadMetadataForSynonym, loadMetadataForTable, loadMetadataForView, loadParamsForProcedureFromServer, normalizeUnionOperator, registerExtender, registerExtender, removeChangedEventListener, removeDestroyedEventListener, sendNotifications, setCreateWhereJoinsByDefault, setScannerParams, toString, validateQuery

Methods inherited from class java.awt.Component

action, add, addComponentListener, addFocusListener, addHierarchyBoundsListener, addHierarchyListener, addInputMethodListener, addKeyListener, addMouseListener, addMouseMotionListener, addMouseWheelListener, addNotify, addPropertyChangeListener, addPropertyChangeListener, applyComponentOrientation, areFocusTraversalKeysSet, bounds, checkImage, checkImage, coalesceEvents, contains, contains, createImage, createImage, createVolatileImage, createVolatileImage, deliverEvent, disable, disableEvents, dispatchEvent, doLayout, enable, enable, enableEvents, enableInputMethods, firePropertyChange, firePropertyChange, firePropertyChange, firePropertyChange, firePropertyChange, firePropertyChange, firePropertyChange, firePropertyChange, firePropertyChange, getAccessibleContext, getAlignmentX, getAlignmentY, getBackground, getBaseline, getBaselineResizeBehavior, getBounds, getBounds, getColorModel, getComponentAt, getComponentAt, getComponentListeners, getComponentOrientation, getCursor, getDropTarget, getFocusCycleRootAncestor, getFocusListeners, getFocusTraversalKeys, getFocusTraversalKeysEnabled, getFont, getFontMetrics, getForeground, getGraphics, getGraphicsConfiguration, getHeight, getHierarchyBoundsListeners, getHierarchyListeners, getIgnoreRepaint, getInputContext, getInputMethodListeners, getInputMethodRequests, getKeyListeners, getListeners, getLocale, getLocation, getLocation, getLocationOnScreen, getMaximumSize, getMinimumSize, getMouseListeners, getMouseMotionListeners, getMousePosition, getMouseWheelListeners, getName, getParent, getPreferredSize, getPropertyChangeListeners, getPropertyChangeListeners, getSize, getSize, getToolkit, getTreeLock, getWidth, getX, getY, gotFocus, handleEvent, hasFocus, hide, imageUpdate, inside, invalidate, isBackgroundSet, isCursorSet, isDisplayable, isDoubleBuffered, isEnabled, isFocusable, isFocusCycleRoot, isFocusOwner, isFocusTraversable, isFontSet, isForegroundSet, isLightweight, isMaximumSizeSet, isMinimumSizeSet, isOpaque, isPreferredSizeSet, isShowing, isValid, isVisible, keyDown, keyUp, layout, list, list, list, list, list, locate, location, lostFocus, minimumSize, mouseDown, mouseDrag, mouseEnter, mouseExit, mouseMove, mouseUp, move, nextFocus, paint, paintAll, paramString, postEvent, preferredSize, prepareImage, prepareImage, print, printAll, processComponentEvent, processEvent, processFocusEvent, processHierarchyBoundsEvent, processHierarchyEvent, processInputMethodEvent, processKeyEvent, processMouseEvent, processMouseMotionEvent, processMouseWheelEvent, remove, removeComponentListener, removeFocusListener, removeHierarchyBoundsListener, removeHierarchyListener, removeInputMethodListener, removeKeyListener, removeMouseListener, removeMouseMotionListener, removeMouseWheelListener, removeNotify, removePropertyChangeListener, removePropertyChangeListener, repaint, repaint, repaint, repaint, requestFocus, requestFocus, requestFocus, requestFocus, requestFocusInWindow, requestFocusInWindow, requestFocusInWindow, reshape, resize, resize, revalidate, setBackground, setBounds, setBounds, setComponentOrientation, setCursor, setDropTarget, setEnabled, setFocusable, setFocusTraversalKeys, setFocusTraversalKeysEnabled, setFont, setForeground, setIgnoreRepaint, setLocale, setLocation, setLocation, setMaximumSize, setMinimumSize, setMixingCutoutShape, setName, setPreferredSize, setSize, setSize, setVisible, show, show, size, transferFocus, transferFocusBackward, transferFocusUpCycle, update, validate

Methods inherited from class java.lang.Object

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

Constructor Details

MSSQLSyntaxProvider

public MSSQLSyntaxProvider()

Method Details

dispose

public void dispose()

Specified by:

dispose in interface Disposable

Overrides:

dispose in class BaseSyntaxProvider

clone

public BaseSyntaxProvider clone()

Overrides:

clone in class BaseSyntaxProvider

getServerVersion

public MSSQLServerVersion getServerVersion()

setServerVersion

public void setServerVersion(MSSQLServerVersion serverVersion)

getIdentCaseSens

public IdentCaseSensitivity getIdentCaseSens()

Overrides:

getIdentCaseSens in class BaseSyntaxProvider

setIdentCaseSens

public void setIdentCaseSens(IdentCaseSensitivity value)

Overrides:

setIdentCaseSens in class BaseSyntaxProvider

getParserClass

protected Class getParserClass()

Overrides:

getParserClass in class BaseSyntaxProvider

getScannerClass

protected Class getScannerClass()

Overrides:

getScannerClass in class BaseSyntaxProvider

getDescription

public String getDescription()

Overrides:

getDescription in class BaseSyntaxProvider

setParserParams

protected void setParserParams(BaseParser parser)

Overrides:

setParserParams in class BaseSyntaxProvider

resetCachedDefaultDatabaseName

public void resetCachedDefaultDatabaseName()

Overrides:

resetCachedDefaultDatabaseName in class BaseSyntaxProvider

getDefaultDatabaseName

public SQLQualifiedName getDefaultDatabaseName(BaseSQLContext sqlContext)
                                        throws QueryBuilderException

Overrides:

getDefaultDatabaseName in class BaseSyntaxProvider

Throws:

QueryBuilderException

getDefaultSchemaNames

public void getDefaultSchemaNames(BaseSQLContext sqlContext,
 SQLIdentifiersCollection defaultSchemaNames)
                           throws QueryBuilderException

Overrides:

getDefaultSchemaNames in class BaseSyntaxProvider

Throws:

QueryBuilderException

getStarAggregateNames

public void getStarAggregateNames(SQLQualifiedNameList names)

Overrides:

getStarAggregateNames in class BaseSyntaxProvider

get1ParamAggregateNames

public void get1ParamAggregateNames(SQLQualifiedNameList names)

Overrides:

get1ParamAggregateNames in class BaseSyntaxProvider

getPrefixed1ParamAggregateNames

public void getPrefixed1ParamAggregateNames(SQLQualifiedNameList names)

Overrides:

getPrefixed1ParamAggregateNames in class BaseSyntaxProvider

getComparisonOperators

public void getComparisonOperators(List<String> list)

Overrides:

getComparisonOperators in class BaseSyntaxProvider

getQuoteBegin

public String getQuoteBegin()

Overrides:

getQuoteBegin in class BaseSyntaxProvider

getQuoteEnd

public String getQuoteEnd()

Overrides:

getQuoteEnd in class BaseSyntaxProvider

isSupportProcedures

public boolean isSupportProcedures()

Overrides:

isSupportProcedures in class BaseSyntaxProvider

isSupportSchemas

public boolean isSupportSchemas()

Overrides:

isSupportSchemas in class BaseSyntaxProvider

isSupportCTE

public boolean isSupportCTE()

Overrides:

isSupportCTE in class BaseSyntaxProvider

getUnionOperatorList

public void getUnionOperatorList(List<String> sl)

Overrides:

getUnionOperatorList in class BaseSyntaxProvider

getEditPropsFormClass

public Class getEditPropsFormClass(Object forObj)

Overrides:

getEditPropsFormClass in class BaseSyntaxProvider

getBuiltinFunctionNames

public void getBuiltinFunctionNames(SQLQualifiedNameList names)

Overrides:

getBuiltinFunctionNames in class BaseSyntaxProvider

getQueryToLoadFieldsForObject

public String getQueryToLoadFieldsForObject(String fieldName,
 String objectExpression)

Overrides:

getQueryToLoadFieldsForObject in class BaseSyntaxProvider

getDatabaseList

public void getDatabaseList(BaseSQLContext sqlContext,
 SQLQualifiedNameList databaseList)

Overrides:

getDatabaseList in class BaseSyntaxProvider

loadMetadataObjects

public void loadMetadataObjects(BaseSQLContext sqlContext,
 MetadataContainer metadataContainer,
 MetadataFilter metadataFilter,
 SQLQualifiedName database)
                         throws QueryBuilderException

Overrides:

loadMetadataObjects in class BaseSyntaxProvider

Throws:

QueryBuilderException

loadMetadataRelations

public void loadMetadataRelations(BaseSQLContext sqlContext,
 MetadataContainer metadataContainer,
 MetadataFilter metadataFilter,
 SQLQualifiedName database)
                           throws QueryBuilderException

Overrides:

loadMetadataRelations in class BaseSyntaxProvider

Throws:

QueryBuilderException

loadMetadataCustomAggregateNames

public void loadMetadataCustomAggregateNames(BaseSQLContext sqlContext,
 MetadataContainer metadataContainer,
 SQLQualifiedName database)

Overrides:

loadMetadataCustomAggregateNames in class BaseSyntaxProvider

loadFieldsForObjectFromServer

public void loadFieldsForObjectFromServer(BaseSQLContext sqlContext,
 MetadataObject metadataObject)
                                   throws QueryBuilderException

Overrides:

loadFieldsForObjectFromServer in class BaseSyntaxProvider

Throws:

QueryBuilderException

isSupportConectedServer

public SyntaxSupportsConectedServer isSupportConectedServer(BaseMetadataProvider metadataProvider)

Overrides:

isSupportConectedServer in class BaseSyntaxProvider

isFixedSizeType

public boolean isFixedSizeType(String type)

Overrides:

isFixedSizeType in class BaseSyntaxProvider

isDenyIntoClause

public boolean isDenyIntoClause()

Overrides:

isDenyIntoClause in class BaseSyntaxProvider

setDenyIntoClause

public void setDenyIntoClause(boolean value)

Overrides:

setDenyIntoClause in class BaseSyntaxProvider

isInnerKeywordInLinksMandatory

public boolean isInnerKeywordInLinksMandatory()

Overrides:

isInnerKeywordInLinksMandatory in class BaseSyntaxProvider

getSchemaList

public void getSchemaList(BaseSQLContext sqlContext,
 SQLIdentifiersCollection schemaList,
 SQLQualifiedName fromDatabase)

Overrides:

getSchemaList in class BaseSyntaxProvider

isSupportTransactSQLJoins

public boolean isSupportTransactSQLJoins()

Overrides:

isSupportTransactSQLJoins in class BaseSyntaxProvider

isDetectServerVersion

public boolean isDetectServerVersion()

Overrides:

isDetectServerVersion in class BaseSyntaxProvider

setDetectServerVersion

public void setDetectServerVersion(boolean detectServerVersion)

Overrides:

setDetectServerVersion in class BaseSyntaxProvider

doDetectServerVersion

public void doDetectServerVersion(BaseMetadataProvider metadataProvider)

Overrides:

doDetectServerVersion in class BaseSyntaxProvider