Spring : How to delete entry from junction table?

Question

I have a junction table of user_id and favorite_property_id And now I want to delete the favorite property of the user , I tried the following method in repository but its not working , Does anybody have any idea that how can i delete he entry from junction table?

User.java

@Entity
    public class User implements Serializable, UserGetters {
        private static final long serialVersionUID = 1L;

        @Id
        @GeneratedValue(strategy = GenerationType.IDENTITY)
        private Long id;

        @ManyToMany(fetch = FetchType.EAGER)
        private Set<Property> favouriteProperty;

    public Set<Property> getFavouriteProperty() {
            return favouriteProperty;
        }

        public void setFavouriteProperty(Set<Property> favouriteProperty) {
            this.favouriteProperty = favouriteProperty;
        }
        }

UserRepository

public interface UserRepository  extends JpaRepository<User, Long> {
//@Transactional
     // Long deleteByFavouritePropertyId(@Param("favoriteProperty") Long favoriteProperty);

    // @Query("delete favouriteProperty from user u where u.favouriteProperty.id=:favouriteProperty")
    // void unmarkFavouriteProperty(@Param("favouriteProperty")  Long favouriteProperty);

}

Unexpected Token : from near line 1, column 26 [delete favouriteProperty from user u where u.favouriteProperty.id=:favouriteProperty] @Afridi — SFAH, May 29 '17 at 06:37

score 2 · Answer 1 · answered May 29 '17 at 06:50

2

You can do it like:

1. Load user object

User user = userRepository.findOne(userId);

2. Remove required object from list

user.getFavouriteProperty().remove(id);

3. Save User Object

userRepository.save(user);

answered May 29 '17 at 06:50

Afridi

6,753
2
18
27

score 1 · Answer 2 · answered May 29 '17 at 07:42

1

Try using :

Query query = session.createQuery("delete Category where id = :favorite_property_id ");
query.setParameter("favorite_property_id ", new Long(favoriteProperty));
int result = query.executeUpdate();

in your repository file. It will work fine.

answered May 29 '17 at 07:42

Sahil Gupta

73
1
3
12

What is session ? – SFAH May 29 '17 at 07:48
Its the hibernate session acquired from session factory. `Session sess = factory.openSession();` – Sahil Gupta May 29 '17 at 07:58
THanks for your help – SFAH May 29 '17 at 09:41

score 0 · Answer 3 · answered May 29 '17 at 09:40

0

This was so simple :P

I can delete by using following API

API : http://localhost:8555/api/users/2/favouriteProperty/3

METHOD : DELETE

answered May 29 '17 at 09:40

SFAH

624
15
35

Spring : How to delete entry from junction table?

3 Answers3

1. Load user object

2. Remove required object from list

3. Save User Object