Tomcat 數據庫連接池配置

前言 :

? 1? 準備 mysql 的 jdbc 驅動程序

? 2? 安裝 Tomcat 默認全部裝在 D:\Server\tomcat5.0 D:\Server\tomcat5.5 D:\Server\tomcat6.0

? 3? 以 TOMCAT_HOME 代替個版本的安裝目錄

4???????? 將 jdbc 驅動放入 TOMCAT_HOME\ common\lib\ 下面

5???????? 如果是其他數據庫的話，就是換一下 jdbc 驅動以及各種參數就可以了的

6???????? 配置 tomcat 數據源時的各種參數的詳細介紹

7???????? 其他設置。

1.?????? Tomcat 4.0

待添加

2.?????? Tomcat 5.0

2.1??? 建一個虛擬目錄 test? (TOMCAT_HOME\webapps\)

? 可以通過 http://localhost:8080/test 訪問你的網站了

2.2??? 配置 Context ( 在 TOMCAT_HOME\conf\Catalina\localhost\ 下 建 test.xm,)

test.xml:

<?xml version="1.0" encoding="utf-8"?>

<Context docBase="dbpool" path="/test" workDir="work\Catalina\localhost\test">

</Context>

2.3??? 配置 server.xml

server.xml? 的內容 : 紅色表示加入的 ( 或者通過 http://localhost:8080/admin 進行可視化配置 )

<?xml version='1.0' encoding='utf-8'?>

<Server>

? <Listener className="org.apache.catalina.mbeans.ServerLifecycleListener"/>

? <Listener className="org.apache.catalina.mbeans.GlobalResourcesLifecycleListener"/>

? <GlobalNamingResources>

??? <Environment name="simpleValue" type="java.lang.Integer" value="30"/>

??? <Resource auth="Container" description="User database that can be updated and saved" name="UserDatabase" type="org.apache.catalina.UserDatabase"/>

?? ?<Resource auth="Container" name="jdbc/mysql" type="javax.sql.DataSource"/>

??? <ResourceParams name="UserDatabase">

????? <parameter>

??????? <name>factory</name>

??????? <value>org.apache.catalina.users.MemoryUserDatabaseFactory</value>

????? </parameter>

????? <parameter>

??????? <name>pathname</name>

??????? <value>conf/tomcat-users.xml</value>

????? </parameter>

??? </ResourceParams>

?? ?<ResourceParams name="jdbc/mysql">

????? <parameter>

??????? <name>maxWait</name>

??????? <value>5000</value>

????? </parameter>

????? <parameter>

??????? <name>maxActive</name>

??????? <value>4</value>

???? ?</parameter>

????? <parameter>

??????? <name>password</name>

??????? <value>198395</value>

????? </parameter>

????? <parameter>

??????? <name>url</name>

??????? <value>jdbc:mysql://localhost:3306/study?autoReconnect=true</value>

????? </parameter>

????? <parameter>

??????? <name>driverClassName</name>

??????? <value>com.mysql.jdbc.Driver</value>

????? </parameter>

????? <parameter>

??????? <name>maxIdle</name>

??????? <value>2</value>

????? </parameter>

????? <parameter>

??????? <name>username</name>

???? ???<value>sa</value>

????? </parameter>

??? </ResourceParams>

? </GlobalNamingResources>

? <Service name="Catalina">

??? <Connector acceptCount="100" connectionTimeout="20000" disableUploadTimeout="true" port="8080" redirectPort="8443" maxSpareThreads="75" maxThreads="150" minSpareThreads="25">

??? </Connector>

??? <Connector port="8009" protocol="AJP/1.3" protocolHandlerClassName="org.apache.jk.server.JkCoyoteHandler" redirectPort="8443">

??? </Connector>

??? <Engine defaultHost="localhost" name="Catalina">

????? <Host appBase="webapps" name="localhost">

??????? <Logger className="org.apache.catalina.logger.FileLogger" prefix="localhost_log." suffix=".txt" timestamp="true"/>

????? </Host>

????? <Logger className="org.apache.catalina.logger.FileLogger" prefix="catalina_log." suffix=".txt" timestamp="true"/>

????? <Realm className="org.apache.catalina.realm.UserDatabaseRealm"/>

??? </Engine>

? </Service>

</Server>

?

?

2.4??? 配置 虛擬目錄命名的 test.xml

test.xml: 紅色表示加入的

<?xml version='1.0' encoding='utf-8'?>

<Context docBase="testds" path="/testds" workDir="work\Catalina\localhost\testds">

<Resource name="jdbc/mysql" type="javax.sql.DataSource"/>

<ResourceParams name="jdbc/mysql">

<parameter>

<name>maxWait</name>

<value>5000</value>

</parameter>

<parameter>

<name>maxActive</name>

<value>4</value>

</parameter>

<parameter>

<name>url</name>

<value>jdbc:mysql://127.0.0.1:3306/study?useUnicode=true</value>

</parameter>

<parameter>

<name>driverClassName</name>

<value>org.gjt.mm.mysql.Driver</value>

</parameter>

<parameter>

<name>maxIdle</name>

<value>2</value>

</parameter>

<parameter>

<name>username</name>

<value>sa</value>

</parameter>

<parameter>

<name>password</name>

<value>198395</value>

</parameter>

</ResourceParams>

</Context>

配置完畢

?

3.?????? Tomcat 5.5

3.1??? 建虛擬目錄 test( 在 TOMCAT_HOME/webapp 或者其地方 )

? 可以通過 http://localhost:8080/test 訪問你的網站了

3.2??? 配置 server..xml( 或者可以通過 http://localhost:8080/admin 來可視化界面來完成 )

server.xml 內容 紅色是加入的內容

<?xml version="1.0" encoding="UTF-8"?>

<Server>

? <Listener className="org.apache.catalina.core.AprLifecycleListener"/>

? <Listener className="org.apache.catalina.mbeans.GlobalResourcesLifecycleListener"/>

? <Listener className="org.apache.catalina.storeconfig.StoreConfigLifecycleListener"/>

? <Listener className="org.apache.catalina.mbeans.ServerLifecycleListener"/>

? <GlobalNamingResources>

??? <Environment

????? name="simpleValue"

????? type="java.lang.Integer"

????? value="30"/>

??? <Resource

????? auth="Container"

????? description="User database that can be updated and saved"

????? name="UserDatabase"

????? type="org.apache.catalina.UserDatabase"

????? pathname="conf/tomcat-users.xml"

????? factory="org.apache.catalina.users.MemoryUserDatabaseFactory"/>

?? ?<Resource

????? name="jdbc/mysql"

????? type="javax.sql.DataSource"

????? password="198395"

????? driverClassName="com.mysql.jdbc.Driver"

????? maxIdle="2"

????? maxWait="5000"

????? username="sa"

? ????url="jdbc:mysql://localhost:3306/study?autoReconnect=true"

????? maxActive="4"/>

? </GlobalNamingResources>

? <Service

????? name="Catalina">

??? <Connector

??????? port="8080"

??????? redirectPort="8443"

??????? minSpareThreads="25"

??????? connectionTimeout="20000"

??????? maxSpareThreads="75"

??????? maxThreads="150">

??? </Connector>

??? <Connector

??????? port="8009"

??????? redirectPort="8443"

??????? protocol="AJP/1.3">

??? </Connector>

??? <Engine

??????? defaultHost="localhost"

??????? name="Catalina">

????? <Realm className="org.apache.catalina.realm.UserDatabaseRealm"/>

????? <Host

????????? appBase="webapps"

????????? name="localhost">

????? </Host>

??? </Engine>

? </Service>

</Server>

?

3.3??? 配置 Context ( 在 TOMCAT_HOME\conf\Catalina\localhost\ 下 建 test.xml 與項目名字一樣 )

? test.xml ? 紅色表示新加入的

<?xml version="1.0" encoding="UTF-8"?>

<Context path="/test" docBase="test" reloadable="true" crossContext="true" debug="0" >

<Resource name="jdbc/mysql" auth="Container" type="javax.sql.DataSource" maxActive="100" maxIdle="30" maxWait="10000" username="sa" password="198395" driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/study?useUnicode=true"/>

</Context>

4.?????? Tomcat 6.0

?

5.?????? 測試用例

?

?

DatasourceCon.jsp

<%@ page language="java" pageEncoding="utf-8"%>

<%@ page import="java.sql.*"%>

<%@ page import="javax.sql.*"%>

<%@ page import="javax.naming.*"%>

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=gb2312">

<title>Test of Tomcat ?connection pool</title>

</head>

<body>

<%

out.print("strat test connection pool!<br/>");

try{

?Context initCtx = new InitialContext();

?Context ctx = (Context) initCtx.lookup("java:comp/env");

?Object obj = (Object) ctx.lookup("jdbc/mysql");

?DataSource ds = (javax.sql.DataSource)obj;

?Connection conn = ds.getConnection();

?out.print("tomcat mysql connection pool runs perfectly!");

?conn.close();

}

catch(Exception ex){

?out.print(ex.getMessage());

?ex.printStackTrace();

}

%>

</body>

</html>

6.?????? 總結

好長時間沒有寫這個了，最近因為項目的需要，根據以前配置過的，現在重新配置一下，然后寫成詳細文檔！