com.toolsverse.etl.driver

Class GenericOdbcDriver

Object

com.toolsverse.etl.driver.AbstractDriver

com.toolsverse.etl.driver.SimpleDriver

com.toolsverse.etl.driver.GenericOdbcDriver

All Implemented Interfaces:

Driver, ExtensionModule, Serializable, Comparable<ExtensionModule>

public class GenericOdbcDriver
extends SimpleDriver

Default ETL driver for the odbc complaint databases which does not support callable statements.

Since:

1.0

Version:

2.0

See Also:

Serialized Form

Field Summary

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

DEF_FUNCTION_CLASS, END_ON_EXCEPTION, ON_EXCEPTION

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
GenericOdbcDriver()

Method Summary

Modifier and Type	Method and Description
String	getCmdForExternalTool(ObjectStorage storage, Alias alias, String sqlFile) Gets the command line for the external tool.
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	getIconPath() Gets the full path to the icon file.
String	getJdbcDriverClassName() Gets the jdbc driver class name.
String	getMetadataClassName() Gets the metadata driver class name.
String	getName() Gets the name of the driver.
String	getPropsWizardResource(String connectionDriver) Gets the name of the xml file used to create a wizard for editing properties.
String	getSqlForExternalTool(Alias alias, String sql, SqlParser parser) Gets the sql for external tool.
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.
String[]	supportedJoinTypes() Returns supported join types, such as inner join, left outer join etc.
String[]	supportedSetOperations() Returns names of the supported set operations, such as union, union all, etc.
boolean	supportsScripts() If true the database supports extended sql, such as PLSQL, Transact SQL, etc.

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

convertStringForStorage, convertValueForStorage, deleteStagingBinary, filter, getBegin, getBeginSplited, getBlob, getCallSql, getCharUsedForColumnsWithSpaces, getClob, getCreateTableSql, getCursorLoopEndSql, getCursorLoopStartSql, getCursorRecAccessSql, getDeclare, getDeclareCursorEndSql, getDeclareCursorSql, getDeclareCursorVarSql, getDefaultFunctionClass, getDefaultType, getDelimiter, getDestinationInfo, getDropSql, getEnd, getEndSplited, getIf, getIfBegin, getIfElse, getIfEnd, getInitSql, getLinesLimit, getMaxCharSize, getMaxPrecision, getMaxScale, getMaxStringLiteralSize, getMaxVarcharSize, getMergeStatement, getMetadataSelectClause, getMetadataWhereClause, getObject, getOnException, getOnExceptionBegin, getOnExceptionEnd, getParamType, getParentDriverName, getSafeDelimiter, getTempTableName, getTopSelectClause, getTopTrailClause, getTopWhereClause, getType, getVarDeclare, getVarName, getWrongScale, ignoreExceptionsDuringInit, isMergeInNonCallableSupported, needSeparateConnectionForDdl, replaceOnException, requiresRollbackAfterSqlError, setBlob, setClob, setInitSql, setLinesLimit, setMaxCharSize, setMaxPrecision, setMaxScale, setMaxStringLiteralSize, setMaxVarcharSize, setParentDriverName, supportsAnonymousBlocks, supportsBinaryInProc, supportsCallableStatement, supportsExplainPlan, supportsExternalTool, supportsInnerFunctions, supportsParamsInAnonymousBlocks, supportsRollbackAfterDDL, updateStagingBlob, updateStagingClob, value2StorageValue

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

alwaysEncloseTableAndColumnsInQuotes, captureLog, compareTo, externalToolRequiresRedirect, getAllowedIdentifierChars, getAutotrace, getCaseSensitive, getCmdOptions, getConfigFileName, getConnectionFile, getDefaultNull, getDeleteStatement, getDisplayName, getErrorLinePattern, getExtensionRank, getHome, getIdentifierName, getIdentifierName, getInsertStatement, getLicensePropertyName, getLocalUnitClassPath, getNativeType, getObjectCheckSql, getPostDeclareSql, getProperties, getSafeSql, getSelectStatement, getSqlForAutotrace, getSqlForExplainPlan, getSqlKeywordsFileName, getStartTransactionSql, getTableName, getTablePrefixWhenAddingTable, getType, getUpdateStatement, isEqualDriver, requiresExecuteQuery, requiresSeparateConnectionForIndexes, setAlwaysEncloseTableAndColumnsInQuotes, setCaseSensitive, setUpConnection, supportColonInFormatter, supportsAutotrace, supportsLogging, supportsNotNullable, supportsParallelExtract, supportsParallelLoad, supportsParentDriver, supportsPreparedStatementInParallelThreads, supportsPreparedStatementInTransaction, tableName2Name, typeHasSize

Methods inherited from class Object

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

Constructor Detail

GenericOdbcDriver

public GenericOdbcDriver()

Method Detail

getCmdForExternalTool

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

Description copied from interface: Driver

Gets the command line for the external tool.

Parameters:

storage - the object storage

alias - the alias

sqlFile - the sql file

Returns:

the command line for the external tool

See Also:

ObjectStorage

getExplainPlan

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

Description copied from interface: Driver

Gets the explain plan for the sql.

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.

Returns:

the external tool name

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.

Returns:

the icon path

getJdbcDriverClassName

public String getJdbcDriverClassName()

Description copied from interface: Driver

Gets the jdbc driver class name.

Returns:

the jdbc driver class name

getMetadataClassName

public String getMetadataClassName()

Description copied from interface: Driver

Gets the metadata driver class name.

Returns:

the metadata driver class name

getName

public String getName()

Description copied from interface: Driver

Gets the name of the driver.

Returns:

the name of the driver

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.

Parameters:

connectionDriver - the connection driver

Returns:

the name of the xml file

getSqlForExternalTool

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

Description copied from interface: Driver

Gets the sql for external tool.

Parameters:

alias - the alias

sql - the original sql

parser - the sql parser

Returns:

the sql for the external tool

getUrlPattern

public String getUrlPattern()

Description copied from interface: Driver

Gets the jdbc driver url pattern.

Returns:

the jdbc driver url pattern

getVendor

public String getVendor()

Description copied from interface: ExtensionModule

Gets the vendor.

Returns:

the vendor

getVersion

public String getVersion()

Description copied from interface: ExtensionModule

Gets the version of the extension module.

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.

Returns:

the path to the configuration name

supportedJoinTypes

public String[] supportedJoinTypes()

Description copied from interface: Driver

Returns supported join types, such as inner join, left outer join etc.

Returns:

the supported join types

supportedSetOperations

public String[] supportedSetOperations()

Description copied from interface: Driver

Returns names of the supported set operations, such as union, union all, etc.

Returns:

the names of the supported set operations

supportsScripts

public boolean supportsScripts()

Description copied from interface: Driver

If true the database supports extended sql, such as PLSQL, Transact SQL, etc. Used by UI to disable/enable menu items.

Returns:

true, if database database supports extended sql