Inefficiency in queryForList(..) methods of JDBCTemplate

[Talib Jockey]

Why do queryForList(..) methods in the JDBCTemplate class return a List with Maps where the Key=Column Name and Value=Column Value? As I understand it leads to a lot of repetition of column names in the maps. Basically all the Maps will have the same column names, what is the rationale behind returning so many Maps with similar Keys?

Any insight will be appreciated.

Regards,
Talib

[David Newton]

You'd probably want to ask on a Spring list, but I'd imagine it's so each item in the list an be accessed in the same way, and it provides a "common-sense" way of accessing data.

[Hong Anderson]

Hm, I don't quite understand what you mean. Using a map is a way to store result data.
If we don't use map we could use domain object but that requires data mapping.

[Talib Jockey]

So do you think it is a good idea to use this data structure in my application? I want to use something generic, do you see an issue with memory and efficiency because of the column names are repeated multiple times???

Regards,
Talib

[Hong Anderson]

Map is generic enough, could you please to suggest something more generic?

Regarding inefficiency, the implementation could create only one String object and make many instances of Map refer to the same String object. So it's not inefficiency.

[G.Sathish kumar]

Talib Jockey wrote:Why do queryForList(..) methods in the JDBCTemplate class return a List with Maps where the Key=Column Name and Value=Column Value? As I understand it leads to a lot of repetition of column names in the maps. Basically all the Maps will have the same column names, what is the rationale behind returning so many Maps with similar Keys?

Any insight will be appreciated.

Regards,
Talib

i feel it is the best because Programmer no need to bother on the order so i can get the value by passing the column name and when you iterate you need to concentrate on order of data accordingly you generated the query. more over you can get what ever the column data on without iteration.
can i know what is your prefered approch.