Hibernate database (maria-db) change detect

Question

I need to understand, Is there anyway I can continuously look for change in Maria-DB table using Hibernate.

I have a spring boot application that is connected to Maria-DB. If some other application perform CURD on table, I want to catch that in spring.

If it's not possible using hibernate, suggest me alternative.

PS : This spring boot application is running is different Docker Container and Maria-DB is running is different Docker Container.

Neither Hibernate nor Maria-DB has support for change notifications. — Arek
– Arek, Commented Sep 12, 2018 at 10:45
Have a look at this lienk stackoverflow.com/questions/38630114/… — cralfaro
– cralfaro, Commented Sep 12, 2018 at 12:30
@cralfaro According to my understanding, hibernate interceptor work with session. Means if we perform action on Entity for same application then it will work.In my case some other application is performing CURD operations. — Umair
– Umair, Commented Sep 14, 2018 at 7:48

dnny · Accepted Answer · 2018-09-12 10:57:22Z

0

You can use Database Triggers, or better why don't you try enabling Hibernates 2nd level cache?

answered Sep 12, 2018 at 10:57

dnny

1361 silver badge8 bronze badges

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

1 Comment

Umair Over a year ago

As I have mentioned, triggers will not work here because my db is in different docker container and my application is in different docker container. Plus Hibernate Caches are within applications and here in this scenario curd operation will be performed by another application and that application will be on different docker container.

Umair · Accepted Answer · 2018-09-14 16:55:51Z

0

Solution to this specific problem is Spring Integration module as other ways not working here. I have create a sample application to demonstrate here you can find the source code

What this application does look database continuously.

answered Sep 14, 2018 at 16:55

Umair

191 silver badge14 bronze badges

Collectives™ on Stack Overflow

Hibernate database (maria-db) change detect

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related