spring boot + jasypt

<!-- jasypt -->
<dependency>
    <groupId>com.github.ulisesbocchio</groupId>
    <artifactId>jasypt-spring-boot-starter</artifactId>
    <version>1.5-java7</version>
</dependency>

DatabaseConfig.java

package ms;
 
import java.io.FileNotFoundException;
import java.io.IOException;
import java.sql.SQLException;
 
import javax.sql.DataSource;
 
import org.apache.commons.dbcp.BasicDataSource;
import org.apache.ibatis.session.SqlSessionFactory;
import org.jasypt.encryption.pbe.StandardPBEStringEncryptor;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.core.env.Environment;
import org.springframework.core.io.Resource;
import org.springframework.core.io.support.PathMatchingResourcePatternResolver;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;
import org.springframework.transaction.annotation.EnableTransactionManagement;
 
@Configuration
@EnableTransactionManagement
@MapperScan("ms.persistence")
public class DatabaseConfig { 
 
    @Bean(destroyMethod="close")        
    DataSource dataSource(Environment env) throws SQLException, FileNotFoundException, IOException {
            
        StandardPBEStringEncryptor encryptor = new StandardPBEStringEncryptor();            
        encryptor.setPassword("pwkey");
            
        String decEnvUsername = encryptor.decrypt(env.getProperty("oracle.username"));
        String decEnvPwd = encryptor.decrypt(env.getProperty("oracle.password"));
        String envDriverClassName = env.getProperty("oracle.driverClassName");
        String envUrl = env.getProperty("oracle.url");
 
 
        BasicDataSource ret = new BasicDataSource();
        ret.setDriverClassName(envDriverClassName);
        ret.setUsername(decEnvUsername);                
        ret.setPassword(decEnvPwd);
        ret.setUrl(envUrl);
        return ret;
    }
    
    @Bean
    public SqlSessionFactory sqlSessionFactory(DataSource dataSource) throws Exception {
          SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean();
          sqlSessionFactoryBean.setDataSource(dataSource);
    
          Resource[] arrResource = new PathMatchingResourcePatternResolver()
                .getResources("classpath:mapper/*.xml");
          sqlSessionFactoryBean.setMapperLocations(arrResource);
    
          return sqlSessionFactoryBean.getObject();
    }
    
    @Bean
    public DataSourceTransactionManager transactionManager(DataSource dataSource) {
        return new DataSourceTransactionManager(dataSource);
    }
}
 

application.properties

oracle.driverClassName=net.sf.log4jdbc.sql.jdbcapi.DriverSpy
oracle.url=jdbc:log4jdbc:oracle:thin:@127.0.0.1:1521:xe
oracle.username=2KvE1Uj9V1glieN2po522sjug==
oracle.password=Se+621aELz1HA0TjTIDm2RtEg==

정상적으로 jasypt 사용할땐

oracle.ousername=ENC(2KvEUj9VglieN2po52sjug==) 이렇게 ENC로 감싸야하나 

Spring boot bean 생성시 문제가 발생해서 ENC를 빼고 작성하였다.

Enc.java

import org.jasypt.encryption.pbe.StandardPBEStringEncryptor;
 
public class Enc{
    
    public static void main(String[] args) {
        
        StandardPBEStringEncryptor encryptor = new StandardPBEStringEncryptor();
        encryptor.setPassword("pwkey");
        String username = encryptor.encrypt("muser");
        String password = encryptor.encrypt("mpwer1234");
        
        System.out.println("username : " + username);
        System.out.println("password : " + password);
        
        System.out.println("username(dec) : " + encryptor.decrypt(username));
        System.out.println("password(dec) : " + encryptor.decrypt(password));    
    }
}