tomcat6.0.20配置jndi，spring配置

1、环境
     1)tomcat 6.0.20 
     2)oracle版本：Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit
       通过pl sql 查看oracle版本sql:select banner from sys.v_$version
     3)jdk版本：1.5.0_16
     4)oracle驱动jar包：ojdbc14-10.2.0.3.jar
     5)如果出现这个错误   java.lang.NoClassDefFoundError:  
        oracle/dms/instrument/ExecutionContextForJDBC
        则需要到oracle安装目录下拷dms.jar到%TOMCATHOME%\lib下
2、配置tomcat jndi数据源
     1)%TOMCATHOME%\conf\context.xml
         在<Context></Context>直接添加
       <Resource name="jdbc/myoracle" auth="Container"
              type="javax.sql.DataSource" driverClassName="oracle.jdbc.OracleDriver"
              url="jdbc:oracle:thin:@localhost:billdb" username="orcl" password="orcl" maxActive="20"
              maxIdle="10" maxWait="-1"/>
    2)%TOMCATHOME%\conf\web.xml
       在<web-app>下添加
       <resource-ref>
         <description>Oracle Datasource example</description>
         <res-ref-name>jdbc/myoracle</res-ref-name>
         <res-type>javax.sql.DataSource</res-type>
         <res-auth>Container</res-auth>
      </resource-ref>
3、Spring配置
    <bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean">  
        <property name="jndiName" value="java:/comp/env/jdbc/myoracle"></property>  
    </bean>
   也可以通过jsp来测试
   <%
    out.print("测试连接池<br/>");
    try{
        Context initContext = new InitialContext();
        Context envContext = (Context)initContext.lookup("java:/comp/env");
        DataSource ds = (DataSource)envContext.lookup("jdbc/myoracle");
        Connection conn = ds.getConnection();
        out.print("connection success!");
        conn.close();
    }
    catch(Exception ex){
    out.println("连接错误：");
    out.print(ex.printStackTrace());
    }
    %>