@Override public Collection<SavingsProductData> retrieveAllForLookup() { final String sql = "select " + this.savingsProductLookupsRowMapper.schema() + " where sp.deposit_type_enum = ?"; return this.jdbcTemplate.query( sql, this.savingsProductLookupsRowMapper, new Object[] {DepositAccountType.SAVINGS_DEPOSIT.getValue()}); }
@Override public SavingsProductData retrieveOne(final Long savingProductId) { try { this.context.authenticatedUser(); final String sql = "select " + this.savingsProductRowMapper.schema() + " where sp.id = ? and sp.deposit_type_enum = ?"; return this.jdbcTemplate.queryForObject( sql, this.savingsProductRowMapper, new Object[] {savingProductId, DepositAccountType.SAVINGS_DEPOSIT.getValue()}); } catch (final EmptyResultDataAccessException e) { throw new SavingsProductNotFoundException(savingProductId); } }