public class SybaseDriver extends MsSqlDriver
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.
|
EXCEPTIONS, IF, IF_BEGIN, IF_ELSE, IF_END, MSSQL_HOME_PROP, MSSQL_HOME_VAR, ON_EXCEPTION, ON_EXCEPTION_BEGIN, ON_EXCEPTION_END
ALLOWED_IDENT_CHARS
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
APP, COMMAND, ETL_DRIVER, FORMATTER, IDE_NODE, NO_RANK, WIDGET
Constructor and Description |
---|
SybaseDriver() |
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. |
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
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
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
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
disableMetadataOnWrite, getIoProcessorClassName, getPrecision, ifDoesNotExistSql, ifExistsSql, openCloseConnectionOnDdl, requiresSemicolonInMerge
public static final String SYBASE_HOME_VAR
public static final String SYBASE_HOME_PROP
public static int MAX_STRING_LITERAL_SIZE
public static int MAX_VARCHAR_SIZE
public static int LINES_LIMIT
public static int MAX_CHAR_SIZE
public static int MAX_NUMBER_PREC_SIZE
public static int MAX_NUMBER_SCALE_SIZE
public static final String INIT_SQL
public static final String DECLARE
public static final String BEGIN
public static final String BEGIN_SPLITED
public static final String END
public static final String END_SPLITED
public static String getDbName(Alias alias)
alias
- the aliaspublic static String getServer(Alias alias)
alias
- the aliasprotected String _getInitSql()
CallableDriver
_getInitSql
in class MsSqlDriver
protected int _getLinesLimit()
CallableDriver
_getLinesLimit
in class MsSqlDriver
protected int _getMaxCharSize()
CallableDriver
_getMaxCharSize
in class MsSqlDriver
protected int _getMaxPrecision()
CallableDriver
_getMaxPrecision
in class MsSqlDriver
protected int _getMaxScale()
CallableDriver
_getMaxScale
in class MsSqlDriver
protected int _getMaxStringLiteralSize()
CallableDriver
_getMaxStringLiteralSize
in class MsSqlDriver
protected int _getMaxVarcharSize()
CallableDriver
_getMaxVarcharSize
in class MsSqlDriver
public String getBegin()
Driver
getBegin
in interface Driver
getBegin
in class MsSqlDriver
public String getBeginSplited()
Driver
getBeginSplited
in interface Driver
getBeginSplited
in class MsSqlDriver
public String getCallSql(String name)
Driver
getCallSql
in interface Driver
getCallSql
in class MsSqlDriver
name
- the name of the procedurepublic String getCmdForExternalTool(ObjectStorage storage, Alias alias, String sqlFile)
Driver
getCmdForExternalTool
in interface Driver
getCmdForExternalTool
in class MsSqlDriver
storage
- the object storagealias
- the aliassqlFile
- the sql fileObjectStorage
public String getCreateTableSql(String name, DataSet dataSet, boolean isTemporary, String key, FieldsRepository fieldsRepository)
Driver
getCreateTableSql
in interface Driver
getCreateTableSql
in class MsSqlDriver
name
- the table namedataSet
- the data setisTemporary
- if true the table is temporarykey
- the key field(s)fieldsRepository
- the fields repositoryFieldsRepository
public String getCursorLoopEndSql(String name, DataSet dataSet)
Driver
getCursorLoopEndSql
in interface Driver
getCursorLoopEndSql
in class MsSqlDriver
name
- the name of the cusrordataSet
- the data setpublic String getCursorLoopStartSql(String name, String cursorSql, DataSet dataSet)
Driver
getCursorLoopStartSql
in interface Driver
getCursorLoopStartSql
in class MsSqlDriver
name
- the name of the cursorcursorSql
- the cursor sqldataSet
- the data setprotected String getDateTimeStyle()
MsSqlDriver
getDateTimeStyle
in class MsSqlDriver
public String getDeclare()
Driver
getDeclare
in interface Driver
getDeclare
in class MsSqlDriver
public String getDeclareCursorSql(String sql, String name, String cursorSql, DataSet dataSet)
Driver
getDeclareCursorSql
in interface Driver
getDeclareCursorSql
in class MsSqlDriver
sql
- the sqlname
- the name of the cursorcursorSql
- the cursor sqldataSet
- the data setpublic String getDefaultFunctionClass()
Driver
getDefaultFunctionClass
in interface Driver
getDefaultFunctionClass
in class MsSqlDriver
Function
public String getDefaultNull()
Driver
getDefaultNull
in interface Driver
getDefaultNull
in class AbstractDriver
public String getDelimiter()
Driver
getDelimiter
in interface Driver
getDelimiter
in class AbstractDriver
public String getEnd()
Driver
getEnd
in interface Driver
getEnd
in class MsSqlDriver
public String getEndSplited()
Driver
getEndSplited
in interface Driver
getEndSplited
in class MsSqlDriver
public Object getExplainPlan(ObjectStorage storage, Connection connection, Alias alias, String sql)
Driver
getExplainPlan
in interface Driver
getExplainPlan
in class MsSqlDriver
storage
- the object storageconnection
- the connectionalias
- the aliassql
- the sqlObjectStorage
public String getExternalToolName()
Driver
getExternalToolName
in interface Driver
getExternalToolName
in class MsSqlDriver
public String getHome(ObjectStorage storage)
Driver
getHome
in interface Driver
getHome
in class MsSqlDriver
storage
- the object storageObjectStorage
public String getIconPath()
ExtensionModule
getIconPath
in interface ExtensionModule
getIconPath
in class MsSqlDriver
public String getJdbcDriverClassName()
Driver
getJdbcDriverClassName
in interface Driver
getJdbcDriverClassName
in class MsSqlDriver
public String getLicensePropertyName()
ExtensionModule
getLicensePropertyName
in interface ExtensionModule
getLicensePropertyName
in class MsSqlDriver
public String getMetadataClassName()
Driver
getMetadataClassName
in interface Driver
getMetadataClassName
in class MsSqlDriver
public String getName()
Driver
getName
in interface Driver
getName
in class MsSqlDriver
public String getObjectCheckSql(String name)
Driver
getObjectCheckSql
in interface Driver
getObjectCheckSql
in class AbstractDriver
name
- the namepublic String getOnException(OnException onException)
Driver
getOnException
in interface Driver
getOnException
in class MsSqlDriver
onException
- the OnExceptionOnException
public String getOnExceptionBegin(OnException onException, long row)
Driver
getOnExceptionBegin
in interface Driver
getOnExceptionBegin
in class MsSqlDriver
onException
- the OnExceptionrow
- the rowOnException
public String getOnExceptionEnd()
Driver
getOnExceptionEnd
in interface Driver
getOnExceptionEnd
in class MsSqlDriver
public String[] getProperties()
Driver
getProperties
in interface Driver
getProperties
in class MsSqlDriver
public String getPropsWizardResource(String connectionDriver)
Driver
getPropsWizardResource
in interface Driver
getPropsWizardResource
in class MsSqlDriver
connectionDriver
- the connection driverpublic String getSafeSql(String sql)
Driver
For example table abc does not exist delete from abc -- not safe EXECUTE IMMEDIATE 'delete from abc' -- safe
getSafeSql
in interface Driver
getSafeSql
in class MsSqlDriver
sql
- the namepublic String getSqlForExternalTool(Alias alias, String sql, SqlParser parser)
Driver
getSqlForExternalTool
in interface Driver
getSqlForExternalTool
in class MsSqlDriver
alias
- the aliassql
- the original sqlparser
- the sql parserpublic String getSqlKeywordsFileName()
Driver
getSqlKeywordsFileName
in interface Driver
getSqlKeywordsFileName
in class MsSqlDriver
public String getTempTableName(String name)
Driver
getTempTableName
in interface Driver
getTempTableName
in class MsSqlDriver
name
- the namepublic String getType(FieldDef fieldDef, String key, FieldsRepository fieldsRepository)
Driver
getType
in interface Driver
getType
in class MsSqlDriver
fieldDef
- the field definitionkey
- the key field(s)fieldsRepository
- the fields repositorypublic String getUrlPattern()
Driver
getUrlPattern
in interface Driver
getUrlPattern
in class MsSqlDriver
public String getVendor()
ExtensionModule
getVendor
in interface ExtensionModule
getVendor
in class MsSqlDriver
public String getVersion()
ExtensionModule
getVersion
in interface ExtensionModule
getVersion
in class MsSqlDriver
public String getXmlConfigFileName()
ExtensionModule
getXmlConfigFileName
in interface ExtensionModule
getXmlConfigFileName
in class MsSqlDriver
public boolean needSeparateConnectionForDdl()
Driver
needSeparateConnectionForDdl
in interface Driver
needSeparateConnectionForDdl
in class AbstractDriver
public boolean requiresExecuteQuery()
Driver
requiresExecuteQuery
in interface Driver
requiresExecuteQuery
in class AbstractDriver
public boolean requiresSeparateConnectionForIndexes()
Driver
requiresSeparateConnectionForIndexes
in interface Driver
requiresSeparateConnectionForIndexes
in class AbstractDriver
public boolean supportsAnonymousBlocks()
Driver
supportsAnonymousBlocks
in interface Driver
supportsAnonymousBlocks
in class MsSqlDriver
public boolean supportsRollbackAfterDDL()
Driver
supportsRollbackAfterDDL
in interface Driver
supportsRollbackAfterDDL
in class MsSqlDriver
public boolean typeHasSize(int type, String nativeDataType)
Driver
true
if type
has size. For example:
Types.VARCHAR has size, Types.INTEGER - doesn't.typeHasSize
in interface Driver
typeHasSize
in class AbstractDriver
type
- the type Types
nativeDataType
- the natice data typeCopyright © 2010-2020 Toolsverse. All Rights Reserved.