태터데스크 관리자

도움말
닫기
적용하기   첫페이지 만들기

태터데스크 메시지

저장하였습니다.

[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();
.
.
.
%>

top

Trackback Address :: http://www.ssial.com/trackback/60 관련글 쓰기

  1. 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

Write a comment