qiyadeng

專注于Java示例及教程

posts - 84, comments - 152, trackbacks - 0, articles - 34

Tomcat中配置MySQL連接池

Posted on 2005-10-11 10:13 qiyadeng 閱讀(2701) 評論(0) 編輯收藏所屬分類: J2EE

1.把驅動拷貝到%TOMCAT_HOME%/common/lib目錄下
2.新建數據庫表，并向表中添加記錄

use test;
2

create table testdata (
3

id int not null auto_increment primary key,
4

foo varchar(25),
5

bar int);
6

insert into testdata values(null, 'hello', 12345);
7

3.在%TOMCAT_HOME%/config/server.xml文件中加入如下一段配置信息(在</Host>之前)

2

3

<Context path="/WS4Motel" docBase="WS4Motel"
4

debug="5" reloadable="true" crossContext="true">
5

<!-- maxActive: Maximum number of dB connections in pool. Make sure you
7

configure your mysqld max_connections large enough to handle
8

all of your db connections. Set to 0 for no limit.
9

-->
10

<!-- maxIdle: Maximum number of idle dB connections to retain in pool.
12

Set to -1 for no limit. See also the DBCP documentation on this
13

and the minEvictableIdleTimeMillis configuration parameter.
14

-->
15

<!-- maxWait: Maximum time to wait for a dB connection to become available
17

in ms, in this example 10 seconds. An Exception is thrown if
18

this timeout is exceeded. Set to -1 to wait indefinitely.
19

-->
20

22

<!-- driverClassName: Class name for the old mm.mysql JDBC driver is
24

org.gjt.mm.mysql.Driver - we recommend using Connector/J though.
25

Class name for the official MySQL Connector/J driver is com.mysql.jdbc.Driver.
26

-->
27

<!-- url: The JDBC connection url for connecting to your MySQL dB.
29

The autoReconnect=true argument to the url makes sure that the
30

mm.mysql JDBC Driver will automatically reconnect if mysqld closed the
31

connection. mysqld by default closes idle connections after 8 hours.
32

-->
33

<Resource name="jdbc/WS4Motel" auth="Container" type="javax.sql.DataSource"
35

maxActive="100" maxIdle="30" maxWait="10000"
36

username="root" password="83072674" driverClassName="com.mysql.jdbc.Driver"
37

url="jdbc:mysql://localhost:3306/test?autoReconnect=true"/>
38

</Context>
40

41

4.寫個簡單程序測試下：

<%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql" %>
2

<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
3

<sql:query var="rs" dataSource="jdbc/TestDB">
5

select id, foo, bar from testdata
6

</sql:query>
7

<html>
9

<head>
10

<title>DB Test</title>
11

</head>
12

<body>
13

<h2>Results</h2>
15

<c:forEach var="row" items="${rs.rows}">
17

Foo ${row.foo}<br/>
18

Bar ${row.bar}<br/>
19

</c:forEach>
20

</body>
22

</html>
23

新用戶注冊刷新評論列表


只有注冊用戶登錄后才能發表評論。




網站導航: 博客園 IT新聞 Chat2DB C++博客博問管理
相關文章: Struts Checkbox radio怎么進行動態的選擇 tab tag 與Struts整合 Struts之自定義Validator 用AXIS開始WebService之設置 Tomcat中配置MySQL連接池獲取本地主機的MAC地址 JSP中文問題研究了下 Struts-Layout iReport的簡單配置在web project中使用log4j

qiyadeng

導航

公告

常用鏈接

留言簿(12)

文章分類(35)

相冊

J2EE

Others

Tools

積分與排名

最新評論

閱讀排行榜

Tomcat中配置MySQL連接池