public class GenericFileDriver extends SimpleDriver
DEF_FUNCTION_CLASS, END_ON_EXCEPTION, ON_EXCEPTION
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 |
---|
GenericFileDriver() |
Modifier and Type | Method and Description |
---|---|
String |
convertStringForStorage(String value)
Converts string so it can be used as s part of sql.
|
String |
convertValueForStorage(Object fieldValue,
int fieldType,
boolean isFromTable)
Converts value to string depending on
fieldType so it can be
used as s part of sql. |
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 |
getTableName(String name)
Gets the table name.
|
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 |
supportsIndexes()
Supports indexes.
|
boolean |
supportsParallelExtract()
"Supports parallel extract" flag.
|
boolean |
supportsParallelLoad()
"Supports parallel load" flag.
|
boolean |
supportsScripts()
If true the database supports extended sql, such as PLSQL, Transact SQL,
etc.
|
Object |
value2StorageValue(int fieldType,
Object value,
Map<String,String> params,
boolean booleanToNumber)
Converts value for storage.
|
deleteStagingBinary, filter, getAddColumnSql, getAlterTableAddColumnSql, 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, getParentDriver, getParentDriverName, getPrecision, 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
alwaysEncloseTableAndColumnsInQuotes, captureLog, compareTo, externalToolRequiresRedirect, getAllowedIdentifierChars, getAlterTableAddColumnSql, getAutotrace, getCaseSensitive, getCmdOptions, getColumns, getConfigFileName, getConnectionFile, getDefaultNull, getDeleteStatement, getDisplayName, getErrorLinePattern, getExtensionRank, getHome, getIdentifierName, getIdentifierName, getInsertStatement, getLicensePropertyName, getLocalUnitClassPath, getNativeType, getObjectCheckSql, getPostDeclareSql, getProperties, getSafeSql, getSelectStatement, getSqlForAutotrace, getSqlForExplainPlan, getSqlKeywordsFileName, getStartTransactionSql, getStringFieldSizeMultiplier, getTablePrefixWhenAddingTable, getType, getUpdateStatement, isEqualDriver, requiresExecuteQuery, requiresSeparateConnectionForIndexes, setAlwaysEncloseTableAndColumnsInQuotes, setCaseSensitive, setStringFieldSizeMultiplier, setUpConnection, supportColonInFormatter, supportsAutotrace, supportsLogging, supportsNotNullable, supportsParentDriver, supportsPreparedStatement, supportsPreparedStatementInParallelThreads, supportsPreparedStatementInTransaction, tableName2Name, typeHasSize
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
disableMetadataOnWrite, getIoProcessorClassName, ifDoesNotExistSql, ifExistsSql, openCloseConnectionOnDdl, requiresSemicolonInMerge
public String convertStringForStorage(String value)
Driver
convertStringForStorage
in interface Driver
convertStringForStorage
in class SimpleDriver
value
- the valuepublic String convertValueForStorage(Object fieldValue, int fieldType, boolean isFromTable)
Driver
fieldType
so it can be
used as s part of sql.convertValueForStorage
in interface Driver
convertValueForStorage
in class SimpleDriver
fieldValue
- the field valuefieldType
- the field type Types
}isFromTable
- if true the value is coming from result set, otherwise - from
the database cursorpublic String getCmdForExternalTool(ObjectStorage storage, Alias alias, String sqlFile)
Driver
storage
- the object storagealias
- the aliassqlFile
- the sql fileObjectStorage
public Object getExplainPlan(ObjectStorage storage, Connection connection, Alias alias, String sql)
Driver
storage
- the object storageconnection
- the connectionalias
- the aliassql
- the sqlObjectStorage
public String getExternalToolName()
Driver
public String getIconPath()
ExtensionModule
public String getJdbcDriverClassName()
Driver
public String getMetadataClassName()
Driver
public String getName()
Driver
public String getPropsWizardResource(String connectionDriver)
Driver
connectionDriver
- the connection driverpublic String getSqlForExternalTool(Alias alias, String sql, SqlParser parser)
Driver
alias
- the aliassql
- the original sqlparser
- the sql parserpublic String getTableName(String name)
Driver
getTableName
in interface Driver
getTableName
in class AbstractDriver
name
- the namepublic String getUrlPattern()
Driver
public String getVendor()
ExtensionModule
public String getVersion()
ExtensionModule
public String getXmlConfigFileName()
ExtensionModule
public String[] supportedJoinTypes()
Driver
public String[] supportedSetOperations()
Driver
public boolean supportsParallelExtract()
Driver
supportsParallelExtract
in interface Driver
supportsParallelExtract
in class AbstractDriver
public boolean supportsParallelLoad()
Driver
supportsParallelLoad
in interface Driver
supportsParallelLoad
in class AbstractDriver
public boolean supportsScripts()
Driver
public boolean supportsIndexes()
Driver
public Object value2StorageValue(int fieldType, Object value, Map<String,String> params, boolean booleanToNumber)
Driver
value2StorageValue
in interface Driver
value2StorageValue
in class SimpleDriver
fieldType
- the field type Types
value
- the valueparams
- the parametersbooleanToNumber
- if true convert boolean true/false to 1/0Copyright © 2010-2020 Toolsverse. All Rights Reserved.