@PersistenceContext
private EntityManager entityManager;

@Transactional
public boolean insertAddress(int id, int delay, String address) {

    try {
        entityManager.createNativeQuery(
                "INSERT INTO location_alarm (id_user, date_time, address, address_alarm_delay) " +
                        "VALUES (?, GETDATE(), ?, ?)")
                .setParameter(1, id)
                .setParameter(2, address)
                .setParameter(3, delay)
                .executeUpdate();
    } catch (Exception e) {
        e.printStackTrace();
        return false;
    }
    return true;
}

    @Transactional
    public int insertAddress(int id, int delay, String address) {

        KeyHolder keyHolder = new GeneratedKeyHolder();
        JdbcTemplate jdbcTemplate = new JdbcTemplate(mDataSource);

        jdbcTemplate.update(con -> {
            PreparedStatement statement = con.prepareStatement(
                    "INSERT INTO location_alarm (id_user, date_time, address, address_alarm_delay) " +
                            "VALUES (?, GETDATE(), ?, ?) ", Statement.RETURN_GENERATED_KEYS);
            statement.setInt(1, id);
            statement.setString(2, address);
            statement.setInt(3, delay);
            return statement;
        }, keyHolder);

        return keyHolder.getKey() != null ? keyHolder.getKey().intValue() : 0;

    }