Can't escape quote character in @Query in Spring Boot app for Cassandra

815 Views Asked by At

These queries don't run in the repository of the Cassandra SpringBoot App:

@Query("SELECT * FROM activities2 WHERE viewer_id='?0'")
    Iterable<Activity> findByApp_Id(String appId);

@Query("SELECT * FROM activities2 WHERE viewer_id=''?0''")
    Iterable<Activity> findByApp_Id(String appId);

@Query("SELECT * FROM activities2 WHERE viewer_id='''?0'''")
    Iterable<Activity> findByApp_Id(String appId);

@Query("SELECT * FROM activities2 WHERE viewer_id=\'?0\'")
    Iterable<Activity> findByApp_Id(String appId);

BUT,

this does:

@Query("SELECT * FROM activities2 WHERE viewer_id='v1'")
    Iterable<Activity> findByApp_Id(String appId);

It seems that spring doesn't escape the query properly. How can I solve this ?

0

There are 0 best solutions below