Pass native query per parameter to JpaRepository Interface

Question

Pass native query per parameter to JpaRepository Interface

Navigation

#1 by (0 votes)

1

I need to create an interface that extends the JpaRepository where I want to pass a native (select) query per parameter instead of leaving static within the @Query annotation. Instead of using @Query(value = "select * from a where a = :a", nativeQuery = true) I want to use the code sampled below.

 public interface MeuRepository extends JpaRepository<MeuEntity, Integer>{

     @Query(value = query, nativeQuery = true)
     List<MeuEntity> findCustomNativeQuery(String query);
 }

spring spring-data spring-jpa

asked by anonymous 11.05.2017 / 22:08

1 answer

Publishing site in IIS gives debug error How to get information about the tag targets of an external url

score 0 · Answer 1

In this case you do not have to, you have to use EntityManager , here's an example:

@PersistenceContext
protected EntityManager manager;

public List<MeuEntity> findCustomNativeQuery(String query) {
    return manager.createNativeQuery(query, MeuEntity.class).getResultList();
}