tomcat之JNDI数据源配置

时间:2021-09-22 22:50:44

一、docbase包含方式部署项目

D:\apache-tomcat-6.0.29\conf\server.xml里面添加如下内容

 

 <Host name="localhost"  appBase="webapps" unpackWARs="true" autoDeploy="true"
xmlValidation="false" xmlNamespaceAware="false"> <Context debug="9" docBase="D:\Workspaces8.6\testapp\web" path="/" reloadable="true" verbosity="4"> <Resource name="mytest1"
auth="Container" type="javax.sql.DataSource"
password="testadmin"
driverClassName="oracle.jdbc.driver.OracleDriver"
maxIdle="5" maxWait="100"
username="testadmin"
url="jdbc:oracle:thin:@10.5.43.100:1521:ORCL"
maxActive="5" removeAbandoned="true" removeAbandonedTimeout="180" logAbandoned="true"/> <Resource name="mytest2"
auth="Container" type="javax.sql.DataSource"
password="admin"
driverClassName="net.sourceforge.jtds.jdbc.Driver"
maxIdle="5" maxWait="100"
username="admin"
url="jdbc:jtds:sqlserver://10.5.10.66:1433/PMTXX"
maxActive="5" removeAbandoned="true" removeAbandonedTimeout="180" logAbandoned="true"/> </Context>
</Host>

 

 

 

 

二、普通部署项目方式

在META-INF文件夹下面创建context.xml,内容如下:

 

 

<Context debug="9" docBase="D:\Workspaces8.6\testapp\web" path="/" reloadable="true" verbosity="4">

			<Resource name="mytest1"
auth="Container" type="javax.sql.DataSource"
password="testadmin"
driverClassName="oracle.jdbc.driver.OracleDriver"
maxIdle="5" maxWait="100"
username="testadmin"
url="jdbc:oracle:thin:@10.5.43.100:1521:ORCL"
maxActive="5" removeAbandoned="true" removeAbandonedTimeout="180" logAbandoned="true"/> <Resource name="mytest2"
auth="Container" type="javax.sql.DataSource"
password="admin"
driverClassName="net.sourceforge.jtds.jdbc.Driver"
maxIdle="5" maxWait="100"
username="admin"
url="jdbc:jtds:sqlserver://10.5.10.66:1433/PMTXX"
maxActive="5" removeAbandoned="true" removeAbandonedTimeout="180" logAbandoned="true"/> </Context>

 

启动tomcat之后会发现D:\apache-tomcat-6.0.29\conf\Catalina\localhost会多出一个xml文件