Oracle database polling with MyBatis and Spring

Question

need to monitor the column of a sql table if its value gets updated,this change needs to be captured in java program, based on the value, a method need to be executed like WatcherService is used in java for monitoring directory.

above requirement is to be achieved using mybatis and spring, Thanks in advance, any help would be much appreciated.

I would like to implement a listener like in this question : How to implement a db listener in Java

but using spring and mybatis, and needed a service like that of Java WatchService(which keeps monitoring directory changes).

Hope I explained the problem, please let me know if need more explanation.

hope code (pseudocode at least) is clear communication between programmers. I dont understand You — Jacek Cz, May 31 '18 at 10:25
The question is very broad. What specifically does not work or you have problems with when you try to implement the solution described in the linked answer using mybatis? — Roman-Stop RU aggression in UA, Jun 01 '18 at 14:35

score 0 · Answer 1 · answered Jun 01 '18 at 17:58

The solution you mention does not use the generic JDBC interface MyBatis & Spring use to communicate with the database. This solution makes explicit references to the Oracle JDBC driver.

I don't think it's possible to use the specific Oracle API using MyBatis. But you are free to use the driver as the example shows; there's no limitation on it.

Oracle database polling with MyBatis and Spring

1 Answers1