[jira] [Created] (DBUTILS-129) Add methods to QueryRunner that take Collections or Iterables

["Robert Huffman (JIRA)" <ji...@apache.org>]

Robert Huffman created DBUTILS-129:
--------------------------------------

             Summary: Add methods to QueryRunner that take Collections or Iterables
                 Key: DBUTILS-129
                 URL: https://issues.apache.org/jira/browse/DBUTILS-129
             Project: Commons DbUtils
          Issue Type: Improvement
            Reporter: Robert Huffman


If a prepared statement is built dynamically, with a variable number of parameters, and parameters are in a Collection of some sort instead of an array, usage QueryRunner requires that the collection be converted to an array first. This means the parameters are iterated twice: once to convert to an array and once again in QueryRunner.fillStatement.

It should be straightforward to add insert, execute, and update methods that take Collections. The methods that take arrays can then be re-implemented using the inexpensive Arrays.asList and invoking the new methods.

It would probably be preferable to take Iterables instead of Collections. However, the current implementation of AbstractQueryRunner.fillStatement requires up-front knowledge of the size of the parameter set passed to it, and that is not easily obtained from the Iterable interface. To allow iterables that method would have to be refactored.




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)