public CustomHoldingBean getHolding(String userId, int holdingID)
throws DAOException {
if (logger.isDebugEnabled()) {
logger.debug("MSSQLCustomerDAO.getHolding(String,int)\nUserID :" + userId + "\nOrder ID :" + holdingID);
}
CustomHoldingBean holding = null;
PreparedStatement selectHoldingNoLockStat = null;
try {
selectHoldingNoLockStat = sqlConnection.prepareStatement(SQL_SELECT_HOLDING_NOLOCK);
selectHoldingNoLockStat.setInt(1, holdingID);
selectHoldingNoLockStat.setString(2, userId);
ResultSet rs = selectHoldingNoLockStat.executeQuery();
if (rs.next()) {
try {
holding = new CustomHoldingBean(
rs.getInt(1),
holdingID,
rs.getDouble(2),
rs.getBigDecimal(3),
StockTraderUtility.convertToCalendar(rs.getDate(4)),