My Java (JDK6) project uses Spring and JDBCTemplate for all its database access. We recently upgraded from Spring 2.5 to Spring 3 (RC1). The project does not use an ORM like Hibernate nor EJB.

If I need to read a bunch of records, and do some internal processing with them, it seems like there are several (overloaded) methods: query, queryForList and queryForRowSet

What should be the criteria to use one instead of the other? Are there any performance differences? Best practices?

Can you recommend some external references for further research on this topic?

java spring recordset jdbctemplate
Edit
Report