mariadb - 전자정부프레임워크

Version

• mariadb Ver 15.1 Distrib 10.1.48-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2
  
  

pom.xml

• MariaDB 관련 Dependency 추가
  ojdbc : 오라클 -> 제거
  mysql -> mariadb로 수정

mysql-connector은 필요하다는 사람 있고, 필요없다는 사람도 있음.

mariadb-java-client

• 서버의 Java version : 1.8 -> 2.7 정도가 무난할듯.
  -> mariadb 2.7.3 사용

context-datasource.xml

context-mapper.xml

원본

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd">

	<!-- SqlSession setup for MyBatis Database Layer -->
	<bean id="sqlSession" class="org.mybatis.spring.SqlSessionFactoryBean">
		<property name="dataSource" ref="dataSource" />
		<property name="configLocation" value="classpath:/egovframework/sqlmap/mysql/sql-map-config.xml" /><!-- egovMap Type Alias 설정 -->
		<property name="mapperLocations" value="classpath:/egovframework/sqlmap/mappers/**/*.xml" /> 
	</bean>

	<!-- MapperConfigurer setup for MyBatis Database Layer with @Mapper("deptMapper") in DeptMapper Interface -->
 	<bean class="egovframework.rte.psl.dataaccess.mapper.MapperConfigurer">
		<property name="basePackage" value="egovframework" />
	</bean>
    
</beans>

MariaDB용 수정본

<!-- DB -->
<bean id="dataSource" class="org.springframework.jdbc.datasource.SimpleDriverDataSource">
  <property name="driverClass" value="org.mariadb.jdbc.Driver"></property>
  <property name="url" value="jdbc:mariadb://localhost:3306/october"></property>
  <property name="username" value="root"></property>
  <property name="password" value="root"></property>
</bean>

<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
  <property name="dataSource" ref="dataSource"></property>
  <property name="configLocation" value="classpath:/mybatis/mybatis-config.xml"></property>
  <property name="mapperLocations" value="classpath*:/mybatis/sql/*.xml"></property>
</bean>

<bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">
  <constructor-arg name="sqlSessionFactory" ref="sqlSessionFactory"></constructor-arg>
</bean>