Parameter
class = de.isdss.util.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.
