Example usage for org.springframework.dao DataAccessException getMessage

List of usage examples for org.springframework.dao DataAccessException getMessage

  1. HOME
  2. Java
  3. org.springframework
  4. org.springframework.dao.*
  5. DataAccessException
  6. getMessage

Introduction

In this page you can find the example usage for org.springframework.dao DataAccessException getMessage.

Prototype

@Override
@Nullable
public String getMessage()

Source Link

Document

Return the detail message, including the message from the nested exception if there is one.

Usage

From source file:com.citrix.cpbm.portal.fragment.controllers.AbstractTenantController.java

/**
 * Post method for creating Tenant.//w w  w .  j  a  va  2s .  c o m
 * 
 * @param form the Tenant form. {@link TenantForm}
 * @param result {@link BindingResult}
 * @param map {@link ModelMap}
 * @param sessionStatus
 * @param request the {@link HttpServletRequest}
 * @return View.
 * @throws Exception
 */
@RequestMapping(value = { "", "/" }, method = RequestMethod.POST)
public String create(@ModelAttribute("account") final TenantForm form, BindingResult result, ModelMap map,
        SessionStatus sessionStatus, HttpServletRequest request) throws Exception {
    logger.debug("###Entering in create(form,map,status) method @POST");
    String promocode = form.getTrialCode();
    if (promocode != null) {
        CampaignPromotion campaignPromotion = promotionService.locatePromotionByToken(promocode);
        if (campaignPromotion == null) {
            logger.debug("Campaign is not valid");
            result.reject("trialCode", messageSource.getMessage("errors.registration.invalid_trial_code", null,
                    getSessionLocale(request)));
            return "tenants.new";
        }
    }
    String email = form.getUser().getEmail();
    if (isEmailBlacklisted(email.toLowerCase())) {
        map.addAttribute("supportedLocaleList", this.getLocaleDisplayName(listSupportedLocales()));
        map.addAttribute("defaultLocale", getDefaultLocale());
        map.addAttribute("ipToCountryCode", form.getUser().getAddress().getCountry());
        form.setAccountTypes(tenantService.getManualRegistrationAccountTypes());
        map.addAttribute("tenant", CustomProxy.newInstance(getCurrentUser().getTenant()));
        map.addAttribute("account", form);
        map.addAttribute("channels", channelService.getChannels(null, null, null));
        List<Country> filteredCountryList = getFilteredCountryList(form.getCountryList());
        map.addAttribute("filteredCountryList", filteredCountryList);
        map.addAttribute("signuperror", "emaildomainblacklisted");
        return "tenants.new";
    }
    if (result.hasErrors()) {
        displayErrors(result);
        parseResult(result, map);
        return "tenants.new";
    }
    // set currency
    for (CurrencyValue cv : form.getCurrencyValueList()) {
        if (cv.getCurrencyCode().equals(form.getCurrency())) {
            form.getTenant().setCurrency(cv);
            break;
        }
    }
    form.getTenant().setAddress(form.getUser().getAddress());

    if (form.isAllowSecondary()) {
        form.getTenant().setSecondaryAddress(form.getSecondaryAddress());
    }
    AccountType at = tenantService.getAccountTypeById(form.getAccountTypeId());
    List<PaymentMode> paymentModes = at.getSupportedPaymentModes();
    if (paymentModes != null && paymentModes.size() > 0) {
        form.getTenant().getObject().getTenantExtraInformation().setPaymentMode(paymentModes.get(0));
    }
    List<String> errorMsgList = new ArrayList<String>();
    try {
        final com.citrix.cpbm.access.User owner = form.getUser();

        String phoneNo = owner.getObject().getCountryCode().replaceAll(PHONE_NUMBER_REGEX, "")
                + COUNTRY_CODE_TO_PHONE_NUMBER_SEPERATOR + owner.getPhone().replaceAll(PHONE_NUMBER_REGEX, "");
        owner.setPhone(phoneNo);
        owner.setLocale(form.getUser().getLocale());
        form.getTenant().setRemoteAddress(getRemoteUserIp(request));
        String channelParam = form.getChannelParam();
        if (at.equals(tenantService.getTrialAccountType())) {
            com.citrix.cpbm.access.Tenant trialTenant = form.getTenant();
            trialTenant.setAccountType(at);
            registrationService.registerTrialAccount(form.getTrialCode(), trialTenant, owner, channelParam);
        } else {
            tenantService.createAccount(form.getTenant(), owner, channelParam, form.getAccountTypeId(), result);
            com.citrix.cpbm.access.Tenant tenant = form.getTenant();
            if (promocode != null && !promocode.isEmpty()) {
                promotionService.createTenantPromotion(promocode, tenant.getObject());
            }
        }
        map.addAttribute("tenant", form.getTenant());
        String homeUrl = config.getValue(Names.com_citrix_cpbm_portal_marketing_home_url);
        String cloudmktgUrl = config.getValue(Names.com_citrix_cpbm_portal_marketing_marketing_url);
        if (homeUrl != null) {
            map.addAttribute("homeUrl", homeUrl);
        }
        if (cloudmktgUrl != null) {
            map.addAttribute("cloudmktgUrl", cloudmktgUrl);
        }
        sessionStatus.setComplete(); // clean up parameters in session.
    } catch (DataAccessException ex) {
        logger.error(ex);
        result.reject("errors.registration", new Object[] { ex.getMessage() }, null);
        errorMsgList.add("You must accept the terms and conditions to use this service");
    } catch (LDAPException le) {
        logger.error(le);
        result.reject("errors.registration", new Object[] { le.getMessage() }, null);
    } catch (Exception ex) {
        logger.error("###handleTenantCreationError:" + ex.getMessage());
        throw ex;
    }
    if (result.hasErrors()) {
        displayErrors(result);
        form.reset();
        if (errorMsgList.size() > 0) {
            map.addAttribute("errorMsgList", errorMsgList);
            map.addAttribute("errormsg", true);
        }
        logger.debug("###Exiting register(registration,result,captchaChallenge,captchaResponse,"
                + "map,sessionStatus,request) method @POST");
        throw new AjaxFormValidationException(result);
        // return "tenants.new";
    } else {
        String tenantParam = form.getTenant().getUuid();
        map.clear();
        map.addAttribute("tenantParam", tenantParam);
        map.addAttribute("tenantName", form.getTenant().getName());
        map.addAttribute("tenantAccountTypeName", form.getTenant().getAccountType().getName());
        map.addAttribute("tenantAccountId", form.getTenant().getObject().getAccountId());
        map.addAttribute("tenantOwnerUserName", form.getTenant().getOwner().getUsername());
        map.addAttribute("tenantId", form.getTenant().getObject().getId());
        logger.debug("###Exiting create(registration,result,map,sessionStatus,request) method @POST");
        return result.toString();
    }
}

From source file:com.krawler.spring.crm.caseModule.CrmCustomerCaseService.java

public KwlReturnObject addCases(JSONObject jobj) throws ServiceException {
    List ll = new ArrayList();
    int dl = 0;/*from w  ww. j  a v a 2  s. c o m*/
    try {
        ll = caseDao.addCases(jobj).getEntityList();
    } catch (DataAccessException e) {
        throw ServiceException.FAILURE("crmCaseDAOImpl.addCases : " + e.getMessage(), e);
    } catch (Exception e) {
        throw ServiceException.FAILURE("crmCaseDAOImpl.addCases : " + e.getMessage(), e);
    }
    return new KwlReturnObject(true, KWLErrorMsgs.S01, "", ll, dl);
}

From source file:com.soule.base.service.DefaultService.java

/**
 * ???//from   w  ww.  j  ava 2  s  .  co  m
 * @throws ServiceException
 */
//@After("execution(* com.soule..*ServiceImpl.*(..))")
/*public void _copyOutParams() throws ServiceException{
try {
    if ( !LicenseMgr.getInstance().isValid()) {
        logger.info(LicenseMgr.getInstance().getErrorInfo());
        throw new ServiceException(MsgConstants.E0016,AppUtils.getMessage(MsgConstants.E0016));
    }
} catch (ServiceException e1) {
    logger.error("" + e1.getErrorMsg());
    throw e1;
} catch (Exception e) {
    logger.error("" +e.getMessage());
    throw new ServiceException(MsgConstants.E0016,e.getMessage());
}
}*/

@Override
public int executeBatch(final String namespace, final List paramObjects) throws ServiceException {
    int ret = 0;
    try {
        ret = (Integer) this.ibatisMediator.getSqlMapClientTemplate().execute(new SqlMapClientCallback() {
            public Object doInSqlMapClient(SqlMapExecutor executor) throws SQLException {
                executor.startBatch();
                for (Object paramObject : paramObjects) {
                    executor.insert(namespace, paramObject);
                }
                return executor.executeBatch();
            }
        });
    } catch (DataAccessException e) {
        logger.error("DB", e);
        throw new ServiceException(MsgConstants.E0002, e.getMessage());
    } catch (DbAccessException e) {
        logger.error("DB", e);
        throw new ServiceException(MsgConstants.E0002, e.getMessage());
    }
    return ret;
}

From source file:dao.DatasetsDAO.java

public static boolean isSameColumnCommentExist(String text) {
    boolean exist = false;
    if (StringUtils.isNotBlank(text)) {
        try {//from   w w  w .  ja v a  2s . c o m
            List<Map<String, Object>> comments = getJdbcTemplate().queryForList(CHECK_IF_COLUMN_COMMENT_EXIST,
                    text, text);
            if (comments != null && comments.size() > 0) {
                exist = true;
            }
        } catch (DataAccessException e) {
            Logger.error("Dataset isSameColumnCommentExist text is " + text);
            Logger.error("Exception = " + e.getMessage());
        }
    }
    return exist;
}

From source file:dao.DatasetsDAO.java

public static boolean deleteColumnComment(int datasetId, int columnId, int id) {
    boolean result = false;

    Integer commentCount = getJdbcTemplate().queryForObject(GET_COUNT_COLUMN_COMMENTS_BY_ID,
            new Object[] { datasetId, id }, Integer.class);

    if (commentCount == null || commentCount == 0) {
        result = false;//from  w  w  w  .  jav a2  s . c o  m
    } else if (commentCount == 1) {
        try {
            getJdbcTemplate().update(DELETE_COLUMN_COMMENT_AND_REFERENCE, datasetId, columnId, id);
        } catch (DataAccessException e) {
            result = false;
            Logger.error("Dataset deleteColumnComment remove reference and comment, datasetId = "
                    + Integer.toString(datasetId) + " columnId = " + Integer.toString(columnId));
            Logger.error("Exception = " + e.getMessage());
        }
    } else {
        try {
            getJdbcTemplate().update(DELETE_COLUMN_COMMENT_REFERENCE, datasetId, columnId, id);
        } catch (DataAccessException e) {
            result = false;
            Logger.error("Dataset deleteColumnComment remove reference, datasetId = "
                    + Integer.toString(datasetId) + " columnId = " + Integer.toString(columnId));
            Logger.error("Exception = " + e.getMessage());
        }
    }

    return result;
}

From source file:dao.DatasetsDAO.java

public static List similarColumnComments(Long datasetId, int columnId) {
    List<SimilarComments> comments = new ArrayList<SimilarComments>();
    List<Map<String, Object>> rows = null;
    String fieldName = "";
    try {// ww  w .  j  a v  a 2  s . c  o  m
        fieldName = (String) getJdbcTemplate().queryForObject(GET_COLUMN_NAME_BY_ID, String.class, columnId);
    } catch (DataAccessException e) {
        Logger.error("Dataset similarColumnComments - get field name for columnId, datasetId = "
                + Long.toString(datasetId) + " columnId = " + Integer.toString(columnId));
        Logger.error("Exception = " + e.getMessage());
        return comments;
    }

    try {
        rows = getJdbcTemplate().queryForList(GET_SIMILAR_COMMENTS_BY_FIELD_NAME, fieldName);
        for (Map row : rows) {

            SimilarComments sc = new SimilarComments();
            sc.count = (Long) row.get("count");
            sc.commentId = (Long) row.get("comment_id");
            sc.comment = (String) row.get("comment");
            sc.datasetId = datasetId;
            comments.add(sc);
        }
    } catch (DataAccessException e) {
        Logger.error("Dataset similarColumnComments - get comments by field name, datasetId = "
                + Long.toString(datasetId) + " columnId = " + Integer.toString(columnId));
        Logger.error("Exception = " + e.getMessage());
        return comments;
    }
    return comments;
}

From source file:dao.DatasetsDAO.java

public static boolean assignColumnComment(int datasetId, int columnId, int commentId) {
    Boolean result = false;/*  ww  w .  j  a v  a 2  s.co  m*/
    try {
        getJdbcTemplate().update(SET_COLUMN_COMMENT_TO_FALSE, datasetId, columnId);
    } catch (DataAccessException e) {
        Logger.error("Dataset assignColumnComment - set current default to false, datasetId = "
                + Integer.toString(datasetId) + " columnId = " + Integer.toString(columnId));
        Logger.error("Exception = " + e.getMessage());
        return result;
    }

    try {
        getJdbcTemplate().update(INSERT_DATASET_COLUMN_COMMENT, datasetId, columnId, commentId);
        result = true;
    } catch (DataAccessException e) {
        Logger.error("Dataset assignColumnComment - set current default to false, datasetId = "
                + Integer.toString(datasetId) + " columnId = " + Integer.toString(columnId));
        Logger.error("Exception = " + e.getMessage());
        result = false;
    }
    return result;
}

From source file:dao.DatasetsDAO.java

public static List similarColumns(int datasetId, int columnId) {
    List<SimilarColumns> columns = new ArrayList<SimilarColumns>();
    List<Map<String, Object>> rows = null;
    String fieldName = "";
    try {//www .j  a  v a 2  s .  c o  m
        fieldName = (String) getJdbcTemplate().queryForObject(GET_COLUMN_NAME_BY_ID, String.class, columnId);
    } catch (DataAccessException e) {
        Logger.error("Dataset similarColumns - get field name for columnId, datasetId = "
                + Integer.toString(datasetId) + " columnId = " + Integer.toString(columnId));
        Logger.error("Exception = " + e.getMessage());
        return columns;
    }
    try {
        rows = getJdbcTemplate().queryForList(GET_SIMILAR_COLUMNS_BY_FIELD_NAME, datasetId, fieldName);
        for (Map row : rows) {
            SimilarColumns sc = new SimilarColumns();
            sc.datasetId = (Long) row.get("dataset_id");
            sc.datasetName = (String) row.get("dataset_name");
            sc.columnId = (Long) row.get("field_id");
            sc.dataType = (String) row.get("data_type");
            sc.source = (String) row.get("source");
            sc.commentId = (Long) row.get("comment_id");
            sc.comment = (String) row.get("comment");
            columns.add(sc);
        }
    } catch (DataAccessException e) {
        Logger.error("Dataset similarColumns - get columns by field name, datasetId = "
                + Integer.toString(datasetId) + " columnId = " + Integer.toString(columnId));
        Logger.error("Exception = " + e.getMessage());
        return columns;
    }
    return columns;
}