I currently have a Scala application (with Java JDBC connector ) that queries SQL Server database table every minute for new entries inserted, then it does processing.
Is there a scala tool or library that I can use to listen for new entries inserted into the SQL Server Database table? I believe this new approach of listening to a table will give high efficiency.
I tried using Slick with akka streams to stream data from the table but I didn’t know to configure it to listen for new entries on the table.
Database - SQL Server Database
Connection tool - Java JDBC