I've had success using Spring's JDBCTemplate http://static.springsource.org/spring/docs/2.5.6/api/org/springframework/jdbc/core/JdbcTemplate.html#query%28java.l

I've had success using Spring's JDBCTemplate http://static.springsource.org/spring/docs/2.5.6/api/org/springframework/jdbc/core/JdbcTemplate.html#query%28java.lang.String,%20org.springframework.jdbc.core.RowMapper%29 http://static.springsource.org/spring/docs/2.5.6/api/org/spr... and their various RowMappers http://static.springsource.org/spring/docs/2.5.6/api/org/springframework/jdbc/core/BeanPropertyRowMapper.html http://static.springsource.org/spring/docs/2.5.6/api/org/spr...