Package net.simplace.pipe.processors
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.
It works in similar way as
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 meaning of all elements and their attributes are the same as in
DatasetLoaderProcessor
.
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) |
DatasetLoaderProcessor
.
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 net.simplace.pipe.control.FWProcessor
iAllreadyLoopedCount, iContainer, iInObservable, iObservable, iProgressTasks
-
Constructor Summary
-
Method Summary
Modifier and TypeMethodDescriptionboolean
Checks whether the in-channel contains all required parameters.protected boolean
process()
Must be overridden to implement concrete pipe procedure.Methods inherited from class net.simplace.pipe.control.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:FWProcessor
Must be overridden to implement concrete pipe procedure.- Specified by:
process
in classFWProcessor
- Returns:
- success
- Throws:
PipeLineException
-
checkInParameterMap
public boolean checkInParameterMap()Checks whether the in-channel contains all required parameters.- Overrides:
checkInParameterMap
in classFWProcessor
- Returns:
- true if not overridden by implementations
-