we have a requirement to increment a counter in the database tables from a java program. There can be multiple java processes incrementing the counter. How can we make sure that the counter is incremented correctly, so that there are no dirty reads by the processes and increment on a stale value.
using Hibermate mapping to that table.
Note: this is not the ID column.