How to run native postgres query using spring-data-jpa

Question

I am using spring-data-jpa to run native postgres queries. The query is performed on entity's jsonb data. I can run the raw query on db server with success:

SELECT e.* 
FROM public.entity e where e.json ? 'salary' and e.json ->> 'salary' > '10000';

But, since spring-data-jpa also supports ? for the parameterized queries, there seems to be conflict in the grammer of the query, therefore application eventually fails to even start.

@Query(value = "select e.* from Entity e where e.json ? 'salary' and e.json->> 'salary' > ?1", nativeQuery = true)
List<Lead> getEntitiesBySalaryGreaterThan(String value);

}

Please let me know the workaround or correct way of executing the intended native query in spring-data-jpa env

ValerioMC · Accepted Answer · 2019-01-28 20:54:29Z

1

Is it possible that you need to escape ? as described here?

edited Jan 28, 2019 at 20:54

answered Jan 28, 2019 at 20:28

ValerioMC

3,22617 silver badges28 bronze badges

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

2 Comments

Dota2 Over a year ago

I already have that, If you see ur @query it has two nativeQuery

Dota2 Over a year ago

Thanks man!! Did not know that postgres allows creating custom operators

Collectives™ on Stack Overflow

How to run native postgres query using spring-data-jpa

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related