Add batchQuery methods to JDBCTemplate [SPR-1835]

[spring-projects-issues]

Arthur Branham opened SPR-1835 and commented

For details on the scenario where a batchQuery method would be desireable view this issue:
http://opensource.atlassian.com/projects/spring/browse/SPR-1786

I will attach a file with an implementation of the following methods as well as a sample usage:

public Object[] batchQuery(String sql,final BatchPreparedStatementSetter pss,final ResultSetExtractor rse) throws DataAccessException;

public Object[] batchQuery(String sql,final BatchPreparedStatementSetter pss,final RowCallbackHandler rch) throws DataAccessException;

public Object[] batchQuery(String sql,final BatchPreparedStatementSetter pss,final RowMapper rm) throws DataAccessException ;

---

Affects: 2.0 M3

Attachments:

• JDBCTemplateBatchQueryMethodImpl.txt (2.05 kB)

Issue Links:

• Add batchUpdate method to JDBCTemplate with support for returning generated keys [SPR-1836] #6530 Add batchUpdate method to JDBCTemplate with support for returning generated keys

2 votes, 4 watchers

[spring-projects-issues]

Arthur Branham commented

Attached is a sample implementation of the batchQuery methods. I have used these to execute multiple WHERE IN sql statements while updating the parameter values for each batch statement. This is more efficient since we do not need to recreate the PreparedStatement for each iteration of the batch.

[spring-projects-issues]

Juergen Hoeller commented

Closing groups of outdated issues. Please reopen if still relevant.