com.toolsverse.etl.connector.sql

Class SqlConnector

Object

com.toolsverse.ext.BaseExtension

com.toolsverse.etl.connector.BaseDataSetConnector

com.toolsverse.etl.connector.sql.SqlConnector

All Implemented Interfaces:

DataSetConnector<SqlConnectorParams,ConnectorResult>, ExtensionModule, Serializable, Comparable<ExtensionModule>

public class SqlConnector
extends BaseDataSetConnector
implements DataSetConnector<SqlConnectorParams,ConnectorResult>

Reads data from the database using jdbc, creates insert sql statements. Supports data streaming.

Since:

2.0

Version:

2.0

See Also:

Serialized Form

Field Summary

Fields inherited from class com.toolsverse.etl.connector.BaseDataSetConnector

DEFAULT_IMPORT

Fields inherited from interface com.toolsverse.ext.ExtensionModule

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

Constructor Summary

Constructors

Constructor and Description
SqlConnector()

Method Summary

Modifier and Type	Method and Description
boolean	canRead() Checks if connector can read data.
boolean	canWrite() Checks if connector can write data.
void	cleanUp(SqlConnectorParams params, DataSet dataSet, Driver driver) Cleans up after DataSetConnector populated or persisted DataSet.
SqlConnectorParams	getDataSetConnectorParams() Gets the DataSetConnectorParams.
String	getDisplayName() Gets the display name.
String	getName() Gets the name.
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	initQueryLabel() The init query label.
void	inlinePersist(SqlConnectorParams params, DataSet dataSet, Driver driver, DataSetRecord record, int row, int records) Persists data set row.
boolean	isFileConnector() Checks if this is a connector to the file based data source.
boolean	isTextFormat() Checks if this is a connector for the text-based data format, such as JOSN, XML, etc.
ConnectorResult	persist(SqlConnectorParams params, DataSet dataSet, Driver driver) Persists data set.
ConnectorResult	populate(SqlConnectorParams params, DataSet dataSet, Driver driver) Populates data set.
void	postPersist(SqlConnectorParams params, DataSet dataSet, Driver driver) Called when DataSetConnector finished persisting data set.
void	prePersist(SqlConnectorParams params, DataSet dataSet, Driver driver) Called when DataSetConnector starts persisting data set.
boolean	supportsNested() Supports nested.
boolean	supportsReadStreaming() Supports read streaming.
boolean	supportsWriteStreaming() Supports write streaming.
String	testConnection(ConnectionParams connectionParams) Test connection.
ConnectorResult	writeMetaData(SqlConnectorParams params, DataSet dataSet, Driver driver) Writes meta data.

Methods inherited from class com.toolsverse.etl.connector.BaseDataSetConnector

addValue, basePostPersist, getCommitPolicy, getExt, getInputStream, getIoProcessor, getLicensePropertyName, getReader, getType, postPersistWhenEmpty, setCommitPolicy, stream, supportsWorksheets

Methods inherited from class com.toolsverse.ext.BaseExtension

compareTo, getConfigFileName, getExtensionRank, getIconPath, getLocalUnitClassPath

Methods inherited from class Object

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

Methods inherited from interface com.toolsverse.etl.connector.DataSetConnector

getExt, supportsReordering, supportsWorksheets

Constructor Detail

SqlConnector

public SqlConnector()

Method Detail

canRead

public boolean canRead()

Description copied from interface: DataSetConnector

Checks if connector can read data.

Specified by:

canRead in interface DataSetConnector<SqlConnectorParams,ConnectorResult>

Returns:

true, if connector can read data

canWrite

public boolean canWrite()

Description copied from interface: DataSetConnector

Checks if connector can write data.

Specified by:

canWrite in interface DataSetConnector<SqlConnectorParams,ConnectorResult>

Returns:

true, if connector can write data

cleanUp

public void cleanUp(SqlConnectorParams params,
                    DataSet dataSet,
                    Driver driver)
             throws Exception

Description copied from interface: DataSetConnector

Cleans up after DataSetConnector populated or persisted DataSet. Called regardless of exception. Usually used to free allocated resources such as streams, handlers, etc.

Specified by:

cleanUp in interface DataSetConnector<SqlConnectorParams,ConnectorResult>

Parameters:

params - the DataSetConnectorParams

dataSet - the data set

driver - the driver

Throws:

Exception - in case of any error

getDataSetConnectorParams

public SqlConnectorParams getDataSetConnectorParams()

Description copied from interface: DataSetConnector

Gets the DataSetConnectorParams.

Specified by:

getDataSetConnectorParams in interface DataSetConnector<SqlConnectorParams,ConnectorResult>

Returns:

the DataSetConnectorParams

getDisplayName

public String getDisplayName()

Description copied from interface: ExtensionModule

Gets the display name. This name will be used to display module in the various UI controls.

Specified by:

getDisplayName in interface ExtensionModule

Returns:

the display name

getName

public String getName()

Description copied from interface: DataSetConnector

Gets the name.

Specified by:

getName in interface DataSetConnector<SqlConnectorParams,ConnectorResult>

Returns:

the name

getVendor

public String getVendor()

Description copied from interface: ExtensionModule

Gets the vendor.

Specified by:

getVendor in interface ExtensionModule

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

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 BaseExtension

Returns:

the path to the configuration name

inlinePersist

public void inlinePersist(SqlConnectorParams params,
                          DataSet dataSet,
                          Driver driver,
                          DataSetRecord record,
                          int row,
                          int records)
                   throws Exception

Description copied from interface: DataSetConnector

Persists data set row. For example adds line to the text file.

Specified by:

inlinePersist in interface DataSetConnector<SqlConnectorParams,ConnectorResult>

Parameters:

params - the DataSetConnectorParams

dataSet - the data set

driver - the driver

record - the record

row - the row

records - the total number of records

Throws:

Exception - in case of any error

isFileConnector

public boolean isFileConnector()

Description copied from interface: DataSetConnector

Checks if this is a connector to the file based data source.

Specified by:

isFileConnector in interface DataSetConnector<SqlConnectorParams,ConnectorResult>

Returns:

true, if this is a connector to the file based data source.

isTextFormat

public boolean isTextFormat()

Description copied from interface: DataSetConnector

Checks if this is a connector for the text-based data format, such as JOSN, XML, etc.

Specified by:

isTextFormat in interface DataSetConnector<SqlConnectorParams,ConnectorResult>

Returns:

true, if this is a connector for the text-based data format.

persist

public ConnectorResult persist(SqlConnectorParams params,
                               DataSet dataSet,
                               Driver driver)
                        throws Exception

Description copied from interface: DataSetConnector

Persists data set.

Specified by:

persist in interface DataSetConnector<SqlConnectorParams,ConnectorResult>

Parameters:

params - the DataSetConnectorParams

dataSet - the data set

driver - the driver

Returns:

the ConnectorResult

Throws:

Exception - in case of any error

populate

public ConnectorResult populate(SqlConnectorParams params,
                                DataSet dataSet,
                                Driver driver)
                         throws Exception

Description copied from interface: DataSetConnector

Populates data set.

Specified by:

populate in interface DataSetConnector<SqlConnectorParams,ConnectorResult>

Parameters:

params - the DataSetConnectorParams

dataSet - the data set

driver - the driver

Returns:

the ConnectorResult

Throws:

Exception - in case of any error

postPersist

public void postPersist(SqlConnectorParams params,
                        DataSet dataSet,
                        Driver driver)
                 throws Exception

Description copied from interface: DataSetConnector

Called when DataSetConnector finished persisting data set. Never called if there was an exception.

Specified by:

postPersist in interface DataSetConnector<SqlConnectorParams,ConnectorResult>

Parameters:

params - the DataSetConnectorParams

dataSet - the data set

driver - the driver

Throws:

Exception - in case of any error

prePersist

public void prePersist(SqlConnectorParams params,
                       DataSet dataSet,
                       Driver driver)
                throws Exception

Description copied from interface: DataSetConnector

Called when DataSetConnector starts persisting data set.

Specified by:

prePersist in interface DataSetConnector<SqlConnectorParams,ConnectorResult>

Parameters:

params - the DataSetConnectorParams

dataSet - the data set

driver - the driver

Throws:

Exception - in case of any error

testConnection

public String testConnection(ConnectionParams connectionParams)
                      throws Exception

Description copied from class: BaseDataSetConnector

Test connection.

Specified by:

testConnection in interface DataSetConnector<SqlConnectorParams,ConnectorResult>

Overrides:

testConnection in class BaseDataSetConnector

Parameters:

connectionParams - the connection params

Returns:

the string

Throws:

Exception - the exception

writeMetaData

public ConnectorResult writeMetaData(SqlConnectorParams params,
                                     DataSet dataSet,
                                     Driver driver)
                              throws Exception

Description copied from interface: DataSetConnector

Writes meta data. For example along with delimited text file the DataSetConnector can create a xml file with the same name which contains field definitions.

Specified by:

writeMetaData in interface DataSetConnector<SqlConnectorParams,ConnectorResult>

Parameters:

params - the DataSetConnectorParams

dataSet - the data set

driver - the driver

Returns:

the ConnectorResult

Throws:

Exception - in case of any error

initQueryLabel

public String initQueryLabel()

Description copied from interface: DataSetConnector

The init query label. If not empty the init query, for example XML XQuery, will be enabled and label in editor will be set to the value of this field

Specified by:

initQueryLabel in interface DataSetConnector<SqlConnectorParams,ConnectorResult>

Returns:

the string

supportsReadStreaming

public boolean supportsReadStreaming()

Description copied from interface: DataSetConnector

Supports read streaming.

Specified by:

supportsReadStreaming in interface DataSetConnector<SqlConnectorParams,ConnectorResult>

Returns:

true, if successful

supportsWriteStreaming

public boolean supportsWriteStreaming()

Description copied from interface: DataSetConnector

Supports write streaming.

Specified by:

supportsWriteStreaming in interface DataSetConnector<SqlConnectorParams,ConnectorResult>

Returns:

true, if successful

supportsNested

public boolean supportsNested()

Description copied from interface: DataSetConnector

Supports nested.

Specified by:

supportsNested in interface DataSetConnector<SqlConnectorParams,ConnectorResult>

Returns:

true, if connector supports nested data sets