Hibernate and Spring modify query Before Submitting to DB

Question

I have a Hibernate query that is configured to execute with Spring Data (the @Repository) annotation. I want to catch the query before it is submitted to the DB and when a specific condition is met, modify it a little bit.

What is the best option to do so? I prefere a JPA solution rather then a Hibernate solution, but a Hibernate solution will also work.

handle this in your dao layer. you don't need to 'catch' the query, but build it taking into account that specific condition. — sergiu
– sergiu, Commented Dec 8, 2014 at 13:38

Community · Accepted Answer · 2017-05-23 12:30:20Z

3

If you want to modify the query after the prepared statement, you can do it into an Hibernate Interceptor, and register it during Spring DB Configuration.

Your MyInterceptor either should implements Hibernate Interceptor.class or extends EmptyInterceptor.class. The method you are looking for is:

public String onPrepareStatement(String sql);

If you need something more, you could give a try with the Event Listeners, but I am not sure there is one for your case.

Here some documentation:

Hibernate 4.0 Interceptors and events How to integrate an Interceptor with Spring

edited May 23, 2017 at 12:30

CommunityBot

11 silver badge

answered Mar 25, 2015 at 10:48

R.Litto

4035 silver badges15 bronze badges

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

3 Comments

Alex R Over a year ago

this is deprecated, see also stackoverflow.com/questions/39112308/…

R.Litto Over a year ago

Thanks, good to know implemented a better mechanism in Hybernate 5

xtermi2 Over a year ago

onPrepareStatement is deprecated in hibernate 5.6 and removed in 6. How to handle this issue with hibernate 6?

Collectives™ on Stack Overflow

Hibernate and Spring modify query Before Submitting to DB

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related