-
Mar 7th, 2013, 01:23 PM
#1
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 :
SelectPeopleByEmailGroup.txt
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules