补充TOMCAT用的是4.1.27,数据库是ORACLE9
SERVER.XML配置如下:
        <!-- Tomcat Root Context -->          <Context path="" docBase="E:\xyq\eiro\webapp" debug="0"> 
                     
          <Resource name="jdbc/OracleDB" auth="Container" type="javax.sql.DataSource"/> 
                             
          <ResourceParams name="jdbc/OracleDB">
                             
            <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:@192.168.0.11:1521:oranjzg1.PRIENT.COM</value>
                             
            </parameter>
                             
            <parameter>
                                    
  <name>username</name>
    
  <value>zhengguan</value>
                             
            </parameter>
                             
            <parameter>
                                    
  <name>password</name>
    
  <value>mike</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>

解决方案 »

  1.   

    你的应用 WEB-INF\web.xml要加上
    <description> Mysql Test App </description>
      <resource-ref>
        <description> DB Connection</description>
        <res-ref-name>jdbc/OracleDB</res-ref-name>
        <res-type>javax.sql.DataSource</res-type>
        <res-auth>Container</res-auth>
      </resource-ref>
    其实连接池都已经是j2ee的范畴了,都用jndi了
      

  2.   

    web.xml已经配置了啊报错如下:
    java.sql.SQLException: Io 异常: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153092352)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))