Spring data JPA - Dynamic SQL Execution

Question

I want to Execute the SQL , which will be constructed completely at runtime and it can be querying any tables in the schema.

Something like

@Repository public interface BaseRepository extends JpaRepository<Object, Integer> {        
    @Query(":dynamicSQL")   
    List<Object> dynamicExecution(@Param("dynamicSQL") String dynamicSQL);           
}

Please suggest how this can be implemented

Does this answer your question? spring data compose @query query dynamically — Jens Schauder
– Jens Schauder, Commented Dec 17, 2019 at 6:14

Rahil Husain · Accepted Answer · 2019-08-05 15:39:31Z

0

JpaRepository is not designed to be used like this. If you want to execute dynamic SQL query then use EntityManager. This is bad design but if you still want to do this then use default methods and pass a EntityManager bean like this:

default List<?> dynamicExecution(EntityManager em, String sql) {
    return em.createNativeQuery(sql).getResultList();
}

answered Aug 5, 2019 at 15:39

Rahil Husain

5703 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Spring data JPA - Dynamic SQL Execution

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related