Package net.simplace.pipe.processors

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. 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.

Author:

Andreas Enders

Field Summary

Fields inherited from class net.simplace.pipe.control.FWProcessor

iAllreadyLoopedCount, iContainer, iInObservable, iObservable, iProgressTasks

Constructor Summary

Constructors

Constructor	Description
AsciiToDatabaseTableProcessor()

Method Summary

Modifier and Type	Method	Description
boolean	checkInParameterMap()	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

Methods inherited from class java.lang.Object

equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

AsciiToDatabaseTableProcessor

public AsciiToDatabaseTableProcessor()

Method Details

process

protected boolean process()
                   throws PipeLineException

Description copied from class: FWProcessor

Must be overridden to implement concrete pipe procedure.

Specified by:

process in class FWProcessor

Returns:

success

Throws:

PipeLineException

checkInParameterMap

public boolean checkInParameterMap()

Checks whether the in-channel contains all required parameters.

Overrides:

checkInParameterMap in class FWProcessor

Returns:

true if not overridden by implementations