Statement stmt = sharedConnection.createStatement();

        stmt.execute("CREATE TEMPORARY TABLE test_replace (id int not null primary key, active BOOLEAN)")    

        stmt.execute("insert into test_replace values (1, false), (2, false), (3, false)");

        try (PreparedStatement preparedStatement = sharedConnection.prepareStatement("replace into test_replace (id, active) values (?, ?)")) {

            preparedStatement.setInt(1, 1);

            preparedStatement.setBoolean(2, true);

            preparedStatement.addBatch();

            preparedStatement.setInt(1, 2);

            preparedStatement.setBoolean(2, true);

            preparedStatement.addBatch();

            preparedStatement.setInt(1, 3);

            preparedStatement.setBoolean(2, true);

            preparedStatement.addBatch();

            preparedStatement.setInt(1, 4);

            preparedStatement.setBoolean(2, true);

            preparedStatement.addBatch();

            preparedStatement.executeBatch();

        }

            1 true

            2 true

            3 true

            4 true

            1 false

            2 true

            3 true

            4 true

27 00 00 00 FA 01 00 00  00 80 FF 03 00 01 00 00     '...............

01 00 00 00 00 01 00 02  00 00 00 00 01 00 03 00     ................

00 00 00 01 00 04 00 00  00 00 01                    ...........