Thread: Cannot run query without RowMapper

Hi,
I ran to this problem while trying to use JDBCtemplate queryForList(String query) method. This should return List<Map<String, Obkect>>.
At first my query is simple :
select * from employee where group_id in (1)
And it ran perfect.

After that, I try this :
select * from employee where group_id in (1,2,3,4,..., 124)
And it's stuck (It stopped, no error, no exception, even if I debug, it just stopped at queryForList and cannot move down to the code below). However, as I added in to queryForList a RowMapper<Employee>, everything ran smoothly.

So I have a question, what's wrong with mapping data retrieved manually without RowMapper ?

I do this :

String query = select * from employee where group_id in (1,2,3,4,..., 124);
List<Map<String, Object>> rows = getJdbcTemplate().queryForList(query);
 
for (Map<String, Object> row : rows) {
			Employee empl = new Employee();
			empl.setId(Long.parseLong(row.get("ID").toString()));
			empl.setGroupId(Long.parseLong(row.get("GROUP_ID").toString()));
			empl.setVisa((String) row.get("VISA"));
 
			list.add(empl);
		}

and it stuck at queryForList.

However it ran perfectly for

query = select * from employee where group_id in (1);