热门关键字:  ubuntu  分区  Fedora  linux系统进程  函数

怎样在tomcat5中配置mysql数据源

来源: 作者: 时间:2007-07-29 Tag: 点击:

 

 

三、配置server.xml

 

 

注:我的web在d:\myweb\myapps

 

 

首先要将mysql的驱动程序放到d:\myweb\tomcat5\common\lib下面,一定要放".jar"的文件,如是".zip"的文件直接改为.jar即可。

 

 

用文本编辑器打开D:\tomcat5\conf\server.xml,找到结束标志,然后在之前加上如下语句:

 

<Context path="/myapps" docBase="d:\myweb\myapps" debug="0"
reloadable="true" > 
 


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

  <ResourceParams name="jdbc/DBConnection">
    <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>10</value>
    </parameter> 
 

    <!-- Maximum number of idle dB connections to retain in pool.
         Set to 0 for no limit.
         -->
    <parameter>
      <name>maxIdle</name>
      <value>3</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.
        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>1234</value>
    </parameter> 
 

    <!-- Class name for mm.mysql JDBC 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/forumdb?autoReconnect=true</value>
    </parameter>
  </ResourceParams> 
 

</Context>

 

 

再次提醒:一定要放在之前!




相关文章:
Scaling out MySQL - Hardware today and tomorro
MySQL教会我使用GnuPG验证软件包
MySQL中MyISAM引擎与InnoDB引擎性能简单测试
mysqladmin在线帮助文档
install a MySQL source distribution
Mysql备份脚本(未验证)
每小时Dump所有mysql数据库到NAS存储设备上
MySQL数据库5.0的my.cnf配置选项
MYSQL建表实例
一些对Mysql DBA有用的脚本
MySql数据引擎简介与选择方法
通向MySQL神秘王国的图形化之路
mysql 中show 命令用法详细介绍
Linux自动备份MySQL数据库 实用方法
如何导入导出MySQL数据库
MySQL创始人力劝用户暂缓部署MySQL 5.1
mysql权限管理
Mysql自动备份脚本
升级mysql
mysql日志
MySql带参数的存储过程编写(动态执行SQL语句)
ERROR 1045 (28000): Access denied for 报错解决
sql优化
配置源码安装的MySQL同时支持多个字符集
MySQL数据表类型 数据类型
sql文件无法读取
mysql 中如何进行IP地址的存放
正在表达式在mysql中的使用
sql mode
linux安装mysql可执行安装包