How to Keep @Query in properties file and access these queries in JPA

Question

I am using Spring data and jpaRepository for interacting with DB.

    public interface TelevisionSourceRepository extends JpaRepository<MyTelevisionSource, Long> {

        @Query("select new com.tivo.extract.config.dto.SourceListDTO(s.SourceId, s.SourceName, t.TvsourceLongName) from MyTelevisionSource t join fetch RCMSource s ON s.SourceId = t.SourceId")
        List<SourceListDTO> findSourceList(Pageable pageable);
    }

I want to keep the query in properties file and want to use those query.

I tried with

    @PropertySource("classpath:/Query.properties")


    @Value("${RCM.findSourceList}")
        List<SourceListDTO> findSourceList(Pageable pageable);

but its not working, any other way is there

Why are using `@Value` annotation instead of `@Query` annotation? — Amir Pashazadeh, Jul 31 '19 at 05:59
you are telling the below way @Query("@Value("${RCM.findSourceList}")") — mohan, Jul 31 '19 at 06:02
Try this `@Query("#{RCM.findSourceList}")` or `@Query("#{#RCM.findSourceList}")`. — Sachith Dickwella, Jul 31 '19 at 06:38
Caused by: org.hibernate.QueryException: unexpected char: '#' [#{#RCM.findSourceList}] — mohan, Jul 31 '19 at 08:28
One suggestion: https://stackoverflow.com/questions/46060590/externalize-query-in-spring-boot-application — Alan Hay, Jul 31 '19 at 09:14

score 1 · Accepted Answer · answered Jul 31 '19 at 09:03

1

I think if you declare a string with @Value. and put the string in @Query value. in application.properties

spring.queries.status-query=SELECT * FROM mydb.project ORDER BY purchase_order ASC,customer_name ASC

and in your class

@Value("${spring.queries.status-query}")
    String status_query="0";


@Query(value = status_query,nativeQuery = true)
    List<project> findAllSorted();

answered Jul 31 '19 at 09:03

Mohammed Shalan

54
4

1

Do you know that annotation parameters must be constant? And this way it is not. – Amir Pashazadeh Aug 20 '19 at 18:46

How to Keep @Query in properties file and access these queries in JPA

1 Answers1