Text JDBC is a plain text JDBC driver.
With it, you can manage CSV and fixed field size inputs and query them with SQL syntax.
Its support file or stream inputs (ie: strings) in csv or fixed size format.
The connection URL must be the source file folder without leading slash
ex: C:/temp
type = Input style. Supported: csv , fixed
source = Input type. Supported: stream , file
column-types = Data columns types (comma separated). Supported: String, Long, Integer, Boolean , Date, Time, TimeStamp, Short
column-names = Data columns names (comma separated).
column-sizes = Data column size (comma separated) for fixed field size input
header-names = First line are column names. Supported: true , false
use-file-definition = If headers name, col types & sizes are in .def file. Supported: true , false
delimiter = Fields & names delimiter
separator = Fields & names separator
use-row-delimiter = if use row delimiter for fixed field size type. Supported: true , false
Wiki: CSV Configuration
Wiki: Definition File
Wiki: Fixed Configuration
Wiki: Input Stream Configuration