...
Short Option | Long Option | Parameter Value Map | Description | Required |
---|---|---|---|---|
d | driver | JDBC_DRIVER | jdbc driver class | true |
c | connection | JDBC_CONN | jdbc connection string | true |
u | username | USERNAME | database username | true |
p | password | PASSWORD | database password | true |
o | output | CONFIG_FILE | config file for output record handler | true |
O | outputOverride | VALUE | override the RH_PARAM of output record handler using VALUE | false |
t | tableName | TABLE_NAME | a single database table name [have multiple -t for more table names] | false |
Q | query | SQL_QUERY | use SQL_QUERY to select from TABLE_NAME | false |
I | id | ID_FIELD_LIST | use columns in ID_FIELD_LIST [comma separated] as identifier for TABLE_NAME | false |
F | fields | FIELD_LIST | fetch columns in FIELD_LIST comms [comma separated] for TABLE_NAME | false |
R | relations | RELATION_PAIR_LIST | fetch columns in RELATION_PAIR_LIST [comma separated] for TABLE_NAME | false |
W | whereClause | CLAUSE_LIST | filter TABLE_NAME records based on conditions in CLAUSE_LIST [comma separated] | false |
T | tableFromClause | TABLE_LIST | add tables to use in from clauses for TABLE_NAME | false |
| delimiterPrefix | DELIMITER | Prefix each field in the query with this character | false |
| delimiterSuffix | DELIMITER | Suffix each field in the query with this character | false |
...
Configuration file example
No Format |
---|
<?xml version="1.0" encoding="UTF-8"?>
<Task type="org.vivoweb.ingest.fetch.JDBCFetch">
<Param id="driver">com.mysql.jdbc.Driver</Param>
<Param id="connection">jdbc:mysql://127.0.0.1:3306/jdbcdemoharvest</Param>
<Param id="username">jdbcDemoHarvest</Param>
<Param id="password">EFaY6nSxBNpL7cYb</Param>
<Param id="output">config/recordHandlers/JDBCXMLRecordHandler.xml</Param>
</Task>
|
...