In our application, we use jdbcTemplate and get back the expected: List<Map<...>> as a return type.
When creating a PreparedStatement like this:
preparedStatement = jdbcTemplate.getDataSource().getConnection().prepareStatement("sql statemennt")
it brings back a ResultSet, a totally different data structure. Not what we want.
====
Is there a "spring way" to use a PreparedStatement, but still get back the expected List<Map<...>> data structure?
I'm crafting my own Response from the ResultSet, but it's extremely time consuming.
I'm hoping there's a built-in "Spring way" of using a PreparedStatement and having it return the List<Map<...>> structure.
Appreciate any replies (if possible, with a quick example).
- mike