• pom.xml 의존성 추가

        <!-- mariaDB 의존성 추가 -->
        <dependency>
            <groupId>org.mariadb.jdbc</groupId>
            <artifactId>mariadb-java-client</artifactId>
            <version>2.2.5</version>
        </dependency>

• root-context.xml - Bean 설정 추가

    <bean class="org.springframework.jdbc.datasource.DriverManagerDataSource" id="dataSource">
            <property name="driverClassName" value="org.mariadb.jdbc.Driver"/>
        <property name="url" value="jdbc:mariadb://jwleehome.iptime.org:7577/jwleeDB"/>
        <property name="username" value="norelove" />
        <property name="password" value="92ghlrhkS!@#" />    
    </bean>

1. pom.xml 에서 ORM, 하이버네이트 사용을 위한 라이브러리가 Maven update 를 할때 진도가 잘안나간다.
2. 해결 : 3.1.1 버전을 5.0.7 버전으로 교체

<properties>
        <java-version>1.6</java-version>
        <org.springframework-version>5.0.7.RELEASE</org.springframework-version>
        <org.aspectj-version>1.6.10</org.aspectj-version>
        <org.slf4j-version>1.6.6</org.slf4j-version>
    </properties>

        <!-- ORM, 하이버네이트 사용을 위한 라이브러리 -->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-orm</artifactId>
            <version>${org.springframework-version}</version>
        </dependency>

DB에 연결이 되었는지 확인하고자

HomeController.java에 추가 하여 Test 하였다.

package com.gmail.Zbest;

import java.text.DateFormat;
import java.util.Date;
import java.util.Locale;

import javax.sql.DataSource;

import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;

@Controller
public class HomeController {

    private static final Logger logger = LoggerFactory.getLogger(HomeController.class);
    @Autowired
    private DataSource abc ;

    @RequestMapping(value = "/", method = RequestMethod.GET)
    public String home(Locale locale, Model model) {
        logger.info("Welcome home! The client locale is {}.", locale);
        Date date = new Date();
        DateFormat dateFormat = DateFormat.getDateTimeInstance(DateFormat.LONG, DateFormat.LONG, locale);
        String formattedDate = dateFormat.format(date);
        model.addAttribute("serverTime", formattedDate );
        System.out.print(abc);
        return "home";
    }

}

console org.springframework.jdbc.datasource.DriverManagerDataSource@5f1a8fa6