File name
Commit message
Commit date
File name
Commit message
Commit date
File name
Commit message
Commit date
File name
Commit message
Commit date
File name
Commit message
Commit date
File name
Commit message
Commit date
package spring.config;
import com.zaxxer.hikari.HikariConfig;
import com.zaxxer.hikari.HikariDataSource;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
/**
* DB Connection 자원 관련 Bean 설정 Class
* DBCP: HikariCP
* JDBC: MariaDB or PostgreSQL
*
* @author 서영석
* @since 2022.09.01
*/
@Configuration
public class DataSourceContextConfig {
/**
* HikariCP(DBCP) Config(설정 세팅) 객체 Bean 설정
*
* @author 서영석
* @since 2022.09.01
*/
@Bean(name = "mainHikariConfig")
public HikariConfig getMainHikariConfig () {
HikariConfig hikariConfig = new HikariConfig();
/* MariaDB
hikariConfig.setDriverClassName("org.mariadb.jdbc.Driver");
hikariConfig.setJdbcUrl("jdbc:mariadb://localhost:3306/test");
hikariConfig.setUsername("root");
hikariConfig.setPassword("1234");
*/
/* PostgreSQL*/
hikariConfig.setDriverClassName("org.postgresql.Driver");
hikariConfig.setJdbcUrl("jdbc:postgresql://210.180.118.83:5432/keris?currentSchema=keris_v0_2");
hikariConfig.setUsername("takensoft");
hikariConfig.setPassword("tts64103165!@");
/* KT클라우드 DB정보 */
// hikariConfig.setDriverClassName("org.postgresql.Driver");
// hikariConfig.setJdbcUrl("jdbc:postgresql://172.27.0.172:5432/keris?currentSchema=keris_v0_2");
// hikariConfig.setUsername("takensoft");
// hikariConfig.setPassword("ts44301236!@");
/* KT클라우드 test DB정보 */
// hikariConfig.setDriverClassName("org.postgresql.Driver");
// hikariConfig.setJdbcUrl("jdbc:postgresql://172.27.0.172:5432/keris?currentSchema=keris_test");
// hikariConfig.setUsername("takensoft");
// hikariConfig.setPassword("ts44301236!@");
// /* 가상 리눅스 */
// hikariConfig.setDriverClassName("org.postgresql.Driver");
// hikariConfig.setJdbcUrl("jdbc:postgresql://localhost:5432/keris?currentSchema=keris_v0_2");
// hikariConfig.setUsername("takensoft");
// hikariConfig.setPassword("ts44301236!@");
return hikariConfig;
}
/**
* HikariCP(DBCP) 객체 Bean 설정
*
* @author 서영석
* @since 2022.09.01
*/
@Bean(name = "mainHikariDataSource")
public HikariDataSource getMainHikariDataSource () {
HikariDataSource hikariDataSource = new HikariDataSource(getMainHikariConfig());
return hikariDataSource;
}
}