net.simplace.pipe.processors.AsciiToDatabaseTableProcessor

This processor transforms data from an ASCII file into the database. It works in similar way as 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)
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. Added <sqlType> elements represent SQL type of appropriate field which is used for definition of the database table holding the data.


public class AsciiToDatabaseTableProcessor extends
net.simplace.pipe.control.FWProcessor {
// Public Constructors
public AsciiToDatabaseTableProcessor();

// Public Instance Methods
public boolean checkInParameterMap(); // Defines
net.simplace.pipe.control.FWProcessor

Checks whether the in-channel contains all required parameters.

// Protected Instance Methods
protected boolean process() throws PipeLineException; // Defines
net.simplace.pipe.control.FWProcessor


}



Hierarchy: java.lang.Object - net.simplace.pipe.control.FWProcessor - AsciiToDatabaseTableProcessor