JDBC
Enhanced usage of this feature is available with Gatling Enterprise. Explore our plans to learn more.
JDBC is the Java API to access relational databases. With the Gatling JDBC plugin, you can load test any database that has a JDBC driver, such as PostgreSQL, MySQL, MariaDB, SQL Server, or Oracle Database.
Gatling supports:
- plain statements, prepared statements with bound parameters, and batches
- stored procedures, with OUT and INOUT parameters, and cursors
- transactions, with their isolation level
- checks on update counts, rows, column values, generated keys, and OUT parameters
- a feeder that loads its records from a database
Project Setup
Learn how to set up your project to use the Gatling JDBC protocol.
JDBC Protocol
Learn how to configure the JDBC protocol, and how Gatling pools connections and measures response times.
Statements
Learn how to run plain statements, prepared statements, batches, and stored procedures against your database.
Checks
Learn how to check what your statements produced, and save values for the next requests.
Transactions
Learn how to run several statements in a transaction, and how Gatling keeps its connection in between.
JDBC Feeder
Learn how to load the records of a feeder from your database with a SQL query.
Database Specifics
Learn how the main databases and their JDBC drivers differ, and how to write tests that behave as expected with each of them.