Importing data

Applies to ✅ Open Source Edition   ✅ Express Edition   ✅ Professional Edition   ✅ Enterprise Edition

jOOQ's loader API can be used to import tabular data into a table from a variety of data sources. It offers a simplified API to solve common data import challenges such as:

• Mapping different data sources, like CSV, JSON, XML, records to SQL tables
• Specifying behaviour when duplicate keys are encountered
• Fine tuning batch, bulk, and commit sizes
• Error handling

Table of contents

5.11.1.

The Loader API

5.11.2.

Import options

5.11.2.1.

Throttling

5.11.2.2.

Duplicate handling

5.11.2.3.

Error handling

5.11.3.

Import data sources

5.11.3.1.

Importing CSV

5.11.3.2.

Importing JSON

5.11.3.3.

Importing records

5.11.3.4.

Importing arrays

5.11.3.5.

Importing XML

5.11.4.

Import listeners

5.11.5.

Import result and error handling