title: Mybatis Spring multiple databases Java configuration
body: <p>I'm working with Spring and Mybatis and I have two databases, the configuration for the first database was relative easy, but I can't get to work the second database with Spring and transactions, here is my code</p>
  
  <pre><code>@Configuration
  @ComponentScan(basePackages = {"hernandez.service", "hernandez.dao"})
  @EnableTransactionManagement
  @MapperScan(basePackages="hernandez.mapper" ) 
  @Import(DbConfig2.class)
  public class AppConfig {
  
  @Bean(name = "dataSource")
  public DataSource dataSource() {
      DriverManagerDataSource ds = new DriverManagerDataSource("com.mysql.jdbc.Driver",
              "jdbc:mysql://localhost:3306/northwind", "root", "");
      return ds;
  }
  
  @Bean
  public SqlSessionFactoryBean sqlSessionFactory() {
      SqlSessionFactoryBean factoryBean = new SqlSessionFactoryBean();
      factoryBean.setDataSource(dataSource()); 
      return factoryBean;
  }
  
  @Bean(name = "transactionManager")
  public PlatformTransactionManager transactionManager() {
      return new DataSourceTransactionManager(dataSource());
  }
  }
  
  @Configuration
  @MapperScan("loli.mapper" ) 
  public class DbConfig2 {
  @Bean(name = "dataSource_2")
  public DataSource dataSource2() {
      DriverManagerDataSource ds = new DriverManagerDataSource("com.mysql.jdbc.Driver",
              "jdbc:mysql://localhost:3306/dmsolut_dmsms", "root", "");
      return ds;
  }
  
  @Bean
  public SqlSessionFactory sqlSessionFactory2() throws Exception{
      SqlSessionFactoryBean factoryBean = new SqlSessionFactoryBean();
      factoryBean.setDataSource(dataSource2());
      return factoryBean.getObject();
  }
  
  @Bean(name = "transactionManager_2")
  public PlatformTransactionManager transactionManager() {
      return new DataSourceTransactionManager(dataSource2());
  }
  }
  </code></pre>
  
  <p>Is there a way to get this working with pure Spring Java configuration or at least with some XML? There's no official documentation to get two databases working in the Mybatis-Spring project </p>