How can I convert mybatis setting to java base config

Question

Yeah, I mean pure java. I have my mybatis configed like this. Now most of my project is using java base config but mybatis.

<configuration>
    <settings>
        <setting name="cacheEnabled" value="true" />
        <setting name="lazyLoadingEnabled" value="true" />
        <setting name="multipleResultSetsEnabled" value="true" />
        <setting name="useColumnLabel" value="true" />
        <setting name="useGeneratedKeys" value="false" />
        ...
    </settings>
</configuration>

How can I config these in java file? This below is my db config.

@Configuration
@MapperScan("com.xxxx.basis.dao")
public class DBConfig {
    @Resource
    private Environment env;

    @Bean(destroyMethod = "close")
    public DruidDataSource dataSource() {
        DruidDataSource dataSource = new DruidDataSource();
        // ...
        return dataSource;
    }

    @Bean
    public DataSourceTransactionManager transactionManager() {
        return new DataSourceTransactionManager(dataSource());
    }

    @Bean
    public SqlSessionFactoryBean sqlSessionFactory() throws Exception {
        SqlSessionFactoryBean sessionFactory = new SqlSessionFactoryBean();
        sessionFactory.setDataSource(dataSource());
        sessionFactory.setTypeAliasesPackage("com.xxx.basis.domain");
        return sessionFactory;
    }

}

I think it is not possible....No where it has mentioned that sqlmap config file can be in java..even in mybatis documentation we can see only xml configuration. — Prasanna Kumar H A, Oct 26 '16 at 12:06
Thanks. I think importing the xml file in java file is the only way.@PrasannaKumar — Gabriel.ge, Oct 28 '16 at 06:16

score 0 · Answer 1 · answered Feb 08 '17 at 08:59

@Bean public SqlSessionFactoryBean sqlSessionFactory() {

    SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean();
    sqlSessionFactoryBean.setConfigLocation(applicationContext.getResource("classpath:mybatis.xml"));
    sqlSessionFactoryBean.setDataSource(dataSource());
    return sqlSessionFactoryBean;
}

score 0 · Answer 2 · answered Mar 23 '17 at 04:57

Try this.

SqlSessionFactoryBean sessionFactory = new SqlSessionFactoryBean();
sessionFactory.setDataSource(dataSource());
sessionFactory.setTypeAliasesPackage("com.xxx.basis.domain");

SqlSessionFactory factory = sessionFactory.getObject();
factory.getConfiguration().setCacheEnabled(true);
factory.getConfiguration().setUseColumnLabel(true);
return sessionFactory;

How can I convert mybatis setting to java base config

2 Answers2