ABOUT ME

-

Today
-
Yesterday
-
Total
-
  • DBCP
    Archive 2014. 9. 19. 11:12

    DBCP

    커넥션문 , 사용하지 않는(불필요한) 커넥션은 알아서 close



    DAO.java 에서 driver, url, uid, pwd, 입력 대신



    Oracle 8i, 9i & 10g ( http://tomcat.apache.org/tomcat-8.0-doc/jndi-datasource-examples-howto.html#Oracle_8i,_9i_&_10g )

    1. Context configuration

    <Resource name="jdbc/myoracle" auth="Container"

                  type="javax.sql.DataSource" driverClassName="oracle.jdbc.OracleDriver"

                  url="jdbc:oracle:thin:@127.0.0.1:1521:mysid"

                  username="scott" password="tiger" maxTotal="20" maxIdle="10"

                  maxWaitMillis="-1"/>


    eclipse>servers -> server.xml

    95: <Context docBase="ad" path="/ad" reloadable="true" source="org.eclipse.jst.jee.server:ad"/>


    to

    <Context docBase="ad" path="/ad" reloadable="true" source="org.eclipse.jst.jee.server:ad">

    <Resource name="jdbc/myoracle" auth="Container"

                  type="javax.sql.DataSource" driverClassName="oracle.jdbc.OracleDriver"

                  url="jdbc:oracle:thin:@127.0.0.1:1521:mysid"

                  username="scott" password="tiger" maxTotal="20" maxIdle="10"

                  maxWaitMillis="-1"/>

    </Context>


    <Resource name="jdbc/xe" auth="Container" type="javax.sql.DataSource" driverClassName="oracle.jdbc.OracleDriver"

         url="jdbc:oracle:thin:@127.0.0.1:1521:xe" username="oraclejava7" password="oracle5678" maxTotal="20" maxIdle="10" maxWaitMillis="-1"/>







    MySQL DBCP Example ( http://tomcat.apache.org/tomcat-8.0-doc/jndi-datasource-examples-howto.html#MySQL_DBCP_Example )


    <Resource name="jdbc/TestDB" auth="Container" type="javax.sql.DataSource"

          maxTotal="100" maxIdle="30" maxWaitMillis="10000"

          username="javauser" password="javadude" driverClassName="com.mysql.jdbc.Driver"

          url="jdbc:mysql://localhost:3306/javatest"/>


    </Context>

    3. web.xml configuration



    insert server.xml


    <Context docBase="ad" path="/ad" reloadable="true" source="org.eclipse.jst.jee.server:ad">

    <Resource name="jdbc/myoracle" auth="Container"

                  type="javax.sql.DataSource" driverClassName="oracle.jdbc.OracleDriver"

                  url="jdbc:oracle:thin:@127.0.0.1:1521:mysid"

                  username="scott" password="tiger" maxTotal="20" maxIdle="10"

                  maxWaitMillis="-1"/>

    <Resource name="jdbc/TestDB" auth="Container" type="javax.sql.DataSource"

           maxTotal="100" maxIdle="30" maxWaitMillis="10000"

           username="javauser" password="javadude" driverClassName="com.mysql.jdbc.Driver"

           url="jdbc:mysql://localhost:3306/javatest"/>


    </Context>

    </Context>



    후  DAO.java 에 javax.sql.DataSource 임포트

    DataSource ds = null; // DBCP 커넥션풀 연결 레퍼런스 추가

    반응형
Designed by Tistory.