제목을 입력해 주세요.

커넥션 풀

1.드라이버 로딩
2.커넥션 객체 생성
----------------------전체리소스(70~80%)

3.stmt,pstmt객체생성
4.SQL문장준비, 실행
5.사용(select)
6.마무리

커넥션 풀 사용법
C:\java\workspace\message\WEB-INF\lib

/conf/server.xml 에
    <Resource name="jdbc/myoracle"
                auth="Container"
                type="javax.sql.DataSource"
                driverClassName="oracle.jdbc.driver.OracleDriver"
             
                loginTimeout="10"
                maxWait="5000"
                username="scott"
                password=""
                testOnBorrow=""
                url="jdbc:oracle:thin:@localhost:1521:XXXX"
        />
추가

C:\java\j2sdk6\jre\lib에 ojdbc14.jar 추가

poolbefore.jsp에
아래코드를
    String DRIVER="oracle.jdbc.driver.OracleDriver";
    String URL="jdbc:oracle:thin:@Z:1521:orcl";
    String USER="message";
    String PASSWORD="tiger";
   
    Class.forName(DRIVER);
    con = DriverManager.getConnection(URL, USER, PASSWORD);
아래의 코드로 변경

Context initCtx = new InitialContext();
    Context envCtx = (Context) initCtx.lookup("java:comp/env");
    DataSource ds = (DataSource)envCtx.lookup("jdbc/myoracle");
    Connection con = ds.getConnection();

poolbefore.jsp에 아래코드 import
<%@ page import="javax.sql.*" %>
<%@ page import="javax.naming.*" %>


<!-- The contents of this file will be loaded for each web application -->
<Context reloadable="true">

    <!-- Default set of monitored resources -->
    <WatchedResource>WEB-INF/web.xml</WatchedResource>
   
    <!-- Uncomment this to disable session persistence across Tomcat restarts -->
    <!--
    <Manager pathname="" />
    -->


<ResourceLink global="jdbc/myoracle" name="jdbc/myoracle"
 type="oracle.jdbc.pool.OracleDataSource"/>
</Context>


C:\java\workspace\message\WEB-INF\web.xml
<!-- JSPC servlet mappings end -->

<resource-ref> <description>Oracle Datasource example</description> <res-ref-name>jdbc/orcl</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref>

</web-app>