commons-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Yair Lenga (JIRA)" <>
Subject [jira] [Created] (DBUTILS-132) Enable MultiQuery statements
Date Sat, 10 Dec 2016 22:04:58 GMT
Yair Lenga created DBUTILS-132:

             Summary: Enable MultiQuery statements
                 Key: DBUTILS-132
             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 statement.

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