gistfile1.java

public class ExodusWriter {

    private JdbcTemplate jdbcTemplate;
    private TransactionTemplate transactionTemplate;

    public ExodusWriter(DataSource dataSource) {
        DataSourceTransactionManager transactionManager = new DataSourceTransactionManager(dataSource);
        jdbcTemplate = new JdbcTemplate(transactionManager.getDataSource());
        transactionTemplate = new TransactionTemplate(transactionManager);
    }


    public void writeImageID(final String imageID, final String uuid) throws Exception {
        transactionTemplate.execute(new TransactionCallback<Object>() {
            @Override
            public Object doInTransaction(TransactionStatus status) {
                jdbcTemplate.update("delete from image_to_uuid where image_id = ?", imageID);
                jdbcTemplate.update("insert into image_to_uuid (image_id, uuid) values (?, ?)", imageID, uuid);
                return null;
            }
        });
    }
}