室内空间设计要素:jsp连接池配置

来源:百度文库 编辑:中科新闻网 时间:2024/04/29 21:20:35
为什么配置好了连接池后,tomcat启动不了了呀,哪位高人救救急呀!!!
我用的是tomcat5.5,数据库名为rcgl,根目录为d:/c_linhai/tomcat/webapps/ROOT,
我在tomcat/conf/server.xml的<host></host>加入了如下代码:
<Context path="/ROOT" docBase="d://c_linhai/tomcat/webapps/ROOt" debug="0" reloadable="true" >
<Resource name="jdbc/db"
auth="Container"
type="javax.sql.DataSource" />
<ResourceParams name="jdbc/db">
<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 0 for no limit.
-->
<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.
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>
<!—SQLServer dB username and password for dB connections -->
<parameter>
<name>username</name>
<value></value>
</parameter>
<parameter>
<name>password</name>
<value></value>
</parameter>
<!-- Class name for mm.mysql JDBC driver -->
<parameter>
<name>driverClassName</name>
<value>Com.microsoft.jdbc.sqlserver.SQLServerDriver</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:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=rcgl</value>
</parameter>
</ResourceParams>
</Context>
而且在common/lib中加入了那三个驱动,还在jsp目录下的web-inf中加入了如下代码:
<resource-ref>
<description>DB Connection</description>
<res-ref-name>jdbc/db</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
到底哪出问题了么??????????????谢谢各位了,帮帮忙了~!!!!!!!!!!!

TOMCAT是一个可以直接提供WEB服务的JSP服务器
所以
要想运行调试jsp网页,只要电脑上装有TOMCAT和JDK就可以了~
或者 你只要 装APCHE 也行~没必要两个都装的
然后就主要是设置环境变量的问题了~
设置好后
把你编辑好的JSP网页保存到TOMCAT的ROOT目录里面
然后在地址栏输入路径http://localhost:8080/网页名称 就可以了运行了~
如果网页需要连接数据库
那么还需要安装一个数据库软件如MYSQL