@Bean(name = "sqlSessionFactory")
    @Primary
    public SqlSessionFactoryBean sqlSessionFactory(
            @Qualifier("dataSource") DataSource ds) {
        SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
        bean.setDataSource(ds);
        bean.setTypeAliasesPackage("com.ai.purchase");
        ResourcePatternResolver resolver = new PathMatchingResourcePatternResolver();
        try {
            bean.setMapperLocations(resolver
                    .getResources("classpath:mybatis/mapper/*.xml"));
        } catch (IOException e) {
            LOG.error("failed to initialize sql Session Factory");
        }
        return bean;
    }