Thanks Clinton,
Yep that has the desired effect, however, I'm running this in the EJB layer
with container managed transactions. Do you know how startTransaction() /
endTransaction() behave in this situation?
Gary
You need to wrap the batch in a transaction....
try {
sqlMapClient.startTransaction();
sqlMapClient.startBatch();
...
sqlMapClient.executeBatch();
sqlMapClient.commitTransaction();
} finally {
sqlMapClient.endTransaction
}
Clinton
On 10/18/05, Gary Barlow <[EMAIL PROTECTED]> wrote:
>
> Hi there, I'm using v2.1.5 with spring and attempting to use batched
> statements but it doesn't seem to batch! The code below functions fine
but
> when testing for duplicate inserts I noticed if failed on the insert
> rather
> than the executeBatch() statement. This suggests it's not batching! Also
> noticed that the count returned from execute batch is always zero.
>
> Have I coded this corrrectly? Are there any know issues?
>
> public class SqlMapParameterDao extends SqlMapClientDaoSupport
implements
> ParameterDao {
>
> ............................
>
> public void saveParameterValues(final Parameter parameter, final List
> vals)
> throws IntegrityViolationException {
> try {
>
> this.getSqlMapClient().startBatch();
> for (int i = 0; i < pvals.size(); i++) {
> ParameterValue parameterValue = (ParameterValue) pvals.get(i);
> this.getSqlMapClient().insert("insertParameterValue", new
> ParameterValueCriteria(parameterValue.getParameter().getId(),
> parameterValue));
> }
> int count = this.getSqlMapClient().executeBatch();
> } catch (SQLException e) {
> throw new IntegrityViolationException(e.getMessage());
> }
> }
>
>
>
