Jdbctemplate query for string: EmptyResultDataAccessException: Incorrect result size: expected 1, actual 0

by

In JdbcTemplate , queryForInt, queryForLong, queryForObject all such methods expects that executed query will return one and only one row. If you get no rows or more than one row that will result in IncorrectResultSizeDataAccessException . Now the correct way is not to catch this exception or EmptyResultDataAccessException, but make sure the query you are using should return only one row. If at all it is not possible then use query method instead.

List<String> strLst = getJdbcTemplate().query(sql, new RowMapper<String>() {
    public String mapRow(ResultSet rs, int rowNum) throws SQLException {
        return rs.getString(1);
    }
});

if (strLst.isEmpty()) {
    return null;
} else if (strLst.size() == 1) { // list contains exactly 1 element
    return strLst.get(0);
} else { // list contains more than 1 element
         // either return 1st element or throw an exception
}

More Related Contents:

  1. How to execute IN() SQL queries with Spring’s JDBCTemplate effectively?
  2. Spring JDBC Template for calling Stored Procedures
  3. NamedParameterJdbcTemplate vs JdbcTemplate
  4. How to use SELECT IN clause in JDBCTemplates?
  5. REST API – DTOs or not? [closed]
  6. Type safety: Unchecked cast
  7. How to define a List bean in Spring?
  8. Spring security CORS Filter
  9. How to inject dependencies into a self-instantiated object in Spring?
  10. Filtering database rows with spring-data-jpa and spring-mvc
  11. Annotation @Transactional. How to rollback?
  12. How do I tell Spring Boot which main class to use for the executable jar?
  13. Spring Boot Actuator application won’t start on Ubuntu VPS
  14. Print all the Spring beans that are loaded
  15. Spring Boot with redirecting with single page angular2
  16. Spring data JPA and hibernate detached entity passed to persist on ManyToMany relationship
  17. why do we have to use @Modifying annotation for queries in Data Jpa
  18. spring creates proxy for wrong classes when using aop class level annotation
  19. How to get bean using application context in spring boot
  20. Maven Resource Filtering with Spring Boot: Could not resolve placeholder
  21. How to handle MaxUploadSizeExceededException
  22. Unable to use Spring Property Placeholders in logback.xml
  23. Where should I put @Transactional annotation: at an interface definition or at an implementing class?
  24. Understanding Spring transactions – What happens when a transactional method calls another transactional method?
  25. spring-data-mongo – optional query parameters?
  26. JSR303 custom validators being called twice
  27. Hibernate, Java 9 and SystemException
  28. SpringBoot ComponentScan issue with multi-module project
  29. Spring Integration manually start/stop channel adapter via control bus
  30. Trigger 404 in Spring-MVC controller?

Leave a Comment