com.toolsverse.etl.driver.sqlserver

Class SybaseDriver

Object

com.toolsverse.etl.driver.AbstractDriver

com.toolsverse.etl.driver.CallableDriver

com.toolsverse.etl.driver.sqlserver.MsSqlDriver

com.toolsverse.etl.driver.sqlserver.SybaseDriver

All Implemented Interfaces:

Driver, ExtensionModule, Serializable, Comparable<ExtensionModule>

public class SybaseDriver
extends MsSqlDriver

The Sybase Sql server implementation of the Driver interface.

Since:

1.0

Version:

2.0

See Also:

Serialized Form

Field Summary

Fields

Modifier and Type	Field and Description
static String	BEGIN The BEGIN sql.
static String	BEGIN_SPLITED The BEGIN_SPLITED sql.
static String	DECLARE The DECLARE sql.
static String	END The END sql.
static String	END_SPLITED The END_SPLITED sql.
static String	INIT_SQL The Constant INIT sql.
static int	LINES_LIMIT The maximum number of lines allowed in the sql block.
static int	MAX_CHAR_SIZE The maximum char size.
static int	MAX_NUMBER_PREC_SIZE The maximum precision.
static int	MAX_NUMBER_SCALE_SIZE The maximum scale.
static int	MAX_STRING_LITERAL_SIZE The maximum string literal size.
static int	MAX_VARCHAR_SIZE The maximum varchar size.
static String	SYBASE_HOME_PROP The SYBASE client HOME property.
static String	SYBASE_HOME_VAR The SYBASE client HOME variable.

Fields inherited from class com.toolsverse.etl.driver.sqlserver.MsSqlDriver

EXCEPTIONS, IF, IF_BEGIN, IF_ELSE, IF_END, MSSQL_HOME_PROP, MSSQL_HOME_VAR, ON_EXCEPTION, ON_EXCEPTION_BEGIN, ON_EXCEPTION_END

Fields inherited from class com.toolsverse.etl.driver.AbstractDriver

ALLOWED_IDENT_CHARS

Fields inherited from interface com.toolsverse.etl.driver.Driver

BASE_CLASS_PATH, CASE_SENSITIVE_LOWER, CASE_SENSITIVE_LOWER_STR, CASE_SENSITIVE_UNDEFINED, CASE_SENSITIVE_UPPER, CASE_SENSITIVE_UPPER_STR, CMD_OPTIONS_PARAM, DB_PARAM, DDL_TYPE, ETL_CODE, FUNC_TYPE, PROC_TYPE, SERVER_PARAM, TABLE_TYPE

Fields inherited from interface com.toolsverse.ext.ExtensionModule

APP, COMMAND, ETL_DRIVER, FORMATTER, IDE_NODE, NO_RANK, WIDGET

Constructor Summary

Constructors

Constructor and Description
SybaseDriver()

Method Summary

Modifier and Type	Method and Description
protected String	_getInitSql() Gets init sql.
protected int	_getLinesLimit() Gets lines limit.
protected int	_getMaxCharSize() Gets max char size.
protected int	_getMaxPrecision() Gets max precision.
protected int	_getMaxScale() Gets the max scale.
protected int	_getMaxStringLiteralSize() Gets the max string literal size.
protected int	_getMaxVarcharSize() Gets the max varchar size.
String	getBegin() Gets the "begin" sql statement.
String	getBeginSplited() Gets the "begin" token for splited sql.
String	getCallSql(String name) Gets the "call" sql.
String	getCmdForExternalTool(ObjectStorage storage, Alias alias, String sqlFile) Gets the command line for the external tool.
String	getCreateTableSql(String name, DataSet dataSet, boolean isTemporary, String key, FieldsRepository fieldsRepository) Gets the "create table" sql.
String	getCursorLoopEndSql(String name, DataSet dataSet) Gets the "loop end" sql for the cursor.
String	getCursorLoopStartSql(String name, String cursorSql, DataSet dataSet) Gets the "loop start" sql for the cursor.
protected String	getDateTimeStyle() Gets the date+time style.
static String	getDbName(Alias alias) Gets the database name.
String	getDeclare() Gets the "declare" sql.
String	getDeclareCursorSql(String sql, String name, String cursorSql, DataSet dataSet) Gets the "declare cursor" sql.
String	getDefaultFunctionClass() Gets the default function class name.
String	getDefaultNull() Gets the "default null" value.
String	getDelimiter() Gets the default delimiter.
String	getEnd() Gets the "end" sql.
String	getEndSplited() Gets the "end" token for the splited sql statement.
Object	getExplainPlan(ObjectStorage storage, Connection connection, Alias alias, String sql) Gets the explain plan for the sql.
String	getExternalToolName() Gets the external tool name.
String	getHome(ObjectStorage storage) Gets the home folder for the native database client.
String	getIconPath() Gets the full path to the icon file.
String	getJdbcDriverClassName() Gets the jdbc driver class name.
String	getLicensePropertyName() Gets the name of the license property.
String	getMetadataClassName() Gets the metadata driver class name.
String	getName() Gets the name of the driver.
String	getObjectCheckSql(String name) Gets the sql used to check if object exists.
String	getOnException(OnException onException) Gets the "on exception" sql.
String	getOnExceptionBegin(OnException onException, long row) Gets the "on exception begin" sql.
String	getOnExceptionEnd() Gets the "on exception end" sql.
String[]	getProperties() Gets the properties.
String	getPropsWizardResource(String connectionDriver) Gets the name of the xml file used to create a wizard for editing properties.
String	getSafeSql(String sql) Gets the safe sql.
static String	getServer(Alias alias) Gets the server name.
String	getSqlForExternalTool(Alias alias, String sql, SqlParser parser) Gets the sql for external tool.
String	getSqlKeywordsFileName() Gets the sql keywords file name.
String	getTempTableName(String name) Gets the temporary table name.
String	getType(FieldDef fieldDef, String key, FieldsRepository fieldsRepository) Gets the native field type.
String	getUrlPattern() Gets the jdbc driver url pattern.
String	getVendor() Gets the vendor.
String	getVersion() Gets the version of the extension module.
String	getXmlConfigFileName() Gets the path to the xml configuration file for the module.
boolean	needSeparateConnectionForDdl() Check if driver requires separate connection for ddl statements.
boolean	requiresExecuteQuery() Checks if driver requires to run as st.executeQuery() in some cases.
boolean	requiresSeparateConnectionForIndexes() Checks if driver requires separate connection for indexes.
boolean	supportsAnonymousBlocks() "Supports anonymous blocks" flag.
boolean	supportsRollbackAfterDDL() "Supports rollback after ddl" flag.
boolean	typeHasSize(int type, String nativeDataType) Returns true if type has size.

Methods inherited from class com.toolsverse.etl.driver.sqlserver.MsSqlDriver

convertStringForStorage, convertValueForStorage, getAddColumnSql, getAutotrace, getCursorRecAccessSql, getCursorVarName, getDeclareCursorEndSql, getDeclareCursorVarSql, getDefaultType, getDropSql, getFetchNextSql, getIf, getIfBegin, getIfElse, getIfEnd, getMergeStatement, getMetadataSelectClause, getMetadataWhereClause, getObject, getParamType, getSafeDelimiter, getServer, getTopSelectClause, getTopTrailClause, getTopWhereClause, getVarDeclare, getVarName, ignoreExceptionsDuringInit, isMergeInNonCallableSupported, supportedJoinTypes, supportedSetOperations, supportsAutotrace, supportsBinaryInProc, supportsCallableStatement, supportsExplainPlan, supportsExternalTool, supportsInnerFunctions, supportsParamsInAnonymousBlocks

Methods inherited from class com.toolsverse.etl.driver.CallableDriver

deleteStagingBinary, getBlob, getCharUsedForColumnsWithSpaces, getClob, getDestinationInfo, getInitSql, getLinesLimit, getMaxCharSize, getMaxPrecision, getMaxScale, getMaxStringLiteralSize, getMaxVarcharSize, getParentDriverName, getWrongScale, replaceOnException, setBlob, setClob, setInitSql, setLinesLimit, setMaxCharSize, setMaxPrecision, setMaxScale, setMaxStringLiteralSize, setMaxVarcharSize, setParentDriverName, supportsIndexes, supportsScripts, updateStagingBlob, updateStagingClob, value2StorageValue

Methods inherited from class com.toolsverse.etl.driver.AbstractDriver

alwaysEncloseTableAndColumnsInQuotes, captureLog, compareTo, externalToolRequiresRedirect, filter, getAllowedIdentifierChars, getAlterTableAddColumnSql, getAlterTableAddColumnSql, getCaseSensitive, getCmdOptions, getColumns, getConfigFileName, getConnectionFile, getDeleteStatement, getDisplayName, getErrorLinePattern, getExtensionRank, getIdentifierName, getIdentifierName, getInsertStatement, getLocalUnitClassPath, getNativeType, getParentDriver, getPostDeclareSql, getSelectStatement, getSqlForAutotrace, getSqlForExplainPlan, getStartTransactionSql, getStringFieldSizeMultiplier, getTableName, getTablePrefixWhenAddingTable, getType, getUpdateStatement, isEqualDriver, requiresRollbackAfterSqlError, setAlwaysEncloseTableAndColumnsInQuotes, setCaseSensitive, setStringFieldSizeMultiplier, setUpConnection, supportColonInFormatter, supportsLogging, supportsNotNullable, supportsParallelExtract, supportsParallelLoad, supportsParentDriver, supportsPreparedStatement, supportsPreparedStatementInParallelThreads, supportsPreparedStatementInTransaction, tableName2Name

Methods inherited from class Object

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

Methods inherited from interface com.toolsverse.etl.driver.Driver

disableMetadataOnWrite, getIoProcessorClassName, getPrecision, ifDoesNotExistSql, ifExistsSql, openCloseConnectionOnDdl, requiresSemicolonInMerge

Field Detail

SYBASE_HOME_VAR

public static final String SYBASE_HOME_VAR

The SYBASE client HOME variable.

See Also:

Constant Field Values

SYBASE_HOME_PROP

public static final String SYBASE_HOME_PROP

The SYBASE client HOME property.

See Also:

Constant Field Values

MAX_STRING_LITERAL_SIZE

public static int MAX_STRING_LITERAL_SIZE

The maximum string literal size.

MAX_VARCHAR_SIZE

public static int MAX_VARCHAR_SIZE

The maximum varchar size.

LINES_LIMIT

public static int LINES_LIMIT

The maximum number of lines allowed in the sql block.

MAX_CHAR_SIZE

public static int MAX_CHAR_SIZE

The maximum char size.

MAX_NUMBER_PREC_SIZE

public static int MAX_NUMBER_PREC_SIZE

The maximum precision.

MAX_NUMBER_SCALE_SIZE

public static int MAX_NUMBER_SCALE_SIZE

The maximum scale.

INIT_SQL

public static final String INIT_SQL

The Constant INIT sql.

See Also:

Constant Field Values

DECLARE

public static final String DECLARE

The DECLARE sql.

See Also:

Constant Field Values

BEGIN

public static final String BEGIN

The BEGIN sql.

See Also:

Constant Field Values

BEGIN_SPLITED

public static final String BEGIN_SPLITED

The BEGIN_SPLITED sql.

See Also:

Constant Field Values

END

public static final String END

The END sql.

See Also:

Constant Field Values

END_SPLITED

public static final String END_SPLITED

The END_SPLITED sql.

See Also:

Constant Field Values

Constructor Detail

SybaseDriver

public SybaseDriver()

Method Detail

getDbName

public static String getDbName(Alias alias)

Gets the database name.

Parameters:

alias - the alias

Returns:

the database name

getServer

public static String getServer(Alias alias)

Gets the server name.

Parameters:

alias - the alias

Returns:

the server name

_getInitSql

protected String _getInitSql()

Description copied from class: CallableDriver

Gets init sql.

Overrides:

_getInitSql in class MsSqlDriver

Returns:

the string

_getLinesLimit

protected int _getLinesLimit()

Description copied from class: CallableDriver

Gets lines limit.

Overrides:

_getLinesLimit in class MsSqlDriver

Returns:

the lines limit

_getMaxCharSize

protected int _getMaxCharSize()

Description copied from class: CallableDriver

Gets max char size.

Overrides:

_getMaxCharSize in class MsSqlDriver

Returns:

the max char size

_getMaxPrecision

protected int _getMaxPrecision()

Description copied from class: CallableDriver

Gets max precision.

Overrides:

_getMaxPrecision in class MsSqlDriver

Returns:

the max precision

_getMaxScale

protected int _getMaxScale()

Description copied from class: CallableDriver

Gets the max scale.

Overrides:

_getMaxScale in class MsSqlDriver

Returns:

the max scale

_getMaxStringLiteralSize

protected int _getMaxStringLiteralSize()

Description copied from class: CallableDriver

Gets the max string literal size.

Overrides:

_getMaxStringLiteralSize in class MsSqlDriver

Returns:

the max string literal size

_getMaxVarcharSize

protected int _getMaxVarcharSize()

Description copied from class: CallableDriver

Gets the max varchar size.

Overrides:

_getMaxVarcharSize in class MsSqlDriver

Returns:

the max varchar size

getBegin

public String getBegin()

Description copied from interface: Driver

Gets the "begin" sql statement.

Specified by:

getBegin in interface Driver

Overrides:

getBegin in class MsSqlDriver

Returns:

the "begin" sql statemnt

getBeginSplited

public String getBeginSplited()

Description copied from interface: Driver

Gets the "begin" token for splited sql.

Specified by:

getBeginSplited in interface Driver

Overrides:

getBeginSplited in class MsSqlDriver

Returns:

the the "begin" token for the splited sql

getCallSql

public String getCallSql(String name)

Description copied from interface: Driver

Gets the "call" sql. Example: "test" - > call test()

Specified by:

getCallSql in interface Driver

Overrides:

getCallSql in class MsSqlDriver

Parameters:

name - the name of the procedure

Returns:

the "call" sql

getCmdForExternalTool

public String getCmdForExternalTool(ObjectStorage storage,
                                    Alias alias,
                                    String sqlFile)

Description copied from interface: Driver

Gets the command line for the external tool.

Specified by:

getCmdForExternalTool in interface Driver

Overrides:

getCmdForExternalTool in class MsSqlDriver

Parameters:

storage - the object storage

alias - the alias

sqlFile - the sql file

Returns:

the command line for the external tool

See Also:

ObjectStorage

getCreateTableSql

public String getCreateTableSql(String name,
                                DataSet dataSet,
                                boolean isTemporary,
                                String key,
                                FieldsRepository fieldsRepository)

Description copied from interface: Driver

Gets the "create table" sql.

Specified by:

getCreateTableSql in interface Driver

Overrides:

getCreateTableSql in class MsSqlDriver

Parameters:

name - the table name

dataSet - the data set

isTemporary - if true the table is temporary

key - the key field(s)

fieldsRepository - the fields repository

Returns:

the "create table" sql

See Also:

FieldsRepository

getCursorLoopEndSql

public String getCursorLoopEndSql(String name,
                                  DataSet dataSet)

Description copied from interface: Driver

Gets the "loop end" sql for the cursor.

Specified by:

getCursorLoopEndSql in interface Driver

Overrides:

getCursorLoopEndSql in class MsSqlDriver

Parameters:

name - the name of the cusror

dataSet - the data set

Returns:

the "loop end" sql for the cursor

getCursorLoopStartSql

public String getCursorLoopStartSql(String name,
                                    String cursorSql,
                                    DataSet dataSet)

Description copied from interface: Driver

Gets the "loop start" sql for the cursor.

Specified by:

getCursorLoopStartSql in interface Driver

Overrides:

getCursorLoopStartSql in class MsSqlDriver

Parameters:

name - the name of the cursor

cursorSql - the cursor sql

dataSet - the data set

Returns:

the "loop end" sql for the cursor

getDateTimeStyle

protected String getDateTimeStyle()

Description copied from class: MsSqlDriver

Gets the date+time style.

Overrides:

getDateTimeStyle in class MsSqlDriver

Returns:

the date+time style

getDeclare

public String getDeclare()

Description copied from interface: Driver

Gets the "declare" sql.

Specified by:

getDeclare in interface Driver

Overrides:

getDeclare in class MsSqlDriver

Returns:

the "declare" sql

getDeclareCursorSql

public String getDeclareCursorSql(String sql,
                                  String name,
                                  String cursorSql,
                                  DataSet dataSet)

Description copied from interface: Driver

Gets the "declare cursor" sql.

Specified by:

getDeclareCursorSql in interface Driver

Overrides:

getDeclareCursorSql in class MsSqlDriver

Parameters:

sql - the sql

name - the name of the cursor

cursorSql - the cursor sql

dataSet - the data set

Returns:

the "declare cursor" sql

getDefaultFunctionClass

public String getDefaultFunctionClass()

Description copied from interface: Driver

Gets the default function class name.

Specified by:

getDefaultFunctionClass in interface Driver

Overrides:

getDefaultFunctionClass in class MsSqlDriver

Returns:

the default function class name

See Also:

Function

getDefaultNull

public String getDefaultNull()

Description copied from interface: Driver

Gets the "default null" value. Some databases require default "null", "not null" attributes when creating tables.

Specified by:

getDefaultNull in interface Driver

Overrides:

getDefaultNull in class AbstractDriver

Returns:

the "default null" attribute

getDelimiter

public String getDelimiter()

Description copied from interface: Driver

Gets the default delimiter.

Specified by:

getDelimiter in interface Driver

Overrides:

getDelimiter in class AbstractDriver

Returns:

the delimiter

getEnd

public String getEnd()

Description copied from interface: Driver

Gets the "end" sql.

Specified by:

getEnd in interface Driver

Overrides:

getEnd in class MsSqlDriver

Returns:

the "end" sql

getEndSplited

public String getEndSplited()

Description copied from interface: Driver

Gets the "end" token for the splited sql statement.

Specified by:

getEndSplited in interface Driver

Overrides:

getEndSplited in class MsSqlDriver

Returns:

the the "end" token for the splited sql statement

getExplainPlan

public Object getExplainPlan(ObjectStorage storage,
                             Connection connection,
                             Alias alias,
                             String sql)

Description copied from interface: Driver

Gets the explain plan for the sql.

Specified by:

getExplainPlan in interface Driver

Overrides:

getExplainPlan in class MsSqlDriver

Parameters:

storage - the object storage

connection - the connection

alias - the alias

sql - the sql

Returns:

the explain plan

See Also:

ObjectStorage

getExternalToolName

public String getExternalToolName()

Description copied from interface: Driver

Gets the external tool name.

Specified by:

getExternalToolName in interface Driver

Overrides:

getExternalToolName in class MsSqlDriver

Returns:

the external tool name

getHome

public String getHome(ObjectStorage storage)

Description copied from interface: Driver

Gets the home folder for the native database client.

Specified by:

getHome in interface Driver

Overrides:

getHome in class MsSqlDriver

Parameters:

storage - the object storage

Returns:

the home folder

See Also:

ObjectStorage

getIconPath

public String getIconPath()

Description copied from interface: ExtensionModule

Gets the full path to the icon file. The icon reside inside package and deployed with the code in jar file.

Specified by:

getIconPath in interface ExtensionModule

Overrides:

getIconPath in class MsSqlDriver

Returns:

the icon path

getJdbcDriverClassName

public String getJdbcDriverClassName()

Description copied from interface: Driver

Gets the jdbc driver class name.

Specified by:

getJdbcDriverClassName in interface Driver

Overrides:

getJdbcDriverClassName in class MsSqlDriver

Returns:

the jdbc driver class name

getLicensePropertyName

public String getLicensePropertyName()

Description copied from interface: ExtensionModule

Gets the name of the license property. If not null the model is a subject of licensing.

Specified by:

getLicensePropertyName in interface ExtensionModule

Overrides:

getLicensePropertyName in class MsSqlDriver

Returns:

the name of the license property

getMetadataClassName

public String getMetadataClassName()

Description copied from interface: Driver

Gets the metadata driver class name.

Specified by:

getMetadataClassName in interface Driver

Overrides:

getMetadataClassName in class MsSqlDriver

Returns:

the metadata driver class name

getName

public String getName()

Description copied from interface: Driver

Gets the name of the driver.

Specified by:

getName in interface Driver

Overrides:

getName in class MsSqlDriver

Returns:

the name of the driver

getObjectCheckSql

public String getObjectCheckSql(String name)

Description copied from interface: Driver

Gets the sql used to check if object exists.

Specified by:

getObjectCheckSql in interface Driver

Overrides:

getObjectCheckSql in class AbstractDriver

Parameters:

name - the name

Returns:

the sql

getOnException

public String getOnException(OnException onException)

Description copied from interface: Driver

Gets the "on exception" sql.

Specified by:

getOnException in interface Driver

Overrides:

getOnException in class MsSqlDriver

Parameters:

onException - the OnException

Returns:

the "on exception" sql

See Also:

OnException

getOnExceptionBegin

public String getOnExceptionBegin(OnException onException,
                                  long row)

Description copied from interface: Driver

Gets the "on exception begin" sql.

Specified by:

getOnExceptionBegin in interface Driver

Overrides:

getOnExceptionBegin in class MsSqlDriver

Parameters:

onException - the OnException

row - the row

Returns:

the "on exception begin" sql

See Also:

OnException

getOnExceptionEnd

public String getOnExceptionEnd()

Description copied from interface: Driver

Gets the "on exception end" sql.

Specified by:

getOnExceptionEnd in interface Driver

Overrides:

getOnExceptionEnd in class MsSqlDriver

Returns:

the "on exception end" sql

getProperties

public String[] getProperties()

Description copied from interface: Driver

Gets the properties.

Specified by:

getProperties in interface Driver

Overrides:

getProperties in class MsSqlDriver

Returns:

the properties

getPropsWizardResource

public String getPropsWizardResource(String connectionDriver)

Description copied from interface: Driver

Gets the name of the xml file used to create a wizard for editing properties.

Specified by:

getPropsWizardResource in interface Driver

Overrides:

getPropsWizardResource in class MsSqlDriver

Parameters:

connectionDriver - the connection driver

Returns:

the name of the xml file

getSafeSql

public String getSafeSql(String sql)

Description copied from interface: Driver

Gets the safe sql. Some databases (Oracle for example) require that sql is executed inside special construct in order to catch exception.

 For example table abc does not exist
 
 delete from abc -- not safe
 EXECUTE IMMEDIATE 'delete from abc' -- safe
 

Specified by:

getSafeSql in interface Driver

Overrides:

getSafeSql in class MsSqlDriver

Parameters:

sql - the name

Returns:

the safe sql

getSqlForExternalTool

public String getSqlForExternalTool(Alias alias,
                                    String sql,
                                    SqlParser parser)

Description copied from interface: Driver

Gets the sql for external tool.

Specified by:

getSqlForExternalTool in interface Driver

Overrides:

getSqlForExternalTool in class MsSqlDriver

Parameters:

alias - the alias

sql - the original sql

parser - the sql parser

Returns:

the sql for the external tool

getSqlKeywordsFileName

public String getSqlKeywordsFileName()

Description copied from interface: Driver

Gets the sql keywords file name.

Specified by:

getSqlKeywordsFileName in interface Driver

Overrides:

getSqlKeywordsFileName in class MsSqlDriver

Returns:

the sql keywords file name

getTempTableName

public String getTempTableName(String name)

Description copied from interface: Driver

Gets the temporary table name.

Specified by:

getTempTableName in interface Driver

Overrides:

getTempTableName in class MsSqlDriver

Parameters:

name - the name

Returns:

the temporary table name

getType

public String getType(FieldDef fieldDef,
                      String key,
                      FieldsRepository fieldsRepository)

Description copied from interface: Driver

Gets the native field type.

Specified by:

getType in interface Driver

Overrides:

getType in class MsSqlDriver

Parameters:

fieldDef - the field definition

key - the key field(s)

fieldsRepository - the fields repository

Returns:

the native field type

getUrlPattern

public String getUrlPattern()

Description copied from interface: Driver

Gets the jdbc driver url pattern.

Specified by:

getUrlPattern in interface Driver

Overrides:

getUrlPattern in class MsSqlDriver

Returns:

the jdbc driver url pattern

getVendor

public String getVendor()

Description copied from interface: ExtensionModule

Gets the vendor.

Specified by:

getVendor in interface ExtensionModule

Overrides:

getVendor in class MsSqlDriver

Returns:

the vendor

getVersion

public String getVersion()

Description copied from interface: ExtensionModule

Gets the version of the extension module.

Specified by:

getVersion in interface ExtensionModule

Overrides:

getVersion in class MsSqlDriver

Returns:

the version

getXmlConfigFileName

public String getXmlConfigFileName()

Description copied from interface: ExtensionModule

Gets the path to the xml configuration file for the module. The xml configuration file usually contains module specific UI elements, resides inside package and deployed with the code in the jar file.

Specified by:

getXmlConfigFileName in interface ExtensionModule

Overrides:

getXmlConfigFileName in class MsSqlDriver

Returns:

the path to the configuration name

needSeparateConnectionForDdl

public boolean needSeparateConnectionForDdl()

Description copied from interface: Driver

Check if driver requires separate connection for ddl statements.

Specified by:

needSeparateConnectionForDdl in interface Driver

Overrides:

needSeparateConnectionForDdl in class AbstractDriver

Returns:

true, if driver requires separate connection for ddl statements

requiresExecuteQuery

public boolean requiresExecuteQuery()

Description copied from interface: Driver

Checks if driver requires to run as st.executeQuery() in some cases.

Specified by:

requiresExecuteQuery in interface Driver

Overrides:

requiresExecuteQuery in class AbstractDriver

Returns:

true, if driver requires to run as st.executeQuery()

requiresSeparateConnectionForIndexes

public boolean requiresSeparateConnectionForIndexes()

Description copied from interface: Driver

Checks if driver requires separate connection for indexes.

Specified by:

requiresSeparateConnectionForIndexes in interface Driver

Overrides:

requiresSeparateConnectionForIndexes in class AbstractDriver

Returns:

true, if driver requires separate connection for indexes

supportsAnonymousBlocks

public boolean supportsAnonymousBlocks()

Description copied from interface: Driver

"Supports anonymous blocks" flag.

Specified by:

supportsAnonymousBlocks in interface Driver

Overrides:

supportsAnonymousBlocks in class MsSqlDriver

Returns:

true, if database supports anonymous sql blocks

supportsRollbackAfterDDL

public boolean supportsRollbackAfterDDL()

Description copied from interface: Driver

"Supports rollback after ddl" flag.

Specified by:

supportsRollbackAfterDDL in interface Driver

Overrides:

supportsRollbackAfterDDL in class MsSqlDriver

Returns:

true, if database supports rollback after ddl

typeHasSize

public boolean typeHasSize(int type,
                           String nativeDataType)

Description copied from interface: Driver

Returns true if type has size. For example: Types.VARCHAR has size, Types.INTEGER - doesn't.

Specified by:

typeHasSize in interface Driver

Overrides:

typeHasSize in class AbstractDriver

Parameters:

type - the type Types

nativeDataType - the natice data type

Returns:

true, if type has size