Tomcat5.5x+jndi配置

1、配置Tomcat5.5.X的Server.xml，在<host>下面加上： 



<Context path="/JNDIDemo" docBase="D:\workspace\JNDIDemo\WebRoot" debug="0" reloadable="true" crossContext="true"> 

<Logger className="org.apache.catalina.logger.FileLogger" prefix="localhost_quality_log." suffix=".txt" timestamp="true"/> 

<Resource 

name="jdbc/test" <!-- JNDI数据池名称 --> 

type="javax.sql.DataSource" <!-- 数据类 --> 

password="karid" <!-- 密码 --> 

driverClassName="oracle.jdbc.driver.OracleDriver" <!-- 驱动 --> 

maxIdle="2" <!-- 最少可用lia --> 

maxWait="5000" <!-- 最大等待时间 5秒 --> 

username="karid" <!-- 用户名 --> 

url="jdbc:oracle:thin:@127.0.0.1:1521:karid" 

maxActive="4" <!-- 最大可用连接 --> /> 



<ResourceParams name="jdbc/test"> 



<parameter> 

<name>removeAbandoned</name> 

<!-- Abandoned DB connections are removed and recycled --> 

<value>true</value> 

</parameter> 

<parameter> 

<name>removeAbandonedTimeout</name> 

<!-- Use the removeAbandonedTimeout parameter to set the number of seconds a DB connection has been idle before it is considered abandoned. --> 

<value>60</value> 

</parameter> 

<parameter> 

<name>logAbandoned</name> 

<!-- Log a stack trace of the code which abandoned --> 

<value>false</value> 

</parameter> 



<parameter> 

<name>factory</name> 

<!--DBCP Basic Datasource Factory --> 

<value>org.apache.commons.dbcp.BasicDataSourceFactory</value> 

</parameter> 



</ResourceParams> 







2、配置web.xml



<description>MySQL Test App</description> 

<resource-ref> 

<description>DB Connection</description> 

<res-ref-name>jdbc/test</res-ref-name> 

<res-type>javax.sql.DataSource</res-type> 

<res-auth>Container</res-auth> 

</resource-ref> 



3、JNDI使用



public class DataSourceFactory 

{ 

private static DataSource ds; 

public static DataSource createDataSourde() 

{ 

if (ds == null) 

{ 

try 

{ 

Context initContext = new InitialContext(); 

if (initContext == null) 

System.out.println("无配置环境"); 

Context envContext = (Context) initContext.lookup("java:/compenv"); 

ds = (DataSource) envContext.lookup("jdbc/test"); //根据名称取得数据源 

} 

catch (NamingException e) 

{ 

e.printStackTrace(); 

} 

} 

return ds; 

} 

}