Tomcat5.0.28配置jndi (Oracle)

1、copy ojdbc14.jar 到 tomcathome/common/lib 目录

2、修改tomcathome\conf\Catalina\localhost 目录下相应的context文件

<Context path="/aaa" docBase="D:/project/workspace/aaa/WebRoot"
        debug="0" privileged="true">
 <ResourceParams name="jdbc/aaa">
  <parameter>
   <name>factory</name>
   <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
  </parameter>
  <parameter>
   <name>driverClassName</name>
   <value>oracle.jdbc.driver.OracleDriver</value>
  </parameter>
  <parameter>
   <name>url</name>
   <value>jdbc:oracle:thin:@127.0.0.1:1521:orcl</value>
  </parameter>
  <parameter>
   <name>username</name>
   <value>aaa</value>
  </parameter>
  <parameter>
   <name>password</name>
   <value>aaa</value>
  </parameter>
  <parameter>
   <name>maxActive</name>
   <value>20</value>
  </parameter>
  <parameter>
   <name>maxIdle</name>
   <value>10</value>
  </parameter>
  <parameter>
   <name>maxWait</name>
   <value>-1</value>
  </parameter>
 </ResourceParams>
</Context>

一定不能用下面的格式

 <Resource
  name="jdbc/aaa"
  type="javax.sql.DataSource"
  username="aaa"
  password="aaa"
  driverClassName="oracle.jdbc.driver.OracleDriver"
  maxIdle="3"
  maxWait="5000"
  url="jdbc:oracle:thin:@127.0.0.1:1521:orcl"
  maxActive="10"/>

3、在web.xml中引用资源

 <resource-ref>
  <description>User database that can be updated and saved</description>
  <res-ref-name>jdbc/aaa</res-ref-name>
  <res-type>javax.sql.DataSource</res-type>
  <res-auth>Container</res-auth>
 </resource-ref>

4、java代码中调用

   ctx = new InitialContext();
    ds = (DataSource)ctx.lookup("java:comp/env/jdbc/aaa");