Pass native query as String to @Query

Question

I've a query which needs to be constructed as String first.

StringBuilder query = new StringBuilder();
query.append(....);
query.append(....);

I want to pass this query as a native query, like:

myTableRepository.insertData(query.toString());

So in MyTableRepository I can use it like we generally use native queries using @Query annotation.

Is it possible?

P.S. - I'm not using createNative(), due to some legacy issue, I don't want to use EntityManager.

Well it's certainly possible (via a repository extension method), but sort of defeats the whole purpose of abstracting the data access away using a repository — crizzis
– crizzis, Commented Oct 6, 2020 at 20:21
@crizzis, can you please redirect me to any example. I know its not ideal but I still want to know how its done. Thanks. — sonic boom
– sonic boom, Commented Oct 7, 2020 at 16:45

SternK · Accepted Answer · 2020-10-06 08:18:32Z

2

I don't think it is possible , it will exposes your code to jpql injection attack, and from perspective of DB optimizer it cause bad performance cause it have to create query each time. You can use Criteria query to build safe dynamic query.

edited Oct 6, 2020 at 8:18

SternK

13.3k34 gold badges40 silver badges55 bronze badges

answered Oct 5, 2020 at 21:55

tamHin

213 bronze badges

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

Collectives™ on Stack Overflow

Pass native query as String to @Query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related