[web.xml]
.
.
<display-name>JSP60Test</display-name>
<resource-ref>
<res-ref-name>jdbc/mysqldb</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
<resource-ref>
<res-ref-name>jdbc/oracledb</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
.
.
.
[server.xml]:mysql Tomcat Container에서 직접 서버구동시
<GlobalNamingResources>
<Resource name="jdbc/mysqldb" auth="Container" type="javax.sql.DataSource" driverClassName="com.mysql.jdbc.Driver" loginTimeout="10" maxWait="5000" username="jspid" password="1234" url="jdbc:mysql://localhost:3306/jsptest" />
</GlobalNamingResources>
.
.
.
.
<Context docBase="C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\JSP60Test" path="/JSP60Test" reloadable="true">
<Resource name="jdbc/mysqldb" auth="Container" type="javax.sql.DataSource" driverClassName="com.mysql.jdbc.Driver" loginTimeout="10" maxWait="5000" username="jspid" password="1234" url="jdbc:mysql://localhost:3306/jsptest" />
</Context>
[server.xml]:mysql eclipse에서 서버구동시
<GlobalNamingResources>
<Resource name="jdbc/mysqldb" auth="Container" type="javax.sql.DataSource" driverClassName="com.mysql.jdbc.Driver" loginTimeout="10" maxWait="5000" username="jspid" password="1234" url="jdbc:mysql://localhost:3306/jsptest" />
</GlobalNamingResources>
.
.
.
.
<Context docBase="JSP60Test" path="/JSP60Test" reloadable="true" source="org.eclipse.jst.jee.server:JSP60Test">
<Resource name="jdbc/mysqldb" auth="Container" type="javax.sql.DataSource" driverClassName="com.mysql.jdbc.Driver" loginTimeout="10" maxWait="5000" username="jspid" password="1234" url="jdbc:mysql://localhost:3306/jsptest" />
</Context>
[server.xml]:Oracle Tomcat Container에서 직접 서버구동시
<GlobalNamingResources>
<Resource name="jdbc/oracledb" auth="Container" type="javax.sql.DataSource" driverClassName="oracle.jdbc.driver.OracleDriver" loginTimeout="10" maxWait="5000" username="oracleuser" password="1234" url="jdbc:oracle:thin:@303c2:1521:orcl" />
</GlobalNamingResources>
.
.
.
.
<Context docBase="C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\JSP60Test" path="/JSP60Test" reloadable="true">
<Resource name="jdbc/oracledb" auth="Container" type="javax.sql.DataSource" driverClassName="oracle.jdbc.driver.OracleDriver" loginTimeout="10" maxWait="5000" username="oracleuser" password="1234" url="jdbc:oracle:thin:@303c2:1521:orcl" />
</Context>
[server.xml]:Oracle eclipse에서 서버구동시
<GlobalNamingResources>
<Resource name="jdbc/oracledb" auth="Container" type="javax.sql.DataSource" driverClassName="oracle.jdbc.driver.OracleDriver" loginTimeout="10" maxWait="5000" username="oracleuser" password="1234" url="jdbc:oracle:thin:@303c2:1521:orcl" />
</GlobalNamingResources>
.
.
.
.
<Context docBase="JSP60Test" path="/JSP60Test" reloadable="true" source="org.eclipse.jst.jee.server:JSP60Test">
<Resource name="jdbc/oracledb" auth="Container" type="javax.sql.DataSource" driverClassName="oracle.jdbc.driver.OracleDriver" loginTimeout="10" maxWait="5000" username="oracleuser" password="1234" url="jdbc:oracle:thin:@303c2:1521:orcl" />
</Context>
위의 설정을 사용하는 코드는 다음처럼 한다.
<%@ page import="javax.sql.*"%>
<%@ page import="javax.naming.*"%>
<%
.
.
.
Context initCtx = new InitialContext();
Context envCtx = (Context)initCtx.lookup("java:comp/env");
DataSource ds = (DataSource)envCtx.lookup("jdbc/MySQLDataSource");
con = ds.getConnection();
.
.
.
%>
Trackback Address :: http://www.ssial.com/trackback/60
- Tracked from 성용이의 블로그 2008/11/24 11:12 삭제
Subject: DBCP server.xml & web.xml 설정
DBCP server.xml web.xml 설정Server/web 2008/09/02 16:09 [web.xml].. display-nameJSP60Test/display-name resource-ref res-ref-namejdbc/mysqldb/res-ref-name res-typejavax.sql.DataSource/res-type res



