如何在Tomcat4中建立Oracle9i的DataSource？

Question

Oracle数据库驱动包是：classes11.jar/classes12.jartomcat连接池配置
Tomcat文档说明 http://jakarta.apache.org/tomcat/tomcat-5.0-doc/jndi-datasource-examples-howto.html
Tomcat4的数据库连接池配置 http://www.7880.com/Info/Article-37ebcbc0-2.html
tomcat连接池的配置与使用（原创）数据库mysql  http://www.7880.com/Info/Article-37f05fa0.html

Answer 1

server.xml:
      <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"/>        <Context path="/rootDir" docBase="rootDir" debug="0"                 reloadable="true" crossContext="true">    <Resource name="jdbc/oradb1" auth="Container" type="javax.sql.DataSource"/>   
      <ResourceParams name="jdbc/oradb1">
         <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:oradb</value>              
           </parameter>
           <parameter>     
             <name>username</name>
              <value>users</value>   
             </parameter>
           <parameter>     <name>password</name>     <value>12345678</value>
           </parameter>
           <parameter>     <name>maxActive</name>     <value>50</value>   
           </parameter>
           <parameter>
              <name>maxIdle</name>     <value>10</value>   
           </parameter>   
           <parameter>
                <name>maxWait</name>     <value>10000</value>   
              </parameter>
              <parameter>
                <name>removeAbandoned</name>
                <value>true</value>
              </parameter>
              <parameter>
                <name>removeAbandonedTimeout</name>
                <value>60</value>
              </parameter>

            </ResourceParams>     
         </Context>
        
      </Host>
------------------------------------------------------------------------------------
web.xml:
      <resource-ref id="ResourceRef_1098605490000">
         <res-ref-name>jdbc/oradb1</res-ref-name>
         <res-type>java.lang.Object</res-type>
         <res-auth>Application</res-auth>
         <res-sharing-scope>Shareable</res-sharing-scope>
      </resource-ref>

Answer 2

在TOMCAT的wabapps\tomcat-docs下面有文档说明的。

Answer 3

"请教怎么才能在Tomcat中建立向WebLogic中的数据源"?是不是指在Tomcat下通过代码取得weblobic的数据源？如果是这样，那就平常调用weblogic的数据源没有什么差别，方式和代码一样。

Answer 4

server.xml:
      <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"/>        <Context path="/rootDir" docBase="rootDir" debug="0"                 reloadable="true" crossContext="true">    <Resource name="jdbc/oradb1" auth="Container" type="javax.sql.DataSource"/>   
      <ResourceParams name="jdbc/oradb1">
         <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:oradb</value>  </parameter>
 <parameter><name>username</name>  <value>users</value>  </parameter>
<parameter> <name>password</name>  <value>12345678</value>  </parameter>
<parameter> <name>maxActive</name>     <value>50</value>  </parameter>
 <parameter> <name>maxIdle</name>    <value>10</value>  </parameter>
 <parameter> <name>maxWait</name>    <value>10000</value>   </parameter>
 <parameter><name>removeAbandoned</name>   <value>true</value> </parameter>
<parameter> <name>removeAbandonedTimeout</name> <value>60</value>  </parameter>
            </ResourceParams>     
         </Context>        
      </Host>
----------------
web.xml:
      <resource-ref id="ResourceRef_1098605490000">
         <res-ref-name>jdbc/oradb1</res-ref-name>
         <res-type>java.lang.Object</res-type>
         <res-auth>Application</res-auth>
         <res-sharing-scope>Shareable</res-sharing-scope>
      </resource-ref>