Database-related settings

Transaction

  • The insertions of generated data would be collected into batches bound by transactions.

  • JdbcDataGenerator.setBatchSize(int) decides the batch size for a transaction.

  • The default batch size is 1024.

Tests on databases/JDBC drivers

Table 1. Tested Databases and JDBC Drivers

Database System

JDBC Driver

Note

H2 Database Engine

com.h2database:h2 (2.4.240)

mode is regular, by local file

HyperSQL

org.hsqldb:hsqldb (2.7.4)

by local file

Apache Derby

org.apache.derby:derby (10.17.1.0)

by local file

Sqlite(xerial/sqlite-jdbc)

org.xerial:sqlite-jdbc (3.42.0.0)

by local file

PostgreSQL 16

org.postgresql:postgresql (42.7.8)

MySQL 8.4

com.mysql:mysql-connector-j (9.5.0)

Microsoft SQL Server 2022(16.x)

com.microsoft.sqlserver:mssql-jdbc (11.2.3.jre17)

Oracle Database Free

com.oracle.database.jdbc:ojdbc17 (23.9.0.25.07)

by docker image: gvenzl/oracle-free:slim-faststart