21.04.16

DB튜닝

https://velog.io/@kchief/Connection-Pool%EC%BB%A4%EB%84%A5%EC%85%98-%ED%92%80
참고

열기

    <!-- DBCP 자원생성 -->
    <Resource name="jdbc/myoracle"
    		  auth="Container"	
    		  type="javax.sql.DataSource"
    		  driverClassName="oracle.jdbc.OracleDriver"
    		  url="jdbc:oracle:thin:@localhost:1521:xe"
    		  username="web"
    		  password="web"
    		  maxTotal="20"
    		  maxIdle="10"
    		  maxWaitMillis="-1"
    		     />

작성

열기

  <!-- Resource참조 -->
  <resource-ref>
  	<description>Mvc Application DBCP</description>
  	<res-ref-name>jdbc/myoracle</res-ref-name>
  	<res-type>javax.sql.DataSource</res-type>
  	<res-auth>Container</res-auth>
  </resource-ref>

작성

열기

주석처리

	/**
	 * DBCP 이용버젼
	 * 
	 * Resource등록 - JNDI를 통한 참조
	 * 
	 * @return
	 */
	public static Connection getConnection() {
		Connection conn = null;
		
		try {
			Context ctx = new InitialContext();
			/**
			 * JNDI구조
			 * java:/comp/env/ + jdbc/myoracle
			 */
			DataSource dataSource = (DataSource) ctx.lookup("java:/comp/env/jdbc/myoracle");
			conn = dataSource.getConnection();
			conn.setAutoCommit(false);
		} catch (NamingException | SQLException e) {
			e.printStackTrace();
		}
		return conn;
	}

작성

import

import

Add exception to existing catch clause클릭

DB EXPORT

sql파일 생성완료!