net.javacrumbs.shedlock.provider.jdbctemplate

Class JdbcTemplateLockProvider

java.lang.Object

net.javacrumbs.shedlock.support.StorageBasedLockProvider

net.javacrumbs.shedlock.provider.jdbctemplate.JdbcTemplateLockProvider

All Implemented Interfaces:

LockProvider

public class JdbcTemplateLockProvider
extends StorageBasedLockProvider

Lock provided by JdbcTemplate. It uses a table that contains lock_name and locked_until.

1. Attempts to insert a new lock record. Since lock name is a primary key, it fails if the record already exists. As an optimization, we keep in-memory track of created lock records.
2. If the insert succeeds (1 inserted row) we have the lock.
3. If the insert failed due to duplicate key or we have skipped the insertion, we will try to update lock record using UPDATE tableName SET lock_until = :lockUntil WHERE name = :lockName AND lock_until <= :now
4. If the update succeeded (1 updated row), we have the lock. If the update failed (0 updated rows) somebody else holds the lock
5. When unlocking, lock_until is set to now.

Constructor Summary

Constructors

Constructor and Description
JdbcTemplateLockProvider(DataSource datasource)
JdbcTemplateLockProvider(DataSource datasource, String tableName)
JdbcTemplateLockProvider(org.springframework.jdbc.core.namedparam.NamedParameterJdbcOperations jdbcTemplate, String tableName)

Method Summary

Methods inherited from class net.javacrumbs.shedlock.support.StorageBasedLockProvider

doLock, lock, now

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

JdbcTemplateLockProvider

public JdbcTemplateLockProvider(DataSource datasource)

JdbcTemplateLockProvider

public JdbcTemplateLockProvider(DataSource datasource,
                                String tableName)

JdbcTemplateLockProvider

public JdbcTemplateLockProvider(org.springframework.jdbc.core.namedparam.NamedParameterJdbcOperations jdbcTemplate,
                                String tableName)