DeterminingDBChangesService service = new DeterminingDBChangesService("jdbc:sqlite:db.sqlite");
        service.drop("houses");
        service.drop("houses_log");
        service.init();
        service.initTrigger();
        service.insert(new House(0,1,"d1","u1")); //отправляем c id 0 в таблице должен сработать автоинкремент, то есть в конкретном примере id будет 1.  Так и выходит [House(id=1, price=1, district=d1, underground=u1, date=2020-01-30 18:00:52)]
        service.update(new House(1,2,"d1","u1"));// хочу обновить строку с id 1

[House(id=1, price=1, district=d1, underground=u1, date=2020-01-30 18:02:21)]
Exception in thread "main" ru.itpark.exception.DataAccessException
	at ru.itpark.util.JdbcTemplate.execute(JdbcTemplate.java:21)
	at ru.itpark.util.JdbcTemplate.executeCreateQuery(JdbcTemplate.java:42)
	at ru.itpark.service.DeterminingDBChangesService.update(DeterminingDBChangesService.java:42)
	at ru.itpark.Main.main(Main.java:16)

Process finished with exit code 1

 private static <T> T execute(String dataSource, String sql, PreparedStatementExecutor<T> executor) {
        try (
                Connection connection = DriverManager.getConnection(dataSource);
                PreparedStatement preparedStatement = connection.prepareStatement(sql)
        ) {
            return executor.execute(preparedStatement);
        } catch (SQLException e) {
            throw new DataAccessException();
        }
    }

 public static void executeCreateQuery(String dataSource, String sql, PreparedStatementSetter setter) {
        execute(dataSource, sql, pstmt -> {
            setter.set(pstmt);
            pstmt.execute();
            return null;
        });
    }

public void update(House house) {
        String sql = "UPDATE houses SET price = ?, district = ?, underground = ? WHERE id = ?;";

        JdbcTemplate.executeCreateQuery(dataSource, sql, pstmt -> {
            pstmt.setInt(1, house.getPrice());
            pstmt.setString(2, house.getDistrict());
            pstmt.setString(3, house.getUnderground());
            pstmt.setInt(4, house.getId());
        });
    }

org.sqlite.SQLiteException: [SQLITE_CONSTRAINT]  Abort due to constraint violation (UNIQUE constraint failed: houses_log.new_id)
	at org.sqlite.core.DB.newSQLException(DB.java:941)
	at org.sqlite.core.DB.newSQLException(DB.java:953)
	at org.sqlite.core.DB.execute(DB.java:854)
	at org.sqlite.jdbc3.JDBC3PreparedStatement.execute(JDBC3PreparedStatement.java:56)
	at ru.itpark.util.JdbcTemplate.lambda$executeCreateQuery$0(JdbcTemplate.java:45)
	at ru.itpark.util.JdbcTemplate.execute(JdbcTemplate.java:19)
	at ru.itpark.util.JdbcTemplate.executeCreateQuery(JdbcTemplate.java:43)
	at ru.itpark.service.DeterminingDBChangesService.update(DeterminingDBChangesService.java:42)
	at ru.itpark.Main.main(Main.java:16)