commons-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Gary Gregory (JIRA)" <>
Subject [jira] [Commented] (DBUTILS-132) Enable MultiQuery statements
Date Sat, 19 Aug 2017 18:29:00 GMT


Gary Gregory commented on DBUTILS-132:

Patches with unit test are welcome!

> Enable MultiQuery statements
> ----------------------------
>                 Key: DBUTILS-132
>                 URL:
>             Project: Commons DbUtils
>          Issue Type: Improvement
>    Affects Versions: 1.6
>            Reporter: Yair Lenga
>            Priority: Minor
> The "batch" interface make it possible to perform repeated statements - updated, delete
or insert, based on a statement with placeholders, and provide major speedup over simple updated.
> The request is to extend the support for multiple statement, so that it will be possible
to pass repeated data sets into the query. Instead of taking Object ... params, it should
take Object [] [] params, and should iterate over the input parameters, on the same prepared
> The new method signature:
> public <T> List<T>  [More ...] query(String sql, ResultSetHandler<T>
rsh, Object... params)
> My testing (straight JDBC against Sybase ASE) showed that reusing the preparedStatemet
should provide significant benefits - because it will eliminate the prepared statement setup,
and allow sybase to optimize the call.
> I will be happy to help with development or testing.

This message was sent by Atlassian JIRA

View raw message