Identical approach to implement "getSqlMapClientTemplate().execute(new SqlMapClientCallback()" in Mybatis Edit CommentAgile Board MoreReopen Issue

[CodeCanvas19]

Hi
We are migrating from ibatis to mybatis 3.4.4. And in ibatis we have perform execute method in below formate using sqlcallbackmethod.

getSqlMapClientTemplate().execute(new SqlMapClientCallback() {
    public Object doInSqlMapClient(SqlMapExecutor executor) throws SQLException {
        executor.startBatch();
        executor.insert("TestInsert", testObject) }
        executor.executeBatch();
        return null;
    }
});

is there identical method implementation with mybatis-spring version 1.31. and mybatis version 3.4.5. This is blocker, please help.
Currently i am not able to find alternative method in mybatis document.

[jeffgbutler]

Are you just trying to execute a batch? If so, the FAQ has an example of executing in MyBatis:

https://github.com/mybatis/mybatis-3/wiki/FAQ#how-do-i-code-a-batch-insert

[kazuki43zoo]

@jeffgbutler 👍

Example for Spring style:

@Configuration
public class MyBatisConfig {

    // ...

    @Bean
    public SqlSessionTemplate batchModeSqlSession(SqlSessionFactory sqlSessionFactory) {
        return new SqlSessionTemplate(sqlSessionFactory, ExecutorType.BATCH); // Specify ExecutorType.BATCH
    }
}

@Autowired
SqlSession batchModeSqlSession; // Inject an instance of SqlSessionTemplate

@Transactional // Specify transaction boundary using annotation
public void insert(List<Foo> foos) {
    foos.forEach(foo -> sqlSession.insert("insertFoo", foo));
}

[CodeCanvas19]

Thanks @kazuki43zoo this will help to resolve one problem.
Could you please share a sample example for spring and mybatis using callbackMethod. Below is ibatis code snippet.
getSqlMapClientTemplate().execute(new SqlMapClientCallback() {
public Object doInSqlMapClient(SqlMapExecutor executor)
throws SQLException
{ executor.startBatch(); executor.insert("TestInsert", testObject) }
executor.executeBatch();
return null;
}
});

we don't have sqlMapClientTemplate and sqlMapcallback Method in jar 1.3.1

[kazuki43zoo]

Hi @mnirmit ,

You should be understanding that the SqlMapClientTemplate and SqlMapClientCallback provide from the spring framework(until 3.2.x) for integrating spring and ibatis(mybatis 2). Therefore, these classes not included in mybatis-spring.

I've introduced "how to implements batch mode using mybatis-spring" in above comment already. It has been introduced in reference document of mybatis-spring.

I've closed this issue. If you have more questions, please post new topic on the mailing list.

Note:
If you have a question, please post it to the mailing list rather than GitHub issue. The GitHub Issue manages only bug report and new feature request.

Thanks.

[clockwiser]

Here is an example. But it commits directly inside the batch function.

https://www.javatips.net/api/bpm-adapter-master/bpm-adapter-db/src/main/java/org/bpm/db/BpmBaseDao.java

protected int batchInsert(List insertObjects , String statement , Integer batchSize){
SqlSession sqlSession = this.sqlSessionTemplate.getSqlSessionFactory().openSession(ExecutorType.BATCH);
if (batchSize == null || batchSize == 0){
batchSize = BATCH_SIZE ;
}
int execCount = 0;
for (int i = 0 , size = insertObjects.size(); i < size ; i++){
sqlSession.insert(statement , insertObjects);
if ((i != 0 && i % batchSize == 0) || i == size -1){
List batchResults = sqlSession.flushStatements();
execCount = batchResults.size() ;
sqlSession.commit();
sqlSession.clearCache();
LOGGER.debug("batch insert , current commit size : {} " , execCount );
}
}
sqlSession.close();
return execCount ;
}