Class SQLExportConfigurationSpec
java.lang.Object
com.orchestranetworks.addon.dex.configuration.SQLExportConfigurationSpec
- All Implemented Interfaces:
ConfigurationSpec<EBXTable>
,ExportConfigurationSpec<EBXTable>
public final class SQLExportConfigurationSpec
extends Object
implements ExportConfigurationSpec<EBXTable>
Defines the configuration used to export data to an external database.
- Since:
- 2.3.0
-
Constructor Summary
ConstructorDescriptionSQLExportConfigurationSpec
(com.onwbp.adaptation.Adaptation recordOrDataset, List<EBXTable> sourceTables, JNDIDataSource jndiDataSource, com.orchestranetworks.service.Session session) Exports multiple tables withJNDIDataSource
outside of aUIService
.SQLExportConfigurationSpec
(com.onwbp.adaptation.Adaptation recordOrDataset, List<EBXTable> sourceTables, String sqlDataSourceName, com.orchestranetworks.service.Session session) Exports multiple tables outside of aUIService
.SQLExportConfigurationSpec
(com.onwbp.adaptation.Adaptation dataset, List<EBXTable> sourceTables, Map<EBXTable, TableFilter> tableFilters, JNDIDataSource jndiDataSource, com.orchestranetworks.service.Session session) Exports multiple tables with a filter andJNDIDataSource
outside of aUIService
.SQLExportConfigurationSpec
(com.onwbp.adaptation.Adaptation dataset, List<EBXTable> sourceTables, Map<EBXTable, TableFilter> tableFilters, String sqlDataSourceName, com.orchestranetworks.service.Session session) Exports multiple tables with a filter outside of aUIService
.SQLExportConfigurationSpec
(com.onwbp.adaptation.AdaptationTable currentTable, JNDIDataSource jndiDataSource, com.orchestranetworks.service.Session session) Exports a table withJNDIDataSource
outside of aUIService
.SQLExportConfigurationSpec
(com.onwbp.adaptation.AdaptationTable currentTable, TableFilter tableFilter, JNDIDataSource jndiDataSource, com.orchestranetworks.service.Session session) Exports a table with filter andJNDIDataSource
outside of aUIService
.SQLExportConfigurationSpec
(com.onwbp.adaptation.AdaptationTable currentTable, TableFilter tableFilter, String sqlDataSourceName, com.orchestranetworks.service.Session session) Exports a table with filter outside of aUIService
.SQLExportConfigurationSpec
(com.onwbp.adaptation.AdaptationTable currentTable, String sqlDataSourceName, com.orchestranetworks.service.Session session) Exports a table outside of aUIService
.SQLExportConfigurationSpec
(com.orchestranetworks.service.ServiceContext serviceContext, JNDIDataSource jndiDataSource) Exports a table withJNDIDataSource
within aUIService
.SQLExportConfigurationSpec
(com.orchestranetworks.service.ServiceContext serviceContext, String sqlDataSourceName) Exports a table within aUIService
. -
Method Summary
Modifier and TypeMethodDescriptioncom.onwbp.adaptation.Adaptation
Returns the current dataset.com.onwbp.adaptation.AdaptationTable
Returns the current table.Returns the map of theFieldMapperDefinition
implementations and aTableMapping
instance as the key parameter.Returns the specified JNDI data source for SQL export.Returns the the specified schema name.Returns the service type.com.orchestranetworks.service.Session
Returns the current session.Returns a map of table filters and an instance ofEBXTable
as the key parameter.Returns the list of source tables.Returns the SQL data source name.Returns the import mode.Returns the specified table naming pattern.boolean
Returnstrue
if the exported data contains computed values.boolean
Deprecated.Since 3.0.0, the 'Disable write access lock' option was removed from the add-on.void
setComputedValueIncluded
(boolean computedValueIncluded) Sets whether to include computed values in the exported data.void
setFieldMapperDefinitions
(Map<TableMapping, FieldMapperDefinition> fieldMapperDefinitions) Sets a map of theFieldMapperDefinition
implementations and aTableMapping
instance as the key parameter.void
setSchemaName
(String schemaName) Sets the the specified schema name.void
setSQLImportMode
(ImportMode sqlImportMode) Sets the import mode.void
setTablePattern
(String tablePattern) Sets a table naming pattern.void
setWriteAccessLockDisabled
(boolean writeAccessLockDisabled) Deprecated.Since 3.0.0, the 'Disable write access lock' option was removed from the add-on.
-
Constructor Details
-
SQLExportConfigurationSpec
public SQLExportConfigurationSpec(com.orchestranetworks.service.ServiceContext serviceContext, String sqlDataSourceName) throws DataExchangeException Exports a table within aUIService
.- Throws:
DataExchangeException
-
SQLExportConfigurationSpec
public SQLExportConfigurationSpec(com.orchestranetworks.service.ServiceContext serviceContext, JNDIDataSource jndiDataSource) throws DataExchangeException Exports a table withJNDIDataSource
within aUIService
.- Throws:
DataExchangeException
- Since:
- 2.5.0
-
SQLExportConfigurationSpec
public SQLExportConfigurationSpec(com.onwbp.adaptation.AdaptationTable currentTable, String sqlDataSourceName, com.orchestranetworks.service.Session session) throws DataExchangeException Exports a table outside of aUIService
.- Throws:
DataExchangeException
-
SQLExportConfigurationSpec
public SQLExportConfigurationSpec(com.onwbp.adaptation.AdaptationTable currentTable, JNDIDataSource jndiDataSource, com.orchestranetworks.service.Session session) throws DataExchangeException Exports a table withJNDIDataSource
outside of aUIService
.- Throws:
DataExchangeException
- Since:
- 2.5.0
-
SQLExportConfigurationSpec
public SQLExportConfigurationSpec(com.onwbp.adaptation.AdaptationTable currentTable, TableFilter tableFilter, String sqlDataSourceName, com.orchestranetworks.service.Session session) throws DataExchangeException Exports a table with filter outside of aUIService
.- Throws:
DataExchangeException
-
SQLExportConfigurationSpec
public SQLExportConfigurationSpec(com.onwbp.adaptation.AdaptationTable currentTable, TableFilter tableFilter, JNDIDataSource jndiDataSource, com.orchestranetworks.service.Session session) throws DataExchangeException Exports a table with filter andJNDIDataSource
outside of aUIService
.- Throws:
DataExchangeException
- Since:
- 2.5.0
-
SQLExportConfigurationSpec
public SQLExportConfigurationSpec(com.onwbp.adaptation.Adaptation recordOrDataset, List<EBXTable> sourceTables, String sqlDataSourceName, com.orchestranetworks.service.Session session) throws DataExchangeException Exports multiple tables outside of aUIService
.- Throws:
DataExchangeException
-
SQLExportConfigurationSpec
public SQLExportConfigurationSpec(com.onwbp.adaptation.Adaptation recordOrDataset, List<EBXTable> sourceTables, JNDIDataSource jndiDataSource, com.orchestranetworks.service.Session session) throws DataExchangeException Exports multiple tables withJNDIDataSource
outside of aUIService
.- Throws:
DataExchangeException
- Since:
- 2.5.0
-
SQLExportConfigurationSpec
public SQLExportConfigurationSpec(com.onwbp.adaptation.Adaptation dataset, List<EBXTable> sourceTables, Map<EBXTable, TableFilter> tableFilters, String sqlDataSourceName, com.orchestranetworks.service.Session session) throws DataExchangeExceptionExports multiple tables with a filter outside of aUIService
.- Throws:
DataExchangeException
-
SQLExportConfigurationSpec
public SQLExportConfigurationSpec(com.onwbp.adaptation.Adaptation dataset, List<EBXTable> sourceTables, Map<EBXTable, TableFilter> tableFilters, JNDIDataSource jndiDataSource, com.orchestranetworks.service.Session session) throws DataExchangeExceptionExports multiple tables with a filter andJNDIDataSource
outside of aUIService
.- Throws:
DataExchangeException
- Since:
- 2.5.0
-
-
Method Details
-
isComputedValueIncluded
public boolean isComputedValueIncluded()Returnstrue
if the exported data contains computed values.- Specified by:
isComputedValueIncluded
in interfaceExportConfigurationSpec<EBXTable>
-
setComputedValueIncluded
public void setComputedValueIncluded(boolean computedValueIncluded) Sets whether to include computed values in the exported data. -
getServiceType
Returns the service type.- Specified by:
getServiceType
in interfaceConfigurationSpec<EBXTable>
-
isWriteAccessLockDisabled
public boolean isWriteAccessLockDisabled()Deprecated.Since 3.0.0, the 'Disable write access lock' option was removed from the add-on.Always throws exception.- Specified by:
isWriteAccessLockDisabled
in interfaceExportConfigurationSpec<EBXTable>
-
setWriteAccessLockDisabled
public void setWriteAccessLockDisabled(boolean writeAccessLockDisabled) Deprecated.Since 3.0.0, the 'Disable write access lock' option was removed from the add-on.Always throws exception. -
getSQLImportMode
Returns the import mode. -
setSQLImportMode
Sets the import mode. -
getCurrentDataset
public com.onwbp.adaptation.Adaptation getCurrentDataset()Returns the current dataset.- Specified by:
getCurrentDataset
in interfaceConfigurationSpec<EBXTable>
-
getCurrentTable
public com.onwbp.adaptation.AdaptationTable getCurrentTable()Returns the current table.- Specified by:
getCurrentTable
in interfaceConfigurationSpec<EBXTable>
-
getSession
public com.orchestranetworks.service.Session getSession()Returns the current session.- Specified by:
getSession
in interfaceConfigurationSpec<EBXTable>
-
getSourceTables
Returns the list of source tables.- Specified by:
getSourceTables
in interfaceConfigurationSpec<EBXTable>
-
getSourceTableFilters
Returns a map of table filters and an instance ofEBXTable
as the key parameter. Returnsnull
when importing CSV, Excel and XML.- Specified by:
getSourceTableFilters
in interfaceConfigurationSpec<EBXTable>
-
getSQLDataSourceName
Returns the SQL data source name. -
getFieldMapperDefinitions
Returns the map of theFieldMapperDefinition
implementations and aTableMapping
instance as the key parameter. -
setFieldMapperDefinitions
public void setFieldMapperDefinitions(Map<TableMapping, FieldMapperDefinition> fieldMapperDefinitions) Sets a map of theFieldMapperDefinition
implementations and aTableMapping
instance as the key parameter. -
getTablePattern
Returns the specified table naming pattern. -
setTablePattern
Sets a table naming pattern. -
getSchemaName
Returns the the specified schema name. -
setSchemaName
Sets the the specified schema name. -
getJNDIDataSource
Returns the specified JNDI data source for SQL export.- Since:
- 2.5.0
-