jdbctemplate – Page 3

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

December 17, 2022 by Tarik

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 … Read more

How to execute IN() SQL queries with Spring’s JDBCTemplate effectively?

October 20, 2022 by Tarik

You want a parameter source: Set<Integer> ids = …; MapSqlParameterSource parameters = new MapSqlParameterSource(); parameters.addValue(“ids”, ids); List<Foo> foo = getJdbcTemplate().query(“SELECT * FROM foo WHERE a IN (:ids)”, parameters, getRowMapper()); This only works if getJdbcTemplate() returns an instance of type NamedParameterJdbcTemplate