Mar 7th, 2013, 01:23 PM
Orderby clause not respected in SimpleJdbcTemplate, MapSqlParameterDataSource
Using SDK 1.6, Spring 2.5 on Win32 with Oracle 11.
The SQL ORDER BY clause seems ineffective in query using SimpleJdbcTemplate.query(String, RowMapper, MapSqlParameterSource).
The ResultSet (List<Person>) is not properly ordered.
When the ':orderby' parameter is replaced with a constant String (for example; last_name, first_name, department, ...) the query ResultSet ordering is effective.
The referenced 'PeopleTableRowMapper' symbol is static class implementing ParameterizedRowMapper
Assistance is appreciated,
Please See attached Source :
Tags for this Thread