1.conf/server.xml파일을 열고 <GlobalNamingResources>엘리먼트 안에 다음 내용 추가.
<Resource name="jdbc/myoracle" auth="Container"
type="javax.sql.DataSource" driverClassName="oracle.jdbc.OracleDriver"
url="jdbc:oracle:thin:@localhost:1521:xe"
username="scott" password="tiger" maxActive="20" maxIdle="10"
maxWait="-1"/>
2. conf/context.xml에 추가
<ResourceLink global="jdbc/myoracle" name="jdbc/myoracle" type="javax.sql.DataSource"/>
3. ojdbc14.jar 파일을 oracle.com 사이트에서 다운로드하고 Tomcat/common/lib/안에 복사
4. Tomcat5.5 다시 실행
5. 위와 같이 설정이 완료되었으면 이 파일을 실행하여 결과가 출력되는지 확인한다.
6. 설정 및 테스트 끝
<%@ page contentType="text/html;charset=KSC5601"%>
<%@ page import="java.sql.*, javax.naming.*, javax.sql.*"%>
<HTML>
<HEAD><TITLE></TITLE>
</HEAD>
<BODY><CENTER>
<%
Context initCtx = new InitialContext();
DataSource ds = (DataSource)initCtx.lookup("java:comp/env/jdbc/myoracle");
Connection conn = ds.getConnection();
Statement stmt = conn.createStatement();
String query = "select sysdate from daul";
ResultSet rs = stmt.executeQuery(query);
while(rs.next()) {
out.println(rs.getString(1)+"<br>");
}
rs.close();
stmt.close();
conn.close();
%>
</CENTER>
</BODY>
</HTML>
----------------------------------------------------------------------------------------
1. server.xml - <GlobalNamingResources>
<Resource name="jdbc/JDBCNAME" auth="Container"
type="javax.sql.DataSource" driverClassName="oracle.jdbc.OracleDriver"
url="jdbc:oracle:thin:@127.0.0.1:1521:ora"
username="dbuser" password="dbuser" maxActive="20" maxIdle="10"
maxWait="-1"/>
<Resource name="jdbc/JDBCNAME" auth="Container"
type="javax.sql.DataSource" driverClassName="oracle.jdbc.OracleDriver"
url="jdbc:oracle:thin:@127.0.0.1:1521:ora"
username="dbuser" password="dbuser" maxActive="20" maxIdle="10"
maxWait="-1"/>
<Resource name="jdbc/JDBCNAME" auth="Container"
type="javax.sql.DataSource" driverClassName="oracle.jdbc.OracleDriver"
url="jdbc:oracle:thin:@127.0.0.1:1521:ora"
username="dbuser" password="dbuser" maxActive="20" maxIdle="10"
maxWait="-1"/>
2. context.xml
<ResourceLink global="jdbc/JDBCNAME" name="jdbc/JDBCNAME" type="javax.sql.DataSource"/>
<ResourceLink global="jdbc/JDBCNAME" name="jdbc/JDBCNAME" type="javax.sql.DataSource"/>
<ResourceLink global="jdbc/JDBCNAME" name="jdbc/JDBCNAME" type="javax.sql.DataSource"/>
