public interface LoaderCSVOptionsStep<R extends Record> extends LoaderListenerStep<R>
Loader
API is used for configuring data loads.
The step in constructing the Loader
object where you can set the
optional CSV loader options.
Modifier and Type | Method and Description |
---|---|
LoaderCSVOptionsStep<R> |
ignoreRows(int number)
Specify that a certain number of rows should be ignored from the CSV
file.
|
LoaderCSVOptionsStep<R> |
nullString(java.lang.String nullString)
Specify the input string representation of
NULL . |
LoaderCSVOptionsStep<R> |
quote(char quote)
Specify the quote character.
|
LoaderCSVOptionsStep<R> |
separator(char separator)
Specify the separator character.
|
onRow
execute
@Support LoaderCSVOptionsStep<R> ignoreRows(int number)
By default, this is set to 1
, as CSV files are expected to
hold a header row.
number
- The number of rows to ignore.@Support LoaderCSVOptionsStep<R> quote(char quote)
"
@Support LoaderCSVOptionsStep<R> separator(char separator)
,
@Support LoaderCSVOptionsStep<R> nullString(java.lang.String nullString)
NULL
.
By default, this is set to null
, which means that all empty
strings are loaded into the database as such. In some databases (e.g.
SQLDialect.ORACLE
), this is effectively the same as loading
NULL
.
In order to treat empty strings as null
, you can set the
nullString
to ""
. If the null string is
overridden with something like {null}
, for instance, then
empty strings will also be loaded as such by jOOQ.
Copyright © 2018. All Rights Reserved.