打印本文 打印本文 关闭窗口 关闭窗口
Tomcat环境下配置oracle数据源的方法
作者:武汉SEO闵涛  文章来源:敏韬网  点击数3632  更新时间:2009/4/22 22:03:31  文章录入:mintao  责任编辑:mintao
  <!-- Maximum number of DB connections in pool.Set to 0 for no limit. -->

  <value>10</value>

 </parameter>

 <parameter>

  <name>maxIdle</name>

  <!-- Maximum number of idle DB connections to retain in pool.Set to 0 for no limit. -->

  <value>5</value>

 </parameter>

 <parameter>

  <name>maxWait</name>

  <!-- Maximum time to wait for a DB connection to become available in ms.An exception is thrown if this timeout is exceeded.Set to -1 to wait indefinitely. -->

  <value>10000</value>

 </parameter>

 <parameter>

  <name>removeAbandoned</name>

  <!-- Abandoned DB connections are removed and recycled -->

  <value>true</value>

 </parameter>

 <parameter>

  <name>removeAbandonedTimeout</name>

  <!-- Use the removeAbandonedTimeout parameter to set the number of seconds a DB connection has been idle before it is considered abandoned.  -->

  <value>60</value>

 </parameter>

 <parameter>

  <name>username</name>

  <!-- Database User Name -->

  <value>scott</value>

 </parameter>

 <parameter>

  <name>password</name>

  <!-- User Password -->

  <value>tiger</value>

 </parameter>

 <parameter>

  <name>driverClassName</name>

  <!-- Database Driver Class Name -->

  <value>oracle.jdbc.driver.OracleDriver</value>

 </parameter>

 <parameter>

  <name>url</name>

  <!-- Database Address -->

  <value>jdbc:oracle:thin:@127.0.0.1:1521:toni</value>

 </parameter>

</ResourceParams>

</Context>

 

 

与之相配合的应用程序的配置文档在$CATALINA_HOME/webapps/test/WEB-INF/web.xml里设置被引用的资源:

 

 

下面是配置代码,必须放在<web-app></web-app>里。

 

 

<!-- Database Config start -->

 

 

<resource-ref>

 

 

<description>connectDB test</description>

 

 

<res-ref-name>jdbc/toni</res-ref-name>

 

 

<res-type>javax.sql.DataSource</res-type>

 

 

<res-auth>Container</res-auth>

 

 

</resource-ref>

 

 

上一页  [1] [2] [3] [4] [5]  下一页

打印本文 打印本文 关闭窗口 关闭窗口