[MariaDB] DB 연동하기 (MariaDB, MyBatis)

 

환경 - springboot 2.0 이상, 마리아DB는 버전 상관없음

 

해당 블로그에 자세히 나옴 

https://4urdev.tistory.com/46

 

결론적으로, 마리아db가 Mysql 이랑 똑같기 때문에 어렵지 않게 연결가능

아래 코드는 기존 MSsql커넥션 코드와 똑같음. rdb는 차이가 없을듯함

 

package io.swagger.configuration;
 
import javax.sql.DataSource;
 
import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.SqlSessionTemplate;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.boot.jdbc.DataSourceBuilder;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.core.io.ClassPathResource;
import org.springframework.core.io.support.PathMatchingResourcePatternResolver;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;
import org.springframework.transaction.annotation.EnableTransactionManagement;
 
@Configuration
@EnableTransactionManagement
public class MariaDBConfiguration {
    
    final String mapperlocation = "classpath:mapper/*.xml";
    final String packagelocation = "io.swagger.service.model";
    final String mybatisconfig = "mybatis-configuration.xml";
    
    @Bean(name="mariaContentDataSource")
    @ConfigurationProperties(prefix="maria.content.datasource")
    public DataSource memberDataScource() {
        return DataSourceBuilder.create().build();
    }
    
    @Bean(name="mariaContentSqlSessionFactory")
    public SqlSessionFactory memberSqlSessionFactory(@Qualifier("mariaContentDataSource") DataSource dataSource) throws Exception {
        final SqlSessionFactoryBean sessionFactory = new SqlSessionFactoryBean();
        sessionFactory.setDataSource(dataSource);
        PathMatchingResourcePatternResolver resolver = new PathMatchingResourcePatternResolver();
        sessionFactory.setMapperLocations(resolver.getResources(mapperlocation));
        sessionFactory.setTypeAliasesPackage(packagelocation);
        sessionFactory.setConfigLocation(new ClassPathResource(mybatisconfig));
        return sessionFactory.getObject();
    }
 
    @Bean(name = "mariaContentSqlSessionTemplate")
    public SqlSessionTemplate memberSqlSessionTemplate(@Qualifier("mariaContentSqlSessionFactory") SqlSessionFactory sqlSessionFactory) throws Exception {
      final SqlSessionTemplate sqlSessionTemplate = new SqlSessionTemplate(sqlSessionFactory);
      return sqlSessionTemplate;
    }
 
    @Bean(name = "mariaContentDataSourceTransactionManager")
    public DataSourceTransactionManager membertransactionManager (@Qualifier("mariaContentDataSource") DataSource dataSource){
        DataSourceTransactionManager transactionManager = new DataSourceTransactionManager(dataSource);
        return transactionManager;
    }
 
 
 
}