Some databases (in particular MySQL and T-SQL databases like SQL Server and Sybase) support a very nice feature: They allow for running a “batch” of statements in a single statement. For instance, in SQL Server, you can do something like this:
-- Statement #1 DECLARE @table AS TABLE (id INT); -- Statement #2 SELECT * FROM @table; -- Statement #3 INSERT INTO @table VALUES (1),(2),(3); -- Statement #4 SELECT * FROM @table;
This is a batch of 4 statements, and it can be executed as a single statement both with JDBC and with jOOQ. Let’s see how:
Executing a batch with JDBC
Unfortunately, the term “batch” has several meanings, and in this
case, I don’t mean the JDBC Statement.addBatch()
method,
which is actually a bit clumsy as it doesn’t allow for fetching
mixed update …