Home

Text JDBC

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.

Functions supported

• CSV and fixed field streams
• File, input stream inputs
• Properties file definition supported
• SQL Syntax query
• Sort, filter and groupping capabilities

Dependencies

Compressed Rowset
Javex

Connection Properties

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