●●●JNDI连接数据库竟然出现这样的错误，晕啊●●●

Question

如果jdbc驱动正确放置的话那就是数据源没有正确配置。给你一个作参考：
<Resource name="xyhfw_dsn" auth="Container" 
          type="javax.sql.DataSource" />   <ResourceParams name="xyhfw_dsn">
    <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:@localhost:1521:xieyh</value>
    </parameter>
    <parameter>
      <name>username</name>
      <value>scott</value>
    </parameter>
    <parameter>
      <name>password</name>
      <value>tiger</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>

Answer 1

server.xml如下：
  <GlobalNamingResources>
    <Environment value="30" type="java.lang.Integer" override="true" name="simpleValue"/>
    <Resource type="org.apache.catalina.UserDatabase" scope="Shareable" description="User database that can be updated and saved" auth="Container" name="UserDatabase"/>
    <Resource type="javax.sql.DataSource" scope="Shareable" name="jdbc/OracleDB"/>
    <ResourceParams name="UserDatabase">
      <parameter>
        <name>factory</name>
        <value>org.apache.catalina.users.MemoryUserDatabaseFactory</value>
      </parameter>
      <parameter>
        <name>pathname</name>
        <value>conf/tomcat-users.xml</value>
      </parameter>
    </ResourceParams>
    <ResourceParams name="jdbc/OracleDB">
      <parameter>
        <name>maxWait</name>
        <value>5000</value>
      </parameter>
      <parameter>
        <name>maxActive</name>
        <value>20</value>
      </parameter>
      <parameter>
        <name>password</name>
        <value>ihscsystemadmin</value>
      </parameter>
      <parameter>
        <name>url</name>
        <value>jdbc:oracle:thin:@192.168.100.100:1521:ihscdb</value>
      </parameter>
      <parameter>
        <name>driverClassName</name>
        <value>oracle.jdbc.driver.OracleDriver</value>
      </parameter>
      <parameter>
        <name>maxIdle</name>
        <value>10</value>
      </parameter>
      <parameter>
        <name>username</name>
        <value>system</value>
      </parameter>
    </ResourceParams>
  </GlobalNamingResources>
        <Context className="org.apache.catalina.core.StandardContext" wrapperClass="org.apache.catalina.core.StandardWrapper" privileged="false" crossContext="false" swallowOutput="false" cookies="true" workDir="work\Standalone\localhost\_" docBase="ROOT" path="" charsetMapperClass="org.apache.catalina.util.CharsetMapper" useNaming="true" debug="0" mapperClass="org.apache.catalina.core.StandardContextMapper" cachingAllowed="true" reloadable="false" displayName="Welcome to Tomcat">
          <Resource type="javax.sql.DataSource" scope="Shareable" auth="Container" name="jdbc/OracleDB"/>
          <ResourceParams name="jdbc/OracleDB">
            <parameter>
              <name>factory</name>
              <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
            </parameter>
            <parameter>
              <name>maxWait</name>
              <value>-1</value>
            </parameter>
            <parameter>
              <name>maxActive</name>
              <value>20</value>
            </parameter>
            <parameter>
              <name>password</name>
              <value>ihscsystemadmin</value>
            </parameter>
            <parameter>
              <name>url</name>
              <value>jdbc:oracle:thin:@192.168.100.100:1521:ihscdb</value>
            </parameter>
            <parameter>
              <name>driverClassName</name>
              <value>oracle.jdbc.driver.OracleDriver</value>
            </parameter>
            <parameter>
              <name>maxIdle</name>
              <value>10</value>
            </parameter>
            <parameter>
              <name>username</name>
              <value>system</value>
            </parameter>
          </ResourceParams>
        </Context>

Answer 2

web.xml如下：<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE web-app PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN" "http://java.sun.com/j2ee/dtds/web-app_2_3.dtd">
<web-app>
    <servlet>
        <servlet-name>action</servlet-name>
        <servlet-class>org.apache.struts.action.ActionServlet</servlet-class>     
<init-param>
            <param-name>config</param-name>
            <param-value>/WEB-INF/struts-config.xml</param-value>
        </init-param>
        <init-param>
            <param-name>debug</param-name>
            <param-value>3</param-value>
        </init-param>
        <init-param>
            <param-name>detail</param-name>
            <param-value>3</param-value>
        </init-param>
        <load-on-startup>1</load-on-startup>
    </servlet>
    <servlet>
     <servlet-name>LoadingApplication</servlet-name>
        <servlet-class>com.ihsc.struts.sc.util.LoadingApplication</servlet-class>
        <init-param>
    <param-name>ConfigFilePath</param-name>
     <param-value>workspace/IHSC/WEB-INF/src/com/ihsc/struts/</param-value>
     </init-param> 
    </servlet>
    <servlet-mapping>
        <servlet-name>action</servlet-name>
        <url-pattern>*.do</url-pattern>
    </servlet-mapping>
    <servlet-mapping>
         <servlet-name>LoadingApplication</servlet-name>
         <url-pattern>/login</url-pattern>
    </servlet-mapping>
    <resource-ref>
       <description>Oracle Datasource example</description>
        <res-ref-name>jdbc/OracleDB</res-ref-name>
        <res-type>javax.sql.DataSource</res-type>
        <res-auth>Container</res-auth>
    </resource-ref>    
</web-app>

Answer 3

TOxitianjile(空想社會主義)不是吧
用JDBC连接数据库用的也是这个驱动啊，那个就好用的

Answer 4

你试试把jndi名和上下文环境名直接写到
Context ctx = (Context) initCtx.lookup(sLookupName);
DataSource ds = (DataSource)ctx.lookup(sJndiName);
中sLookupName和sJndiName位置上再测一下，把测试结果贴出来

Answer 5

to maner626(水鬼)：
我试了，结果和我一开始贴的一模一样。