Klasse 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.
Autor:
Andreas Enders
  • Konstruktordetails

    • AsciiToDatabaseTableProcessor

      public AsciiToDatabaseTableProcessor()
  • Methodendetails

    • process

      protected boolean process() throws PipeLineException
      Beschreibung aus Klasse kopiert: FWProcessor
      Must be overridden to implement concrete pipe procedure.
      Angegeben von:
      process in Klasse FWProcessor
      Gibt zurück:
      success
      Löst aus:
      PipeLineException
    • checkInParameterMap

      public boolean checkInParameterMap()
      Checks whether the in-channel contains all required parameters.
      Setzt außer Kraft:
      checkInParameterMap in Klasse FWProcessor
      Gibt zurück:
      true if not overridden by implementations