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();

        }

        ResultSet rs = stmt.executeQuery("SELECT * FROM test_replace");

        while (rs.next()) {

            System.out.println(rs.getInt(1) + " " + rs.getBoolean(2));

        }

        /*

        result is

            1 false !!!!!

            2 true

            3 true

            4 true

         */