title: Java Programming - Spring and JDBCTemplate - Use query, queryForList or queryForRowSet?
body: <p>My Java (JDK6) project uses <a href="http://en.wikipedia.org/wiki/Spring_Framework" rel="noreferrer">Spring</a> and <a href="http://static.springsource.org/spring/docs/3.0.x/javadoc-api/org/springframework/jdbc/core/JdbcTemplate.html" rel="noreferrer">JDBCTemplate</a> for all its database access. We recently upgraded from Spring 2.5 to Spring 3 (RC1). The project does not use an ORM like <a href="http://en.wikipedia.org/wiki/Hibernate_%28Java%29" rel="noreferrer">Hibernate</a> nor <a href="http://en.wikipedia.org/wiki/EJB" rel="noreferrer">EJB</a>.</p>
  
  <p>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</p>
  
  <p>What should be the criteria to use one instead of the other? Are there any performance differences? Best practices? </p>
  
  <p>Can you recommend some external references for further research on this topic?</p>