SqlMapClientDaoSupport batch update problem (iBatis).

[ram_2000]

I'm using iBatis SqlMapClientDaoSupport for my DAO.

    public void batchInsertCustomer( final List customerList ) 
    {
    	
    	getSqlMapClientTemplate().execute(new SqlMapClientCallback() {

			public Object doInSqlMapClient(SqlMapExecutor executor)
					throws SQLException {
				
				executor.startBatch();
				
				for &#40;int i = 0; i < customerList.size&#40;&#41;; i++&#41; &#123;
					executor.update&#40;"insertCustomerWithoutKey", customerList.get&#40;i&#41;&#41;;
				&#125;

				int updCount = executor.executeBatch&#40;&#41;;
	            return null;
			&#125;

    	&#125;&#41;;
    &#125;

Even though i'm executing multiple updates within the batch, iBatis is internally doing a 'executeBatch' at the end of the first update. After this all other updates are executed without batch.

iBatis is auto starting a transaction inside the update method and the end of the update it tries to commit the transaction....Since a batch is open, it executes the batch and also closes the batch. 'autostart' of the transaction seems to be the culprit.

After looking though iBatis mailing lists, i found some references to startTransaction() call before startBatch(). Is this required ? And how do i do this with Spring SqlMapClientDaoSupport ?

I'm already using the DataSourceTransactionManager and the transaction is active.

Thanks for your help.

Ram.

[ram_2000]

I had to add getSqlMapClient().startTransaction() call before the start batch call.

Its odd that i have to call startTransaction explicitly even though a local transaction is already active ( using DataSourceTransactionManager).

Is this how its supposed to work ? SqlMapClientTemplate javadoc doesn't include this in the sample.