win2000+Tomcat5.0.27+Oracle8.1.7配置連接池
2024-08-29 13:49:42
供稿：網友
【方法一】在Tomcat4中，配置連接池，常見的就是在server.xml和web.xml中作相應配置。在針對單個項目文件情況下，Tomcat5中我們可以不在server.xml中配置Context（實際上，我們在server.xml中默認情況下沒有看見Context標記）,可以在/jakarta-tomcat-5.0.27/conf/Catalina/localhost下針對具體的文件夾名.xml（如：我的是blog.xml)中配置Context,這樣也就免去了在web.xml中還要配置。
<?xml version='1.0' encoding='gb2312'?>
<Context displayName="Cactus Blog Web application 1.0" docBase="F:/jakarta-tomcat-5.0.27/webapps/blog" path="/blog" workDir="work/Catalina/localhost/blog">
<Resource auth="Container" description="Oracle DataBase" name="jdbc/blog" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/blog">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>-1</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>10</value>
</parameter>
<parameter>
<name>passWord</name>
<value>。。</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=blog</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
</parameter><!--對應oracle參數 <parameter>
<name>url</name>
<value>jdbc:oracle:thin:@localhost:1521:mydata</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value>
</parameter>-->
<parameter>
<name>maxIdle</name>
<value>10</value>
</parameter>
<parameter>
<name>username</name>
<value>sa</value>
</parameter>
</ResourceParams>
</Context>
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
總結：Tomcat5中，可以不在server.xml和web.xml中配置就能實現連接池配置；這應該是Tomcat5的功能相對Tomcat4的提高，有些朋友在Tomcat5中（使用在Tomcat4中配置方法）來配置連接池不能正常使用，可以采用這個方法，更快捷?。?/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////【方法二】看到關注這方面內容人比較多，考慮到各人理解層度不一樣，現把常見配置方式具體步驟也增加上來（tomcat-5.0.27），對tomcat5都適用。第一步：在tomcat的治理員界面中設置Data Source(common/lib下增加oracle驅動：classes12.jar.classes12-for oracle8.jar)
JNDI Name: jdbc/mydata
Data Source URL: jdbc:oracle:thin:@localhost:1521:mydata
JDBC Driver Class: oracle.jdbc.driver.OracleDriver
User Name: 。。。 //如system
Password: 。。。//如manager
Max. Active Connections: 4
Max. Idle Connections:2
Max. Wait for Connection: 5000
Validation Query:
第二步：在/jakarta-tomcat-5.0.27/webapps/DeoWeb/WEB-INF的web.xml配置
<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE web-app PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
"http://java.sun.com/dtd/web-app_2_3.dtd">
<web-app>
<display-name>My Web Application</display-name>
<description>
MY homesite.
</description><resource-ref>
<description>
oracle DataSource
</description>
<res-ref-name>
jdbc/mydata
</res-ref-name>
<res-type>
javax.sql.DataSource
</res-type>
<res-auth>
Container
</res-auth>
</resource-ref>
</web-app>
第三步：啟動tomcat后conf/confserver.xml自動變成了這個樣子（自動發布為全局連接池）：
<?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 name="jdbc/mydata" 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/mydata">
<parameter>
<name>maxWait</name>
<value>5000</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>4</value>
</parameter>
<parameter>
<name>password</name>
<value>manager</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:oracle:thin:@localhost:1521:mydata</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>2</value>
</parameter>
<parameter>
<name>username</name>
<value>system</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">
<Context path=" " docBase="."/>
<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>
第四步：寫了個簡單jsp測試：
<!DOCTYPE Html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<%@ page contentType="text/html; charset=iso-8859-1" %>
<%@ 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></title><% out.println("Test begin!"); try{ InitialContext ctx=new InitialContext();
out.println("First sUCcess!"); DataSource ds=(DataSource)ctx.lookup("java:comp/env/jdbc/mydata");
out.println("Second success!"); Connection conn = ds.getConnection();
out.println("Third success!");
Statement stmt = conn.createStatement(); String strSql = "select * from sys.signon"; ResultSet rs = stmt.executeQuery(strSql); while(rs.next()){ out.print(rs.getString(1)); } out.print("我的測試結束");
} catch(Exception ex){ out.print("There is exception:"+ex.getMessage()); ex.printStackTrace(); }
%></head><body></body></html>
