Refactored out pure jdbc usages. Using jdbcTemplate and transaction manager in data access layer.