JAVA COFFEE

-JNDI(Java Naming and Directory Interface) : 사용자가 원하는 리소스/서비스를 등록하고 찾는 법
  자세한 설명은 http://blog.naver.com/kvivaldi.do?Redirect=Log&logNo=60004720636 참조
 
-tomcat 5.5 부터는 META-INF 폴더안에 context.xml 파일을 생성하여 사용가능
 (전 버전은 server.xml안에 설정, 궁금하신분은 구글링 ㄱㄱ)

*META-INF/context.xml
<?xml version="1.0" encoding="UTF-8"?>
<Context antiJARLocking="true" path="/ex">             // path는 context 명을 가르킴    
    <Resource name="jdbc/Oracle"                   //lookup("java:comp/env/jdbc/Oracle");
              auth="Container"
              type="javax.sql.DataSource"
              driverClassName="oracle.jdbc.driver.OracleDriver"
              url="jdbc:oracle:thin:@localhost:1521:SID"
              username="ID" password="PWD"
              maxActive="20" maxIdle="10" maxWait="-1"/>
</Context>


*class Connector
import java.sql.Connection;
import java.sql.SQLException;
import javax.naming.InitialContext;
import javax.sql.DataSource;

public class Connector {
    private static DataSource ds;
    static {
        try {
            InitialContext ctx = new InitialContext();
            ds=(DataSource)ctx.lookup("java:comp/env/jdbc/Oracle");
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
    public static Connection getConnection() throws SQLException{
        return ds.getConnection();
    }
}


실제 사용은 Connection con = Connector.getConnection() 으로 커넥션을 얻어올수 있음