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
ConstructorsConstructorDescriptionSQLExportConfigurationSpec(com.onwbp.adaptation.Adaptation recordOrDataset, List<EBXTable> sourceTables, JNDIDataSource jndiDataSource, com.orchestranetworks.service.Session session) Exports multiple tables withJNDIDataSourceoutside 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 andJNDIDataSourceoutside 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 withJNDIDataSourceoutside of aUIService.SQLExportConfigurationSpec(com.onwbp.adaptation.AdaptationTable currentTable, TableFilter tableFilter, JNDIDataSource jndiDataSource, com.orchestranetworks.service.Session session) Exports a table with filter andJNDIDataSourceoutside 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 withJNDIDataSourcewithin aUIService.SQLExportConfigurationSpec(com.orchestranetworks.service.ServiceContext serviceContext, String sqlDataSourceName) Exports a table within aUIService. -
Method Summary
Modifier and TypeMethodDescriptioncom.onwbp.adaptation.AdaptationReturns the current dataset.com.onwbp.adaptation.AdaptationTableReturns the current table.Returns the map of theFieldMapperDefinitionimplementations and aTableMappinginstance 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.SessionReturns the current session.Returns a map of table filters and an instance ofEBXTableas 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.booleanReturnstrueif the exported data contains computed values.booleanDeprecated.Since 3.0.0, the 'Disable write access lock' option was removed from the add-on.voidsetComputedValueIncluded(boolean computedValueIncluded) Sets whether to include computed values in the exported data.voidsetFieldMapperDefinitions(Map<TableMapping, FieldMapperDefinition> fieldMapperDefinitions) Sets a map of theFieldMapperDefinitionimplementations and aTableMappinginstance as the key parameter.voidsetSchemaName(String schemaName) Sets the the specified schema name.voidsetSQLImportMode(ImportMode sqlImportMode) Sets the import mode.voidsetTablePattern(String tablePattern) Sets a table naming pattern.voidsetWriteAccessLockDisabled(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 withJNDIDataSourcewithin 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 withJNDIDataSourceoutside 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 andJNDIDataSourceoutside 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 withJNDIDataSourceoutside 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 andJNDIDataSourceoutside of aUIService.- Throws:
DataExchangeException- Since:
- 2.5.0
-
-
Method Details
-
isComputedValueIncluded
public boolean isComputedValueIncluded()Returnstrueif the exported data contains computed values.- Specified by:
isComputedValueIncludedin 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:
getServiceTypein 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:
isWriteAccessLockDisabledin 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:
getCurrentDatasetin interfaceConfigurationSpec<EBXTable>
-
getCurrentTable
public com.onwbp.adaptation.AdaptationTable getCurrentTable()Returns the current table.- Specified by:
getCurrentTablein interfaceConfigurationSpec<EBXTable>
-
getSession
public com.orchestranetworks.service.Session getSession()Returns the current session.- Specified by:
getSessionin interfaceConfigurationSpec<EBXTable>
-
getSourceTables
Returns the list of source tables.- Specified by:
getSourceTablesin interfaceConfigurationSpec<EBXTable>
-
getSourceTableFilters
Returns a map of table filters and an instance ofEBXTableas the key parameter. Returnsnullwhen importing CSV, Excel and XML.- Specified by:
getSourceTableFiltersin interfaceConfigurationSpec<EBXTable>
-
getSQLDataSourceName
Returns the SQL data source name. -
getFieldMapperDefinitions
Returns the map of theFieldMapperDefinitionimplementations and aTableMappinginstance as the key parameter. -
setFieldMapperDefinitions
public void setFieldMapperDefinitions(Map<TableMapping, FieldMapperDefinition> fieldMapperDefinitions) Sets a map of theFieldMapperDefinitionimplementations and aTableMappinginstance 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
-