Fast Testing of MyBatis SQL Without Starting Spring

When you finish writing SQL you need to verify that it works as expected, especially for complex queries, but starting the Spring container can be slow, sometimes taking over 30 seconds.

For isolated SQL testing you can start MyBatis directly with a simple configuration file, avoiding Spring entirely; this dramatically speeds up test execution to about 1–2 seconds.

To add PageHelper pagination support, modify the setUp method to register a PageInterceptor and obtain the mapper from the built SqlSessionFactory:

SqlSessionFactory builder = new SqlSessionFactoryBuilder().build(UserMapperTest.class.getClassLoader().getResourceAsStream("mybatisTestConfiguration/UserMapperTestConfiguration.xml"));
// you can use builder.openSession(false) to not commit to database
PageInterceptor interceptor = new PageInterceptor();
builder.getConfiguration().addInterceptor(interceptor);
mapper = builder.getConfiguration().getMapper(UserMapper.class, builder.openSession(true));

To test MyBatis‑Plus features, replace SqlSessionFactoryBuilder with MybatisSqlSessionFactoryBuilder in the setup method.

For MyBatis‑Plus pagination and optimistic locking, add the corresponding interceptors in a setUpMybatisDatabase method:

@org.junit.BeforeClass
public static void setUpMybatisDatabase() {
    SqlSessionFactory builder = new MybatisSqlSessionFactoryBuilder().build(SymphonyClientMapperTest.class.getClassLoader().getResourceAsStream("mybatisTestConfiguration/SymphonyClientMapperTestConfiguration.xml"));
    final MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
    interceptor.addInnerInterceptor(new OptimisticLockerInnerInterceptor());
    interceptor.addInnerInterceptor(new PaginationInnerInterceptor());
    builder.getConfiguration().addInterceptor(interceptor);
    // you can use builder.openSession(false) to not commit to database
    mapper = builder.getConfiguration().getMapper(SymphonyClientMapper.class, builder.openSession(true));
}

These steps allow rapid testing of MyBatis SQL without the overhead of a full Spring startup.

The article also recommends the MybatisCodeHelperPro IntelliJ plugin, which can automatically generate test Java classes and configuration files, further simplifying the testing workflow.