마이바티스 설정

mybatis 환경설정 구조도

파일명 : oracle.properties
driver=oracle.jdbc.driver.OracleDriver
url=jdbc:oracle:thin:@127.0.0.1:1521/xe
username=system
password=class603


파일명 : mariadb.properties
driver=org.mariadb.jdbc.Driver
url=jdbc:mysql://211.110.165.201:3306/ds20170412
username=ds20170412
password=class603


파일명 : mybatis-config.xml

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "HTTP://mybatis.org/dtd/mybatis-3-config.dtd">

<configuration>

    <settings>

        <setting name="cacheEnabled" value="true" />

        <!--<setting name="lazyLoadingEnabled" value="true" /> -->

        <setting name="aggressiveLazyLoading" value="true" />

        <setting name="multipleResultSetsEnabled" value="true" />

        <setting name="useColumnLabel" value="true" />

        <!-- <setting name="autoMappingBehavior" value="false" /> -->

        <setting name="useGeneratedKeys" value="true" />

        <setting name="defaultExecutorType" value="REUSE" />

        <setting name="defaultStatementTimeout" value="5000" />

    </settings>

</configuration>

파일명 : mybatis-context.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-3.0.xsd">

    <bean id="propertyPlaceholderConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">

        <property name="locations">

            <value>/WEB-INF/mybatis/mariadb.properties</value>

        </property>

    </bean>

    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"

        destroy-method="close">

        <property name="driverClassName" value="${driver}" />

        <property name="url" value="${url}" />

        <property name="username" value="${username}" />

        <property name="password" value="${password}" />

    </bean>

   

    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">

        <property name="dataSource" ref="dataSource" />

        <property name="mapperLocations" value="classpath:com/ds/mapper/*.xml" />

        <property name="configLocation" value="/WEB-INF/mybatis/mybatis-config.xml" />

        <property name="transactionFactory">

            <bean

                class="org.apache.ibatis.transaction.managed.ManagedTransactionFactory" />

        </property>

    </bean>

    <bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">

        <constructor-arg index="0" ref="sqlSessionFactory" />

    </bean>

</beans>
-----------------------------------------------------------------------------------------
mySQL 웹서버 사이트

http://211.110.165.201:8080/webdb/

mybatis-context.xml  

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
  destroy-method="close">
  <property name="driverClassName" value="org.mariadb.jdbc.Driver" />
  <property name="url"
   value="jdbc:mysql://211.110.165.201:3306/ds20170412_12" />
  <property name="username" value="ds20170412_12" />
  <property name="password" value="class603" />
 </bean>

또는  mariadb.properties

driver=org.mariadb.jdbc.Driver
url=jdbc:mysql://211.110.165.201:3306/ds20170412
username=ds20170412
password=class603