TOMCAT6.0配置MYSQL数据源的问题,哪位大哥能给小弟详细讲讲啊?
TOMCAT6.0配置MYSQL数据源的问题,哪位大哥能给小弟详细讲讲啊?

------解决方案--------------------
路过 顶一下
------解决方案--------------------
配置数据源:
一、配置环境变量：


softe version:tomcat5.0.12/mysql4.1.7/mysql_driver---mysql-connector-java-3.1.4-beta-bin.jar


mysql驱动程序可从www.mysql.com官方网站下载


路径：tomcat5在d:\myweb\tomcat5；mysql在C:\Program Files\MySQL\MySQL Server 4.1


Path(在原来的基础上加上）：d:\myweb\tomcat5\bin;d:\myweb\jdk1.4;d:\myweb\jdk1.4\bin;


d:\myweb\tomcat5\common\lib\servlet-api.jar;C:\Program Files\MySQL\MySQL Server 4.1\bin


CLASSPATH:d:\myweb\tomcat5\common\lib\servlet-api.jar;d:\myweb\tomcat5\common\lib\jsp-api.jar


JAVA_HOME:d:\myweb\jdk1.4


CATALINA_HOME:d:\myweb\tomcat5


二、建立测试数据库


在mysql中建立一个forumdb数据库，同时创建一个表member如下：


create database forumdb;


create table member


(


id int,


name varchar(6)


);


然后插入两条测试数据如下：


insert into member values(1, "zhang ");


insert into member values(2, "wang ");


至此，数据库准备完毕。


三、配置server.xml


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


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


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


<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&