JDBC / Relational Databases

Contents

Insert Strategies

# Type Javadocs Example Supported Databases
1 PreparedStatement Insert (Default) Write a CSV File to Database (1)
Write a CSV File to Database (2)
All databases using standard JDBC drivers
2 MySql PreparedStatement Insert
  • MySQL 5.7.22
  • MySQL 8.0.16
3 MultiRow PreparedStatement Insert Write to a Database Using Multi Row Prepared Statement Insert Strategy
  • MariaDB 10.3.6
  • Microsoft SQL Server 2017-CU12
  • MySQL 5.7.22
  • MySQL 8.0.16
  • PostgreSQL 9.6.12
  • Sybase ASE 15.7
4 MultiRow Statement Insert Write to a Database Using Multi Row Statement Insert Strategy
  • MariaDB 10.3.6
  • Microsoft SQL Server 2017-CU12
  • MySQL 5.7.22
  • MySQL 8.0.16
  • PostgreSQL 9.6.12
  • Sybase ASE 15.7
5 Oracle MultiRow InsertAll Statement Insert
  • Oracle 11g
6 Oracle MultiRow Select UnionAll Statement Insert
  • Oracle 11g

* If your database or version isn't listed above, it may still be supported, but we haven't explicitly tested it.

Upsert Strategies

# Database Generic Upsert Merge Upsert MySql Upsert Oracle Upsert PostgreSql Upsert Sybase Upsert Variable Fields Upsert
  Javadocs Javadocs Javadocs Javadocs Javadocs Javadocs Javadocs Javadocs
  Examples Generic Upsert Example Merge Upsert Example MySql Upsert Example Oracle Upsert Example PostgreSql Upsert Example Sybase Upsert Example Variable Fields Upsert Example
1 IBM DB2 11.5.0.0a No Batch Batch No Batch
2 MariaDB 10.3.6 No Batch Batch No Batch
3 Microsoft SQL Server 2017-CU12 No Batch Batch Batch No Batch
4 MySQL 5.7.22 No Batch Batch No Batch
5 MySQL 8.0.16 No Batch Batch No Batch
6 Oracle 11g No Batch Batch No Batch
7 PostgreSQL 9.6.12 No Batch Batch No Batch
8 PostgreSQL 15 No Batch Batch Batch No Batch
9 Sybase ASE 15.7 No Batch Batch No Batch

*Batch - supports both batch and non-batch upserts.

*No Batch - supports only non-batch upserts.

PostgreSQL

When using MergeUpsert strategy with PostgreSQL, it is important to note that all key fields in the target table must either be a composite key or a primary key (if a single key field is specified).

Mobile Analytics