Example usage for org.springframework.dao EmptyResultDataAccessException getMessage

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

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

Introduction

In this page you can find the example usage for org.springframework.dao EmptyResultDataAccessException 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:dao.SearchDAO.java

public static ObjectNode getPagedJobByKeyword(String category, String keyword, int page, int size) {
    final List<FlowJob> pagedFlowJobs = new ArrayList<FlowJob>();
    final JdbcTemplate jdbcTemplate = getJdbcTemplate();
    javax.sql.DataSource ds = jdbcTemplate.getDataSource();
    DataSourceTransactionManager tm = new DataSourceTransactionManager(ds);

    TransactionTemplate txTemplate = new TransactionTemplate(tm);

    ObjectNode result;//ww w .  ja  va2  s .c  om
    result = txTemplate.execute(new TransactionCallback<ObjectNode>() {
        public ObjectNode doInTransaction(TransactionStatus status) {
            String query = SEARCH_JOB_WITH_PAGINATION.replace("$keyword", keyword);
            List<Map<String, Object>> rows = null;

            rows = jdbcTemplate.queryForList(query, (page - 1) * size, size);
            for (Map row : rows) {

                FlowJob flowJob = new FlowJob();
                flowJob.flowId = (Long) row.get(FlowRowMapper.FLOW_ID_COLUMN);
                flowJob.jobId = (Long) row.get(FlowRowMapper.JOB_ID_COLUMN);
                flowJob.jobName = (String) row.get(FlowRowMapper.JOB_NAME_COLUMN);
                flowJob.jobPath = (String) row.get(FlowRowMapper.JOB_PATH_COLUMN);
                flowJob.jobType = (String) row.get(FlowRowMapper.JOB_TYPE_COLUMN);
                flowJob.flowName = (String) row.get(FlowRowMapper.FLOW_NAME_COLUMN);
                flowJob.flowPath = (String) row.get(FlowRowMapper.FLOW_PATH_COLUMN);
                flowJob.flowGroup = (String) row.get(FlowRowMapper.FLOW_GROUP_COLUMN);
                flowJob.appCode = (String) row.get(FlowRowMapper.APP_CODE_COLUMN);
                flowJob.appId = (Integer) row.get(FlowRowMapper.APP_ID_COLUMN);
                flowJob.displayName = flowJob.jobName;
                flowJob.link = "#/flows/name/" + flowJob.appCode + "/" + Long.toString(flowJob.flowId)
                        + "/page/1?urn=" + flowJob.flowGroup;
                flowJob.path = flowJob.appCode + "/" + flowJob.jobPath;

                pagedFlowJobs.add(flowJob);
            }
            long count = 0;
            try {
                count = jdbcTemplate.queryForObject("SELECT FOUND_ROWS()", Long.class);
            } catch (EmptyResultDataAccessException e) {
                Logger.error("Exception = " + e.getMessage());
            }

            ObjectNode resultNode = Json.newObject();
            resultNode.put("count", count);
            resultNode.put("isFlowJob", true);
            resultNode.put("page", page);
            resultNode.put("category", category);
            resultNode.put("itemsPerPage", size);
            resultNode.put("totalPages", (int) Math.ceil(count / ((double) size)));
            resultNode.set("data", Json.toJson(pagedFlowJobs));

            return resultNode;
        }
    });

    return result;
}

From source file:dao.SearchDAO.java

public static ObjectNode getPagedCommentsByKeyword(String category, String keyword, int page, int size) {
    List<Dataset> pagedDatasets = new ArrayList<Dataset>();
    final JdbcTemplate jdbcTemplate = getJdbcTemplate();
    javax.sql.DataSource ds = jdbcTemplate.getDataSource();
    DataSourceTransactionManager tm = new DataSourceTransactionManager(ds);

    TransactionTemplate txTemplate = new TransactionTemplate(tm);

    ObjectNode result;/*from www . j a v  a2 s. co m*/
    result = txTemplate.execute(new TransactionCallback<ObjectNode>() {
        public ObjectNode doInTransaction(TransactionStatus status) {
            List<Map<String, Object>> rows = null;
            String query = SEARCH_DATASET_BY_COMMENTS_WITH_PAGINATION.replace("$keyword", keyword);
            rows = jdbcTemplate.queryForList(query, (page - 1) * size, size);

            for (Map row : rows) {

                Dataset ds = new Dataset();
                ds.id = (long) row.get(DatasetRowMapper.DATASET_ID_COLUMN);
                ds.name = (String) row.get(DatasetRowMapper.DATASET_NAME_COLUMN);
                ds.source = (String) row.get(DatasetRowMapper.DATASET_SOURCE_COLUMN);
                ds.urn = (String) row.get(DatasetRowMapper.DATASET_URN_COLUMN);
                ds.schema = (String) row.get(DatasetRowMapper.DATASET_SCHEMA_COLUMN);
                pagedDatasets.add(ds);
            }
            long count = 0;
            try {
                count = jdbcTemplate.queryForObject("SELECT FOUND_ROWS()", Long.class);
            } catch (EmptyResultDataAccessException e) {
                Logger.error("Exception = " + e.getMessage());
            }

            ObjectNode resultNode = Json.newObject();
            resultNode.put("count", count);
            resultNode.put("page", page);
            resultNode.put("category", category);
            resultNode.put("itemsPerPage", size);
            resultNode.put("totalPages", (int) Math.ceil(count / ((double) size)));
            resultNode.set("data", Json.toJson(pagedDatasets));

            return resultNode;
        }
    });

    return result;
}

From source file:dao.TrackingDAO.java

public static String addTrackingEvent(JsonNode requestNode, String user) {
    String message = "Internal error";
    if (requestNode == null || (!requestNode.isContainerNode())) {
        return "Empty post body";
    }/*from   w w w. j a  va2 s  . c o  m*/

    Long accessTime = 0L;
    if (requestNode.has(TRACKING_ACCESS_UNIX_TIME_COLUMN)) {
        accessTime = requestNode.get(TRACKING_ACCESS_UNIX_TIME_COLUMN).asLong();
    } else {
        return "Missing " + TRACKING_ACCESS_UNIX_TIME_COLUMN;
    }

    String objectType = "";
    if (requestNode.has(TRACKING_OBJECT_TYPE_COLUMN)) {
        objectType = requestNode.get(TRACKING_OBJECT_TYPE_COLUMN).asText();
    } else {
        return "Missing " + TRACKING_OBJECT_TYPE_COLUMN;
    }

    Long objectId = 0L;
    if (requestNode.has(TRACKING_OBJECT_ID_COLUMN)) {
        objectId = requestNode.get(TRACKING_OBJECT_ID_COLUMN).asLong();
    } else {
        return "Missing " + TRACKING_OBJECT_ID_COLUMN;
    }

    String objectName = "";
    if (requestNode.has(TRACKING_OBJECT_NAME_COLUMN)) {
        objectName = requestNode.get(TRACKING_OBJECT_NAME_COLUMN).asText();
    } else {
        return "Missing " + TRACKING_OBJECT_NAME_COLUMN;
    }

    String parameters = "";
    if (requestNode.has(TRACKING_PARAMETERS_COLUMN)) {
        parameters = requestNode.get(TRACKING_PARAMETERS_COLUMN).asText();
    } else {
        return "Missing " + TRACKING_PARAMETERS_COLUMN;
    }

    Integer userId = 0;
    if (StringUtils.isNotBlank(user)) {
        try {
            userId = (Integer) getJdbcTemplate().queryForObject(GET_USER_ID, Integer.class, user);
        } catch (EmptyResultDataAccessException e) {
            Logger.error("TrackingDAO addTrackingEvent get user id failed, username = " + user);
            Logger.error("Exception = " + e.getMessage());
        }
    }

    if (userId != null && userId > 0) {
        try {
            int row = getJdbcTemplate().update(ADD_TRACKING_EVENT, accessTime, userId, objectType, objectId,
                    objectName, parameters);
            if (row > 0) {
                message = "";
            }
        } catch (Exception e) {
            message = e.getMessage();
        }
    } else {
        message = "User not found";
    }
    return message;
}

From source file:dao.UserDAO.java

public static User getCurrentUser(String username) {
    User user = new User();
    try {/*from   ww  w .jav  a  2  s  .  c  o  m*/
        if (StringUtils.isNotBlank(username)) {
            user = (User) getJdbcTemplate().queryForObject(GET_CURRENT_USER_INFO, new UserRowMapper(),
                    username);
        }
    } catch (EmptyResultDataAccessException e) {
        Logger.error("UserDAO getCurrentUser failed, username = " + username);
        Logger.error("Exception = " + e.getMessage());
    }

    return user;
}

From source file:dao.UserDAO.java

public static Integer getUserIDByUserName(String userName) {
    Integer userId = 0;/*from  w w  w .j av a 2  s.  c o  m*/
    if (StringUtils.isNotBlank(userName)) {
        try {
            userId = (Integer) getJdbcTemplate().queryForObject(GET_USER_ID, Integer.class, userName);
        } catch (EmptyResultDataAccessException e) {
            userId = 0;
            Logger.error("Get user id failed, user name = " + userName);
            Logger.error("Exception = " + e.getMessage());
        }
    }

    return userId;
}

From source file:dao.UserDAO.java

public static String updateUserSettings(Map<String, String[]> settings, String user) {
    String message = "Internal error";
    if (settings == null || settings.size() == 0) {
        return "Empty post body";
    }//from w  w  w  . j  a  v a 2  s  . co  m

    String defaultView = "";
    if (settings.containsKey("detail_default_view")) {
        String[] defaultViewArray = settings.get("detail_default_view");
        if (defaultViewArray != null && defaultViewArray.length > 0) {
            defaultView = defaultViewArray[0];
        }
    }
    String defaultWatch = "";
    if (settings.containsKey("default_watch")) {
        String[] defaultWatchArray = settings.get("default_watch");
        if (defaultWatchArray != null && defaultWatchArray.length > 0) {
            defaultWatch = defaultWatchArray[0];
        }
    }
    Integer userId = 0;
    if (StringUtils.isNotBlank(user)) {
        try {
            userId = (Integer) getJdbcTemplate().queryForObject(GET_USER_ID, Integer.class, user);
        } catch (EmptyResultDataAccessException e) {
            Logger.error("UserDAO updateUserSettings get user id failed, username = " + user);
            Logger.error("Exception = " + e.getMessage());
        }
    }
    if (userId != null && userId > 0) {
        if (StringUtils.isBlank(defaultView)) {
            defaultView = DEFAULT_DETAIL_VIEW;
        }

        if (StringUtils.isBlank(defaultWatch)) {
            defaultWatch = DEFAULT_WATCH;
        }

        int row = getJdbcTemplate().update(UPDATE_USER_SETTINGS, userId, defaultView, defaultWatch, defaultView,
                defaultWatch);
        if (row > 0) {
            message = "";
        }
    } else {
        message = "User not found";
    }
    return message;
}

From source file:org.fao.geonet.component.csw.GetCapabilities.java

/**
 * TODO javadoc./*from   w  w w .j a  v a  2s  .  co  m*/
 */
public Element execute(Element request, ServiceContext context) throws CatalogException {

    checkService(request);
    checkAcceptVersions(request);

    GeonetContext gc = (GeonetContext) context.getHandlerContext(Geonet.CONTEXT_NAME);
    boolean inspireEnabled = gc.getBean(SettingManager.class).getValueAsBool(Settings.SYSTEM_INSPIRE_ENABLE,
            false);

    //--- return capabilities

    Path file;

    if (inspireEnabled) {
        file = context.getAppPath().resolve("xml").resolve("csw").resolve("capabilities_inspire.xml");
    } else {
        file = context.getAppPath().resolve("xml").resolve("csw").resolve("capabilities.xml");
    }

    try {
        Element capabilities = Xml.loadFile(file);
        ServletContext servletContext = null;
        if (context.getServlet() != null) {
            servletContext = context.getServlet().getServletContext();
        }
        ConfigurationOverrides.DEFAULT.updateWithOverrides(file.toString(), servletContext,
                context.getAppPath(), capabilities);

        String cswServiceSpecificContraint = request.getChildText(Geonet.Elem.FILTER);
        setKeywords(capabilities, context, cswServiceSpecificContraint);
        setOperationsParameters(capabilities);

        String currentLanguage = "";

        // INSPIRE: Use language parameter if available, otherwise use default (using context.getLanguage())
        if (inspireEnabled) {
            String isoLangParamValue = request.getAttributeValue("language");

            final LanguageRepository languageRepository = context.getBean(LanguageRepository.class);
            List<Language> languageList = languageRepository.findAllByInspireFlag(true);

            List<String> langCodes = Lists.transform(languageList, new Function<Language, String>() {
                @Nullable
                @Override
                public String apply(@Nonnull Language input) {
                    return input.getId();
                }
            });

            if (isoLangParamValue != null) {
                // Retrieve GN language id from Iso language id
                if (langCodes.contains(isoLangParamValue)) {
                    currentLanguage = isoLangParamValue;
                }
            }

            String defaultLanguageId = context.getLanguage();
            try {
                Language defaultLanguage = languageRepository.findOneByDefaultLanguage();

                if (StringUtils.isEmpty(currentLanguage)) {
                    currentLanguage = defaultLanguage.getId();
                    defaultLanguageId = defaultLanguage.getId();
                }
            } catch (EmptyResultDataAccessException e) {
                Log.error(Geonet.CSW,
                        "No default language set in database languages table. "
                                + "You MUST set one default language (using isDefault column). "
                                + "Using session language as default. Error is: " + e.getMessage());
                currentLanguage = context.getLanguage();
            }

            setInspireLanguages(capabilities, langCodes, currentLanguage, defaultLanguageId);
        } else {
            currentLanguage = context.getLanguage();
        }

        final CswCapabilitiesInfoFieldRepository infoRepository = context
                .getBean(CswCapabilitiesInfoFieldRepository.class);
        CswCapabilitiesInfo cswCapabilitiesInfo = infoRepository.findCswCapabilitiesInfo(currentLanguage);

        // Retrieve contact data from users table
        String contactId = gc.getBean(SettingManager.class).getValue(Settings.SYSTEM_CSW_CONTACT_ID);
        if ((contactId == null) || (contactId.equals(""))) {
            contactId = "-1";
        }
        User user = context.getBean(UserRepository.class).findOne(contactId);

        substitute(context, capabilities, cswCapabilitiesInfo, user, currentLanguage);

        handleSections(request, capabilities);

        //
        // in read-only mode, remove publication services from capabilities
        //
        if (gc.isReadOnly()) {
            capabilities = removePublicationServices(capabilities);
        }

        return capabilities;
    } catch (Exception e) {
        Log.error(Geonet.CSW, "Cannot load/process capabilities");
        Log.error(Geonet.CSW, " (C) StackTrace\n" + Util.getStackTrace(e));

        throw new NoApplicableCodeEx("Cannot load/process capabilities");
    }
}

From source file:org.mifosplatform.infrastructure.dataqueries.service.ReadWriteNonCoreDataServiceImpl.java

private int getCodeIdForColumn(final String dataTableNameAlias, final String name) {
    final StringBuilder checkColumnCodeMapping = new StringBuilder();
    checkColumnCodeMapping/*from   w  w  w  . j  a  v a 2s  .  c  o  m*/
            .append("select ccm.code_id from x_table_cloumn_code_mappings ccm where ccm.column_alias_name='")
            .append(dataTableNameAlias).append("_").append(name).append("'");
    int codeId = 0;
    try {
        codeId = this.jdbcTemplate.queryForInt(checkColumnCodeMapping.toString());
    } catch (final EmptyResultDataAccessException e) {
        logger.info(e.getMessage());
    }
    return codeId;
}

From source file:org.mxhero.engine.plugin.attachmentlink.fileserver.servlet.DownloadAll.java

public void doAction(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException {
    ContentService service = null;//w w w . j a  va2  s  . com
    Long idToSearch = null;
    String id = request.getParameter("id");
    String recipient = request.getParameter("recipient");
    MDC.put("message", id);
    List<ContentDTO> contents = null;
    try {
        if (StringUtils.isEmpty(id)) {
            log.debug("Error. No params in URL present. Forwarding to error URL page");
            request.getRequestDispatcher("/errorParams.jsp").forward(request, response);
        } else {
            ApplicationContext context = WebApplicationContextUtils
                    .getWebApplicationContext(getServletContext());
            StandardPBEStringEncryptor encryptor = (StandardPBEStringEncryptor) context.getBean("encryptor");
            String decrypt = encryptor.decrypt(id);
            idToSearch = Long.valueOf(decrypt);
            log.debug("Trying dowload all files for messageId " + idToSearch);
            service = context.getBean(ContentService.class);
            contents = service.getContentList(idToSearch, recipient);
            if (contents == null || contents.size() < 1) {
                throw new EmptyResultDataAccessException(1);
            }
            // Set the content type based to zip
            response.setContentType("Content-type: text/zip");
            response.setHeader("Content-Disposition", "attachment; filename=allFiles.zip");

            ServletOutputStream out = response.getOutputStream();
            ZipOutputStream zos = new ZipOutputStream(new BufferedOutputStream(out));
            Set<String> addedFiles = new HashSet<String>();

            for (ContentDTO content : contents) {
                boolean alreadyThere = false;
                for (String addedFile : addedFiles) {
                    if (addedFile.equalsIgnoreCase(content.getFileName())) {
                        alreadyThere = true;
                        break;
                    }
                }
                if (alreadyThere) {
                    continue;
                }
                addedFiles.add(content.getFileName());
                log.debug("Adding file " + content.getFileName());
                zos.putNextEntry(new ZipEntry(content.getFileName()));

                // Get the file
                InputStream fis = null;
                try {
                    fis = content.getInputStream();
                } catch (FileNotFoundException fnfe) {
                    // If the file does not exists, write an error entry instead of
                    // file
                    // contents
                    zos.write(("ERROR: Could not find file " + content.getFileName()).getBytes());
                    zos.closeEntry();
                    log.warn("Could not find file " + content.getPath());
                    continue;
                }

                BufferedInputStream fif = new BufferedInputStream(fis);

                // Write the contents of the file
                int data = 0;
                while ((data = fif.read()) != -1) {
                    zos.write(data);
                }
                fif.close();

                zos.closeEntry();
                log.debug("Finished adding file " + content.getFileName());
            }

            zos.close();

            for (ContentDTO content : contents) {
                service.successContent(content.getIdMessageAttach());
            }

        }
    } catch (EmptyResultDataAccessException e) {
        log.debug("Content not more available. Forwarding to not available page");
        request.getRequestDispatcher("/contentNotAvailable.jsp").forward(request, response);
    } catch (Exception e) {
        if (contents != null) {
            for (ContentDTO content : contents) {
                try {
                    service.failDownload(content.getIdMessageAttach());
                } catch (Exception e2) {
                }
            }
        }
        log.error("Exception: " + e.getClass().getName());
        log.error("Message Exception: " + e.getMessage());
        log.debug("Error General. Forwarding to page error general");
        request.getRequestDispatcher("/error.jsp").forward(request, response);
    } finally {
        MDC.put("message", id);
    }
}

From source file:org.mxhero.engine.plugin.attachmentlink.fileserver.servlet.Unsubscribe.java

private void doAction(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
    ContentService service = null;/*from   w  w w  .j  a  va2s  . com*/
    Long idToSearch = null;
    String id = req.getParameter("id");
    MDC.put("message", id);
    try {
        if (StringUtils.isEmpty(id)) {
            log.debug("Error. No params in URL present. Forwarding to error URL page");
            req.getRequestDispatcher("/errorParams.jsp").forward(req, resp);
        } else {
            ApplicationContext context = WebApplicationContextUtils
                    .getWebApplicationContext(getServletContext());
            StandardPBEStringEncryptor encryptor = (StandardPBEStringEncryptor) context.getBean("encryptor");
            String decrypt = encryptor.decrypt(id);
            idToSearch = Long.valueOf(decrypt);
            log.debug("Trying update files for messageId " + idToSearch);
            service = context.getBean(ContentService.class);
            service.unsubscribe(idToSearch);
            req.getRequestDispatcher("/unsubscribe.jsp").forward(req, resp);
        }
    } catch (EmptyResultDataAccessException e) {
        log.debug("Content not more available. Forwarding to not available page");
        req.getRequestDispatcher("/contentNotAvailable.jsp").forward(req, resp);
    } catch (Exception e) {
        log.error("Exception: " + e.getClass().getName());
        log.error("Message Exception: " + e.getMessage());
        log.debug("Error General. Forwarding to page error general");
        req.getRequestDispatcher("/error.jsp").forward(req, resp);
    } finally {
        MDC.put("message", id);
    }
}