DBCP연결

server.xml

      <Resource name="jdbc/myoracle" auth="Container" type="javax.sql.DataSource"

               maxTotal="100" maxIdle="30" maxWaitMillis="10000"

               username="ora_user" password="hong" driverClassName="oracle.jdbc.OracleDriver"

               url="jdbc:oracle:thin:@localhost:1521:orcl"/>

jsp

<%

//Context객체 생성

Context initContext=new InitialContext();

//resource태그에 정의된 내용으로 연결

Context envContext=(Context)initContext.lookup("java:/comp/env");

DataSource ds=(DataSource)envContext.lookup("jdbc/myoracle");

Connection conn=ds.getConnection();

out.print("DBCP 연결 성공");

%>