在Tomcat5.0的配置中我们可以通过Admin的后台来手动配置JNDI数据源也可以通过修改配置文件的方式来实现数据源的配置,在conf目录下修改server.xml文件在<Host>标签中加入数据源的配置信息
<Context path="/ycportal" docBase="ycportal" debug="0" reloadable="true" crossContext="true">
<Logger className="org.apache.catalina.logger.FileLogger"
prefix="localhost_DBTest_log." suffix=".txt"
timestamp="true"/>
<Resource name="jdbc/webpublish" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/webpublish">
<parameter>
<name>maxActive</name>
<!-- 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>sa</value>
</parameter>
<parameter>
<name>password</name>
<!-- User Password -->
<value>123456</value>
</parameter>
<parameter>
<name>driverClassName</name>
<!-- Database Driver Class Name -->
<value>net.sourceforge.jtds.jdbc.Driver</value>
</parameter>
<parameter>
<name>url</name>
<!-- Database Address -->
<value>jdbc:jtds:sqlserver://localhost/webdb</value>
</parameter>
</ResourceParams>
</Context>
把应用需要的数据库的驱动Drivers包,和启动时需要的jar报拷贝到common目录下的lib目录中就可以了,因为Tomcat的版本不同数据源的配置上存在很大差异,不能一概而论,我这里是使用的Tomcat5.0的安装版本,JDK为1.5。
<Context path="/ycportal" docBase="ycportal" debug="0" reloadable="true" crossContext="true">
<Logger className="org.apache.catalina.logger.FileLogger"
prefix="localhost_DBTest_log." suffix=".txt"
timestamp="true"/>
<Resource name="jdbc/webpublish" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/webpublish">
<parameter>
<name>maxActive</name>
<!-- 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>sa</value>
</parameter>
<parameter>
<name>password</name>
<!-- User Password -->
<value>123456</value>
</parameter>
<parameter>
<name>driverClassName</name>
<!-- Database Driver Class Name -->
<value>net.sourceforge.jtds.jdbc.Driver</value>
</parameter>
<parameter>
<name>url</name>
<!-- Database Address -->
<value>jdbc:jtds:sqlserver://localhost/webdb</value>
</parameter>
</ResourceParams>
</Context>
把应用需要的数据库的驱动Drivers包,和启动时需要的jar报拷贝到common目录下的lib目录中就可以了,因为Tomcat的版本不同数据源的配置上存在很大差异,不能一概而论,我这里是使用的Tomcat5.0的安装版本,JDK为1.5。