%app_dir%/WEB-INF/web.xml----------------------------------------------------
<resource-ref>
<description>DB Connection</description>
<res-ref-name>
jdbc/jdbcTest</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
%server_dir%/conf/sever.xml----------------------------------------------------
<GlobalNamingResources>
......
<Resource auth="Container" driverClassName="oracle.jdbc.driver.OracleDriver"
maxActive="20" maxIdle="10" maxWait="-1" name="
jdbc/jdbcTest" password="
1111"
type="javax.sql.DataSource" url="
jdbc:oracle:thin:@127.0.0.1:1521:testdb" username="
tester" />
....
</GlobalNamingResources>
%server_dir%/context.xml----------------------------------------------
<Context>
...
<ResourceLink global="
jdbc/jdbcTest" name="
jdbc/jdbcTest" type="javax.sql.DataSource" />
...
</Context>
TestDbcp.jsp
----------------------------------------------------------
<%@ page contentType="text/html;charset=euc-kr" %>
<%@ page import="java.sql.*" %>
<%@ page import="javax.sql.*" %>
<%@ page import="javax.naming.*" %>
<%
try{
//DBCP init
Context initCtx = new InitialContext();
Context envCtx = (Context)initCtx.lookup("java:comp/env");
DataSource ds = (DataSource)envCtx.lookup("
jdbc/jdbcTest");
Connection conn = ds.getConnection();
Statement stmt = conn.createStatement();
String sql="SELECT sysdate FROM dual";
ResultSet rs = stmt.executeQuery(sql);
if (rs.next())
out.println(rs.getString("SYSDATE"));
stmt.close();
conn.close();
} catch(Exception e) {
out.println("error : " + e);
}
%>
위 설정중 빨간색은 사용자에 맞게 세팅.
마지막 테스트 코드를 실행 했을때 날짜가 나오면 성공이다.
