我这有一?/p>
Tomcat+Oracle
连接池的例子,放上来和大家分享一下?/p>
Tomcat 5.5.17+Oracle 9.0.1.1.1
连接池配?/p>
Author:
Kenneth.Leaf@GalaxySoft
Date: 7/25/2006
Time: 10:20:57 PM
环境?/p>
Windows 2000 Advanced Server
Tomcat 5.5.17
Oracle9i Enterprise Edition Release 9.0.1.1.1
JDK 1.5
Eclipse 3.1.0
MyEclipse 4.1.0 GA
项目名称?/p>
TestingProject
配置步骤?/p>
1.
?/p>
Tomcat
?/p>
Oracle
?/p>
8080
端口处会产生冲突,因此在安装
Tomcat 5.5.17
时,设置端口
?/p>
10240.
2.
?/p>
Oracle
的驱动包
classes12.jar
复制?/p>
%CATALINA_HOME%\\common\\lib
?/p>
;
3.
?/p>
jakarta-tomcat-5.0.28.exe
以前是有默认?/p>
admin
模块,在
jakarta-tomcat-5.5.9.
后则?/p>
有安装默认的
admin
模块,这?/p>
http://127.0.0.1:10240/admin
打开时则会出?/p>
Tomcat\'s administration web application is no longer installed by default. Download and install
the "admin"
package to use it.
?/p>
?/p>
?/p>
?/p>
?/p>
?/p>
需
?/p>
?/p>
http://www.apache.org/dist/tomcat/tomcat-5/v5.5.17/bin/
?/p>
?/p>
"admin"package
?/p>
:
jakarta-tomcat-5.5.17.zip(Tomcat
压缩版,已安装的无须再下?/p>
)
jakarta-tomcat-5.5.17-compat.zip(
如用
JDK1.4
,需?/p>
compat.zip;
?/p>
JDK1.5
则可免?/p>
)
jakarta-tomcat-5.5.17-admin.zip
4.
?/p>
http://127.0.0.1:10240/admin
进入
Tomcat
管理界面增加
Data Sources:
JNDI Name: jdbc/music
Data Source URL: jdbc:oracle:thin:@127.0.0.1:1521:GALAXY
JDBC Driver Class: oracle.jdbc.driver.OracleDriver
User Name: scott
Password: tiger
Max. Active Connections: 4
Max. Idle Connections: 2
Max. Wait for Connection: 5000
Validation Query:
可填可不?/p>