<import>
The root element for an Import XML Document.
| Name | Type | Required | Description |
|---|---|---|---|
| log | string | required | The file that will contain all info, audit and error messages. |
| bad | string | required | The file that will contain all rows that could not be imported. |
| commitCount | integer | optional | The number of rows to import before calling commit on the connection (default is 1). If the value is less than or equal to 1 then commit will not be called by the JDBCImporter and the connnection will be set to auto commit. |
| batchCount | integer | optional | The number of rows to import before calling executeBatch on the ImportEngine (default is 0). If the value is less than or equal to 1 then executeBatch will not be called by the JDBCImporter. |
| trimValues | boolean | optional | The flag indicating that values will trimmed after reading them from the Delimiter Parser |
| preSQLFile | string | optional | The filename containing sql statements that will be executed before the import. |
| postSQLFile | string | optional | The filename containing sql statements that will be executed after the import. |
1
<connection>
The connection definition used by JDBCImporter.
| Name | Type | Required | Description |
|---|---|---|---|
| type | string | required | The type of connection definition. The value should map to the class that implements ConnectionDef. |
0..*
<property>
The properties applied to the connection definition object.
| Name | Type | Required | Description |
|---|---|---|---|
| name | string | required | The name of the property. |
| value | string | required | The value of the property. |
1..*
<entity>
The list of tables to be imported.
| Name | Type | Required | Description |
|---|---|---|---|
| table | string | required | The table name that will contain the imported data. |
| source | string | required | The source file containing the rows to be imported. |
| encoding | string | optional | The source file's encoding charset. |
| schema | string | optional | The schema name of the table. |
| catalog | string | optional | The catalog name of the table. |
| engine | string | optional | The import engine classname to use when importing rows for the entity. |
0..*
<property>
The properties defined for an entity which may be used by the
ImportEngine.
| Name | Type | Required | Description |
|---|---|---|---|
| name | string | required | The name of the property. |
| value | string | required | The value of the property. |
1
<delimiter>
The delimiter parser definition used to parse the source file.
| Name | Type | Required | Description |
|---|---|---|---|
| type | string | required | The type of delimiter parser. The value should map to the class that implements DelimiterParser. |
0..*
<property>
The properties applied to the delimiter parser.
| Name | Type | Required | Description |
|---|---|---|---|
| name | string | required | The name of the property. |
| value | string | required | The value of the property. |
0..1
<translator>
The row translator that will be used to translate row values.
| Name | Type | Required | Description |
|---|---|---|---|
| type | string | required | The type of column translator. The value should map to the class that implements RowTranslator. |
0..*
<property>
The properties applied to the row translator.
| Name | Type | Required | Description |
|---|---|---|---|
| name | string | required | The name of the property. |
| value | string | required | The value of the property. |
1..*
<column>
The list of columns in the table and source file
| Name | Type | Required | Description |
|---|---|---|---|
| name | string | required | The name of the column. |
| SQLType | sqlType | optional | The type of the column. |
| defaultValue | string | optional | The default value of the column. |
| translator | string | optional | The class that will translate the values before they are imported. |
| format | string | optional | The format pattern used to describe how to parse numbers or dates. |
| generate | boolean | optional | The flag indicating that the column will be generated instead of read from the source file. |
0..1
<translator>
The column translator that will be used to translate column values.
| Name | Type | Required | Description |
|---|---|---|---|
| type | string | required | The type of column translator. The value should map to the class that implements ColumnTranslator. |
0..*
<property>
The properties applied to the column translator.
| Name | Type | Required | Description |
|---|---|---|---|
| name | string | required | The name of the property. |
| value | string | required | The value of the property. |
0..1
<generator>
The column generator that will be used to generate values if the 'generate' attribute is set to true.
| Name | Type | Required | Description |
|---|---|---|---|
| type | string | required | The type of column generator. The value should map to the class that implements ColumnValueGenerator. |
0..*
<property>
The properties applied to the column generator.
| Name | Type | Required | Description |
|---|---|---|---|
| name | string | required | The name of the property. |
| value | string | required | The value of the property. |
0..*
<property>
The properties defined for a column that may be used
by the ImportEngine.
| Name | Type | Required | Description |
|---|---|---|---|
| name | string | required | The name of the property. |
| value | string | required | The value of the property. |