tomcat环境下javabean使用jndi问题

Question

web.xml:
<!DOCTYPE web-app PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.2//EN" "http://java.sun.com/j2ee/dtds/web-app_2.2.dtd">
<web-app>  <servlet>
    <servlet-name>OutNetPooler</servlet-name>
    <servlet-class>com.create.app.gzgpchange.OutNetPooler</servlet-class>
    <init-param>
      <param-name>step</param-name>
      <param-value>1</param-value>
    </init-param>
<init-param>
      <param-name>outnethomepage</param-name>
      <param-value>http://localhost</param-value>
    </init-param>
<init-param>
      <param-name>xml2db</param-name>
      <param-value>/data/xml2db.jsp</param-value>
    </init-param>
<init-param>
      <param-name>jndi</param-name>
      <param-value>java:comp/env/procDataSource</param-value>
    </init-param>
<load-on-startup>0</load-on-startup>
  </servlet>
  <servlet>
<servlet-name>OutQueryData</servlet-name>
<servlet-class>com.create.app.gzgpchange.OutQueryData</servlet-class>
  </servlet>
  <servlet-mapping>
    <servlet-name>OutQueryData</servlet-name>
    <url-pattern>/OutQueryData</url-pattern>
  </servlet-mapping>  <session-config>
    <session-timeout>-1</session-timeout>
  </session-config>  <mime-mapping>
    <extension>html</extension>
    <mime-type>text/html</mime-type>
  </mime-mapping>  <mime-mapping>
    <extension>doc</extension>
    <mime-type>application/msword</mime-type>
  </mime-mapping>  <mime-mapping>
    <extension>htm</extension>
    <mime-type>text/html</mime-type>
  </mime-mapping>  <mime-mapping>
    <extension>gif</extension>
    <mime-type>image/gif</mime-type>
  </mime-mapping>  <mime-mapping>
    <extension>jpeg</extension>
    <mime-type>image/jpeg</mime-type>
  </mime-mapping>  <mime-mapping>
    <extension>jpg</extension>
    <mime-type>image/jpeg</mime-type>
  </mime-mapping>  <mime-mapping>
    <extension>pdf</extension>
    <mime-type>application/pdf</mime-type>
  </mime-mapping>  <mime-mapping>
    <extension>zip</extension>
    <mime-type>application/zip</mime-type>
  </mime-mapping>  <mime-mapping>
    <extension>class</extension>
    <mime-type>application/x-java-vm</mime-type>
  </mime-mapping>  <mime-mapping>
    <extension>jar</extension>
    <mime-type>application/x-java-archive</mime-type>
  </mime-mapping>  <mime-mapping>
    <extension>ser</extension>
    <mime-type>application/x-java-serialized</mime-type>
  </mime-mapping>  <mime-mapping>
    <extension>exe</extension>
    <mime-type>application/octet-stream</mime-type>
  </mime-mapping>  <mime-mapping>
    <extension>hdml</extension>
    <mime-type>text/x-hdml</mime-type>
  </mime-mapping>  <mime-mapping>
    <extension>bmp</extension>
    <mime-type>image/bmp</mime-type>
  </mime-mapping>  <mime-mapping>
    <extension>wml</extension>
    <mime-type>text/vnd.wap.wml</mime-type>
  </mime-mapping>  <mime-mapping>
    <extension>wmls</extension>
    <mime-type>text/vnd.wap.wmlscript</mime-type>
  </mime-mapping>  <mime-mapping>
    <extension>wmlc</extension>
    <mime-type>application/vnd.wap.wmlc</mime-type>
  </mime-mapping>  <mime-mapping>
    <extension>wmlsc</extension>
    <mime-type>application/vnd.wap.wmlscript</mime-type>
  </mime-mapping>  <mime-mapping>
    <extension>wbmp</extension>
    <mime-type>image/vnd.wap.wbmp</mime-type>
  </mime-mapping>  <welcome-file-list>
    <welcome-file>index.html</welcome-file>
<welcome-file>index.htm</welcome-file>
    <welcome-file>index.jsp</welcome-file>
    <welcome-file>login.jsp</welcome-file>
  </welcome-file-list>
  <mime-mapping> 
<extension>htm</extension> 
<mime-type>text/html; charset=gb2312</mime-type>
</mime-mapping>
<mime-mapping>
<extension>html</extension>
<mime-type>text/html; charset=gb2312</mime-type>
</mime-mapping><resource-ref>
<description>DB Connection</description>
<res-ref-name>procDataSource</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
 </resource-ref>
</web-app>

Answer 1

conf/server.xml:
  <Listener className="org.apache.catalina.mbeans.ServerLifecycleListener"
            debug="0"/>
  <Listener className="org.apache.catalina.mbeans.GlobalResourcesLifecycleListener"
            debug="0"/>  <!-- Global JNDI resources -->
  <GlobalNamingResources>    <!-- Test entry for demonstration purposes -->
    <Environment name="simpleValue" type="java.lang.Integer" value="30"/>    <!-- Editable user database that can also be used by
         UserDatabaseRealm to authenticate users -->
    <Resource name="UserDatabase" auth="Container"
              type="org.apache.catalina.UserDatabase"
       description="User database that can be updated and saved">
    </Resource>
    <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>  </GlobalNamingResources>    <!-- Define the Tomcat Stand-Alone Service -->
  <Service name="Catalina">
        <Connector 
port="8080"               maxThreads="150" minSpareThreads="25" maxSpareThreads="75"
               enableLookups="false" redirectPort="8443" acceptCount="100"
               debug="0" connectionTimeout="20000" 
               disableUploadTimeout="true" />
    <!-- Note : To disable connection timeouts, set connectionTimeout value
     to -1 -->
    <!-- Define a SSL Coyote HTTP/1.1 Connector on port 8443 -->
    
    <!-- Define a Coyote/JK2 AJP 1.3 Connector on port 8009 -->
    <Connector port="8009" 
               enableLookups="false" redirectPort="8443" debug="0"
               protocol="AJP/1.3" />    
            
   
           <Logger className="org.apache.catalina.logger.FileLogger"
              prefix="catalina_log." suffix=".txt"
              timestamp="true"/>      <!-- Because this Realm is here, an instance will be shared globally -->           <Realm className="org.apache.catalina.realm.UserDatabaseRealm"
                 debug="0" resourceName="UserDatabase"/>      <!-- Comment out the old realm but leave here for now in case we
           need to go back quickly -->
      <!--
      <Realm className="org.apache.catalina.realm.MemoryRealm" />
      -->          <Host name="localhost" debug="0" appBase="webapps"
       unpackWARs="true" autoDeploy="true"
       xmlValidation="false" xmlNamespaceAware="false">        
        
                <Logger className="org.apache.catalina.logger.FileLogger"
                 directory="logs"  prefix="localhost_log." suffix=".txt"
            timestamp="true"/>                <!-- Tomcat Root Context -->
        <!--
          <Context path="" docBase="ROOT" debug="0">
        -->
<Context path="" docBase="/gzgp" debug="0" reloadable="true">
<Resource name="procDataSource" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="procDataSource">
<parameter>
<name>factory</name> 
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>driverClassName</name> 
<value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:microsoft:sqlserver://localhost:1433;databaseName=procurement</value>
</parameter>
<parameter>
<name>username</name>
<value>sa</value>
</parameter>
<parameter>
<name>password</name>
<value>1234</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>1000</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>20</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>-1</value>
</parameter>
</ResourceParams>
</Context>      </Host>    </Engine>  </Service></Server>

Answer 2

<resource-ref>
<description>DB Connection</description>
<res-ref-name>procDataSource</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
这段是写在你的应用程序里的web.xml里不是tomcat/conf里的那个。