build.gradle

    implementation ('org.springframework.boot:spring-boot-starter-jdbc') {
        exclude group: 'com.zaxxer', module: 'HikariCP'
    }
    implementation group: 'org.apache.commons', name: 'commons-dbcp2', version: '2.9.0'

application.yaml

 

spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3380/testdb
    username: root
    password: test
    dbcp2:
      initial-size: 5
      max-total: 10
      test-while-idle: true
      time-between-eviction-runs-millis: 1000
      num-tests-per-eviction-run: 1

 


[JEUSMain.xml]
    
	
        
            
                oracle
                jdbc/name_test
                
                   oracle.jdbc.pool.OracleConnectionPoolDataSource
                
                ConnectionPoolDataSource
                oracle sid
                
                   This is a sample for database setting.
                
                아이디
                아이디
                1521
                아이피
                
                    driverType
                    java.lang.String
                    thin
                
                true
                Warning
				
                    
                        2
                        30
                        4
                        3600000
                    
					
					true
					10000


[jeus-web-dd.xml]
     
        
            jdbc/name_test
            jdbc/name_test


JEUSMain.xml
    
        jdbc/name_test  
        javax.sql.DataSource


[스프링 설정파일]
저작자표시 (새창열림)
Tomcat server.xml
Context web.xml 

		DB Connection
		jdbc/mysqlConn
		javax.sql.DataSource
		Container


source 
Context initContext = new InitialContext();
Context envContext = (Context)initContext.lookup("java:comp/env");
DataSource ds = (DataSource)envContext.lookup("jdbc/mysqlConn");  // 설정정보의 name과 동일하게 셋팅
            
// 커넥션 얻기
Connection con = ds.getConnection();
저작자표시 (새창열림)
SpringTest.zip
[소스상에서 Transaction 처리] 
public class DemoServiceImpl extends JdbcDaoSupport implements DemoService {

	private TransactionTemplate txTemplate;
	
	public void setTransactionManager(PlatformTransactionManager txManager) {
		this.txTemplate = new TransactionTemplate(txManager);
		this.txTemplate.setPropagationBehavior(DefaultTransactionDefinition.PROPAGATION_REQUIRED);
	}
	
	public int selectTest() throws Exception{
		// Transaction Handling
		txTemplate.execute(new TransactionCallbackWithoutResult() {
			public void doInTransactionWithoutResult(TransactionStatus status) {
				int cnt = getJdbcTemplate().update("insert into ddakker_test(SEQ, TXT)values(?,?)", new Object[]{"4","txt4"});
			    System.out.println("insert cnt: " + cnt);
			    int cnt2 = getJdbcTemplate().update("insert into ddakker_test(SEQ, TXT1)values(?,?)", new Object[]{"5","txt5"});
			    System.out.println("insert cnt2: " + cnt2);				
			}			
		});
	    
		List  list; 
	    Object params[] = {3};	    
	    list = getJdbcTemplate().queryForList("select seq, txt from ddakker_test where seq = ?", params);
	    
	    System.out.println("list1: " + list.size());
	    Iterator i = list.iterator();
	    System.out.println("i : " + i);
	    while(i.hasNext()){
	    	Map map = (Map) i.next();
	    	System.out.println("map" + map);
	    }
	    
		return 0;
	}
}

[설정파일에서 Transaction 처리] 
public class Demo2Servicelmpl extends JdbcDaoSupport implements Demo2Service {
	
	public int selectTest() throws Exception {		
		int cnt = getJdbcTemplate().update("insert into ddakker_test(SEQ, TXT)values(?,?)", new Object[]{"4","txt4"});
	    System.out.println("insert cnt: " + cnt);
	    int cnt2 = getJdbcTemplate().update("insert into ddakker_test(SEQ, TXT1)values(?,?)", new Object[]{"5","txt5"});
	    System.out.println("insert cnt2: " + cnt2);
	    
		List  list; 
	    Object params[] = {3};	    
	    list = getJdbcTemplate().queryForList("select seq, txt from ddakker_test where seq = ?", params);
	    
	    System.out.println("list1: " + list.size());
	    Iterator i = list.iterator();
	    System.out.println("i : " + i);
	    while(i.hasNext()){
	    	Map map = (Map) i.next();
	    	System.out.println("map" + map);
	    }
	    
		return 0;
	}

}

	
		
	
	
	
		
		
		
		
			
				PROPAGATION_REQUIRED,-Exception
				PROPAGATION_SUPPORTS

[설정파일에서 Transaction 처리(AspectJ 를 이용한 한방 처리)]
저작자표시 (새창열림)

+ Recent posts

티스토리툴바