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 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
3 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

* 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
  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 Batch No Batch
8 Sybase ASE 15.7 No Batch Batch No Batch

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

*No Batch - supports only non-batch upserts.

Mobile Analytics