Context마다 DataSource?? 톰켓의 CATALINA_HOME의 ...

* 예전 블로그 복사 -  http://blog.daum.net/7dbwnckd/1616449

/conf/catalina/localhost/ContextName.xml 을 넣어야 잘 돈다. Root에서는 다시 해 보겠음.

 

 

<Context path="/framework" docBase="${catalina.home}/webapps/framework" debug="5" reloadable="true" crossContext="true">

 <Logger className="org.apache.catalina.logger.FileLogger" prefix="localhost_dbwnckd_log." suffix=".txt" timestamp="true"/>

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

 <ResourceParams name="jdbc/dbwnckd">
  <parameter>
  <name>factory</name>
  <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
  </parameter>

  <!-- Maximum number of dB connections in pool. Make sure you
  configure your mysqld max_connections large enough to handle
  all of your db connections. Set to 0 for no limit.
  -->
  <parameter>
  <name>maxActive</name>
  <value>100</value>
  </parameter>

  <!-- Maximum number of idle dB connections to retain in pool.
  Set to -1 for no limit.  See also the DBCP documentation on this
  and the minEvictableIdleTimeMillis configuration parameter.
  -->
  <parameter>
  <name>maxIdle</name>
  <value>30</value>
  </parameter>

  <!-- Maximum time to wait for a dB connection to become available
  in ms, in this example 10 seconds. An Exception is thrown if
  this timeout is exceeded.  Set to -1 to wait indefinitely.
  -->
  <parameter>
  <name>maxWait</name>
  <value>10000</value>
  </parameter>

  <!-- MySQL dB username and password for dB connections  -->
  <parameter>
  <name>username</name>
  <value>root</value>
  </parameter>
  <parameter>
  <name>password</name>
  <value>admin</value>
  </parameter>

  <!-- Class name for the old mm.mysql JDBC driver - uncomment this entry and comment next
  if you want to use this driver - we recommend using Connector/J though
  <parameter>
  <name>driverClassName</name>
  <value>org.gjt.mm.mysql.Driver</value>
  </parameter>
  -->

  <!-- Class name for the official MySQL Connector/J driver -->
  <parameter>
  <name>driverClassName</name>
  <value>com.mysql.jdbc.Driver</value>
  </parameter>

  <!-- The JDBC connection url for connecting to your MySQL dB.
  The autoReconnect=true argument to the url makes sure that the
  mm.mysql JDBC Driver will automatically reconnect if mysqld closed the
  connection.  mysqld by default closes idle connections after 8 hours.
  -->
  <parameter>
  <name>url</name>
  <value>jdbc:mysql://localhost:3306/test?autoReconnect=true</value>
  </parameter>
 </ResourceParams>
</Context>