[FIXED] correct way to set tablename in named query in reactiveCrudRepository api

Issue

How to set tablename name in named query? I have tried as below but this line String query="delete from :table1 where name=:name"; is causing error to execute query.

@Repository
public interface DeleteRepo extends ReactiveCrudRepository<Emp,String>{

   String query="delete from :table1 where name=:name";
   @Query(query)
   Mono<Integer> delete(@Param(name) String name, @Param(table1) String table1;
}

Solution

add nativeQuery = true also and you should have @Transactional and @Modifying for deletion.

 @Modifying
   @Transactional
   @Query(value = "delete from :table1 where name=:name", nativeQuery=true)
   Mono<Integer> delete(@Param(name) String name, @Param(table1) String table1);

Answered By - S. Anushan