Class AsciiToDatabaseTableProcessor
java.lang.Object
net.simplace.pipe.control.FWProcessor
net.simplace.pipe.processors.AsciiToDatabaseTableProcessor
This processor transforms data from an ASCII file into the database.
Furthermore following configuration is expected (as a subelement in processor element in
the configuration file) to describe the concrete data, that shall be read.
The element <data> describes the rows (header row
| Parameter | Description |
|---|---|
jdbc.driver |
(optional) JDBC driver used for the communication to the database. Default: org.hsqldb.jdbcDriver |
jdbc.url |
URL for the given JDBC driver. Default: jdbc:hsqldb:mem |
OUT: jdbc.connectionpool |
Name of the parameter, wher connectionpool is referenced. |
sourceFile |
Path or URL to input file(s) |
tablen |
lenth of tab that should be used for reading file(s) |
tablename |
Name of Table to be created |
jdbc.deletetable |
Should table be deleted (optional, default false) |
colHeadRow, rows startRow
to endRow with step, orientation); its <head> and
<value> children give the column ranges (startCol to endCol, optionally
colName and a fixed value).
Added <sqlType> elements represent SQL type of appropriate field which is used
for definition of the database table holding the data.
- Author:
- Andreas Enders
-
Field Summary
Fields inherited from class FWProcessor
iAllreadyLoopedCount, iContainer, iInObservable, iObservable, iProgressTasks -
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionbooleanChecks whether the in-channel contains all required parameters.protected booleanprocess()Must be overridden to implement the concrete processing step.Methods inherited from class FWProcessor
checkOutParameterMap, clone, containsParameter, createProcessor, createProcessor, fireTaskEvent, getAllStringInParameters, getConfiguration, getInitialParameters, getInParameter, getInParameter, getInParameters, getNewProgressTask, getOutParameter, getOutParameterKeys, getPipeLine, getProgressTask, getStringInParameter, getStringInParameter, getSystemID, hasConfiguration, isEndOfPipe, pipe, removeOutParameter, setConfiguration, setEndOfPipeFlag, setInitialParameters, setInParameterMap, setLoopedCount, setOutParameter, setStateOfTask, setStateProgressing, toXML
-
Constructor Details
-
AsciiToDatabaseTableProcessor
public AsciiToDatabaseTableProcessor()
-
-
Method Details
-
process
Description copied from class:FWProcessorMust be overridden to implement the concrete processing step. Reads from the in parameters and writes results withFWProcessor.setOutParameter(String, Object).- Specified by:
processin classFWProcessor- Returns:
trueon success;falsemakesFWProcessor.pipe(FWObservable, Integer)fail- Throws:
PipeLineException- if processing fails
-
checkInParameterMap
public boolean checkInParameterMap()Checks whether the in-channel contains all required parameters.- Overrides:
checkInParameterMapin classFWProcessor- Returns:
trueif the input is valid; the default returnstrue
-