Jndi and c3p0 in Tomcat

最新推荐文章于 2021-04-03 22:35:12 发布

最新推荐文章于 2021-04-03 22:35:12 发布 · 164 阅读

文章标签：

#Tomcat #SQL #JDBC #SQL Server #MySQL

Tomcat 专栏收录该内容

10 篇文章

订阅专栏

本文介绍如何在Tomcat中使用JNDI配置c3p0连接池替代默认连接池。通过具体步骤及示例代码展示如何配置server.xml与web.xml文件，并提供一个简单的测试页面。

Tomcat 中Jndi是使用Tomcat自带的连接池
抛弃Tomcat自带的连接池。使用c3p0 。

环境：Tomcat 5.5.20
下面配置只适合Tomcat 5.5.X

下面来看Jndi 与 c3p0 结合：
c3p0 下载地址： http://nchc.dl.sourceforge.net/sourceforge/c3p0/c3p0-0.9.0.4.bin.zip
把 c3p0-0.9.0.4.jar 放到应用服务的WEB-INF/lib目录下。如：DBTest/WEB-INF/lib

1.在server.xml中<Context></Context>内加<Resource />，完整的示例：

< Context path ="/DBTest" docBase ="DBTest"
        debug ="5" reloadable ="true" crossContext ="true" >
< Resource auth ="Container"
driverClass ="com.mysql.jdbc.Driver"
                                    maxPoolSize ="50" minPoolSize ="2" acquireIncrement ="2"
                                    name ="jdbc/connPool" user ="root" password =""
                                    factory ="org.apache.naming.factory.BeanFactory"
                                    type ="com.mchange.v2.c3p0.ComboPooledDataSource"
                                    jdbcUrl ="jdbc:mysql://localhost:3306/test" />
</ Context >

2.在web.xml添加：

   < resource-ref >
       < description > DB Connection </ description >
       < res-ref-name > jdbc/connPool </ res-ref-name >
       < res-type > javax.sql.DataSource </ res-type >
       < res-auth > Container </ res-auth >
   </ resource-ref >

3.测试页面testConnPool.jsp

<% @ page language = " java " pageEncoding = " UTF-8 " %>
<% @ taglib uri = " http://java.sun.com/jsp/jstl/sql " prefix = " sql " %>
<% @ taglib uri = " http://java.sun.com/jsp/jstl/core " prefix = " c " %>

< sql:query var ="rs" dataSource ="jdbc/connPool" >
select id, typename from text
</ sql:query >

< html >
   < head >
     < title > DB Test Conn Pool c3p0 and Jndi </ title >
   </ head >
   < body >

   < h2 > Results </ h2 >

< c:forEach var ="row" items ="${rs.rows}" >
    id: ${row.id} < br />
    name: ${row.typename} < br />
</ c:forEach >

   </ body >
</ html >