## DATASOURCE (DataSourceAutoConfiguration & DataSourceProperties)
spring.database.driverClassName=org.postgresql.ds.PGSimpleDataSource
# JDBC url of the database.
spring.datasource.url=jdbc:postgresql://localhost:5432/ticket
# Login username of the database.
spring.datasource.username=postgres
# Login password of the database.
spring.datasource.password=postgres



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

    <bean id="hikariConfig" class="com.zaxxer.hikari.HikariConfig">
        <property name="poolName" value="springHikariCP" />
        <property name="connectionTestQuery" value="SELECT 1" />
        <property name="dataSourceClassName">
            <value>${spring.database.driverClassName}</value>
        </property>
        <property name="dataSourceProperties">
            <props>
                <prop key="url">${spring.datasource.url}</prop>
                <prop key="user">${spring.datasource.username}</prop>
                <prop key="password">${spring.datasource.password}</prop>
            </props>
        </property>
    </bean>

    <bean id="dataSource" class="com.zaxxer.hikari.HikariDataSource" destroy-method="close">
        <constructor-arg ref="hikariConfig" />
    </bean>

    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource" />
    </bean>

</beans>