Tomcat连接池(JNDI)安装配置

方法一;
1、拷贝jdbc驱动到 %TOMCAT_HOME%/common/lib和%TOMCAT_HOME%/webapps/yourweb/WEB-INF/lib里面
2、修改%TOMCAT_HOME%/conf/server.xml
<GlobalNamingResources>
…
<Resource
name="ConnectDB"
type="javax.sql.DataSource"
password="wage"
driverClassName="oracle.jdbc.driver.OracleDriver"
maxIdle="2"
maxWait="5000"
username="wage"
url="jdbc:oracle:thin:@192.168.11.108:1521:zhis4"
maxActive="4"/>
</GlobalNamingResources>
3、在%TOMCAT_HOME%/conf/Catalina/localhost下新建一个与你web文件夹同名的xml文件,如wage.xml,一定要相同
文件的内容
<?xml version="1.0" encoding="UTF-8"?>
<Context>
<Resource
name="ConnectDB"
type="javax.sql.DataSource"
password="wage"
driverClassName="oracle.jdbc.driver.OracleDriver"
maxIdle="2"
maxWait="5000"
username="wage"
url="jdbc:oracle:thin:@192.168.11.108:1521:zhis4"
maxActive="4"/>
</Context>
4、修改%TOMCAT_HOME%/webapps/yourweb/WEB-INF/web.xml
<web-app>
…
<resource-ref>
<description>ConnectDB</description>
<res-ref-name>ConnectDB</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
</web-app>
5、调用
DataSource ds=null;
Context initCtx=new InitialContext();
Context envCtx=(Context)initCtx.lookup("java:comp/env");
ds=(DataSource)envCtx.lookup("ConnectDB");
%>
<%
if(ds!=null){
System.out.println("已经获得DataSource");
Connection con = ds.getConnection();
Statement stmt=con.createStatement();
%>
方法二
直接在webappsyouweb下面建立
META-INFcontext.xml

<Context>

<Resource
auth="Container"
description="ConnectDB"
name="jdbc/zysoft"
type="javax.sql.DataSource"
url="jdbc:oracle:thin:@192.168.2.100:1521:zhis4"
username="wage"
password="wage"
driverClassName="oracle.jdbc.driver.OracleDriver"
maxIdle="10"
maxWait="60"
maxActive="100"
removeAbandoned="true"
removeAbandonedTimeout="1"
logAbandoned="false"
/>
</Context>
这种方法好像不能用虚拟路径