Friday, November 17, 2017

Effective Usage of Oracle Row-Locking With Spring JDBC

DZone Database Zone
Effective Usage of Oracle Row-Locking With Spring JDBC
Effective Usage of Oracle Row-Locking With Spring JDBC

Database row-locking is one of the great features provided by RDBMS vendors to manage synchronization of concurrent data processing activities on a given table. Although it’s a great feature, it can lead to critical scenarios like your system being stuck due to stale locks on the database side.

In this blog post, I’m going to explain how to use Spring JDBC with the row-locking feature of Oracle database to maintain the synchronization of concurrent data processing tasks that are expected to transform some data and persist it back to the database.

No comments:

Fun With SQL: Functions in Postgres

DZone Database Zone Fun With SQL: Functions in Postgres In our previous  Fun with SQL  post on the  Citus Data  blog, we covered w...