Class AsciiToDatabaseTableProcessor

java.lang.Object
net.simplace.pipe.control.FWProcessor
net.simplace.pipe.processors.AsciiToDatabaseTableProcessor

public class AsciiToDatabaseTableProcessor extends FWProcessor
This processor transforms data from an ASCII file into the database.
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)
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 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