tomcat配置文件中server.xml文件连接oracle数据库时的常规配置:
<?xml version='1.0' encoding='utf-8'?>
<Server port="8012" shutdown="SHUTDOWN">
<!--APR library loader. Documentation at /docs/apr.html -->
<Listener className="org.apache.catalina.core.AprLifecycleListener" SSLEngine="on" />
<!--Initialize Jasper prior to webapps are loaded. Documentation at /docs/jasper-howto.html -->
<Listener className="org.apache.catalina.core.JasperListener" />
<!-- Prevent memory leaks due to use of particular java/javax APIs-->
<Listener className="org.apache.catalina.core.JreMemoryLeakPreventionListener" />
<!-- JMX Support for the Tomcat server. Documentation at /docs/non-existent.html -->
<Listener className="org.apache.catalina.mbeans.ServerLifecycleListener" />
<Listener className="org.apache.catalina.mbeans.GlobalResourcesLifecycleListener" />
<!-- Global JNDI resources Documentation at /docs/jndi-resources-howto.html -->
<GlobalNamingResources>
<Resource name="UserDatabase" auth="Container"
type="org.apache.catalina.UserDatabase"
description="User database that can be updated and saved"
factory="org.apache.catalina.users.MemoryUserDatabaseFactory"
pathname="conf/tomcat-users.xml" />
</GlobalNamingResources>
<Service name="Catalina">
<Connector port="8383" protocol="HTTP/1.1" connectionTimeout="20000" redirectPort="8443" />
<!--<Connector port="8009" protocol="AJP/1.3" redirectPort="8443" />-->
<Engine name="Catalina" defaultHost="localhost">
<Realm className="org.apache.catalina.realm.LockOutRealm">
<Realm className="org.apache.catalina.realm.UserDatabaseRealm" resourceName="UserDatabase"/>
</Realm>
<Host name="localhost" appBase="webapps" unpackWARs="true" autoDeploy="true" xmlValidation="false" xmlNamespaceAware="false">
<Context path="" docBase="D:\apachetomcat\webapps\发布文件的名称" URIEncoding="UTF-8" debug="0" privileged="true" reloadable="true"><!-- docBase配置为发布的项目的路径-->
<Resource name="jdbc/recruitDS" <!--资源名称-->
type="javax.sql.DataSource"
driverClassName="oracle.jdbc.OracleDriver"
maxActive="150"
maxIdle="20"
maxWait="10000"
username="连接数据库的用户名"
password="连接数据库的密码"
url="连接数据的URL"
/>
</Context>
</Host>
</Engine>
</Service>
</Server>