tomcat内置数据源(内置了dbcp数据源)

最新推荐文章于 2020-12-23 05:17:40 发布

原创最新推荐文章于 2020-12-23 05:17:40 发布 · 882 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#内置数据源 #jsp #java #context

java 专栏收录该内容

29 篇文章

订阅专栏

本文介绍如何在Tomcat服务器中配置MySQL数据源，包括在lib目录放置mysql-connector-java-5.0.8-bin.jar驱动包，以及通过不同层级的context.xml文件设置数据源参数。

1、在tomcat安装目录下的lib目录下导入数据驱动包 mysql-connector-java-5.0.8-bin.jar。

2、在context中配置数据源。有5个位置可以配置参考tomcat文档：

只对这个项目起作用
In an individual file at /META-INF/context.xml inside the application files. Optionally (based on the Host's copyXML attribute) this may be copied to $CATALINA_BASE/conf/[enginename]/[hostname]/ and renamed to application's base file name plus a ".xml" extension.
对CATALINA_BASE下的项目都起作用
In individual files (with a ".xml" extension) in the $CATALINA_BASE/conf/[enginename]/[hostname]/ directory. The context path and version will be derived from the base name of the file (the file name less the .xml extension). This file will always take precedence over any context.xml file packaged in the web application's META-INF directory.
对所有的tomcat下目录起作用
Inside a Host element in the main conf/server.xml.

In the $CATALINA_BASE/conf/context.xml file: the Context element information will be loaded by all web applications.
In the $CATALINA_BASE/conf/[enginename]/[hostname]/context.xml.default file: the Context element information will be loaded by all web applications of that host.

3、context目录配置例子

<?xml version="1.0" ?>
<Context>
  <Resource name="mySource"
            auth="Container"
            type="javax.sql.DataSource"
            username="root"
            password="123456"
            driverClassName="com.mysql.jdbc.Driver"
            url="jdbc:mysql:///dayjdbc"
            maxActive="8"
            maxIdle="4"/>
</Context>