Tomcat5.0数据源的配置

第一：如果应用没有发布到tomcat的webapps目录下，可以先在conf的server.xml下注册全局的数据源

<?xml version='1.0' encoding='utf-8'?>
<Server>
  <Listener className="org.apache.catalina.mbeans.ServerLifecycleListener"/>
  <Listener className="org.apache.catalina.mbeans.GlobalResourcesLifecycleListener"/>
  <GlobalNamingResources>
    <Environment name="simpleValue" type="java.lang.Integer" value="30"/>
    <Resource auth="Container" description="User database that can be updated and saved" name="UserDatabase" type="org.apache.catalina.UserDatabase"/>
    <Resource name="DJPTDataSource"  type="javax.sql.DataSource"/>

    <ResourceParams name="UserDatabase">
      <parameter>
       <name>factory</name>
       <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
      </parameter>
      <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="DJPTDataSource">
  <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:oracle</value>
  </parameter>
  <parameter>
   <name>username</name>
   <value>djpt</value>
  </parameter>
  <parameter>
   <name>password</name>
   <value>djpt</value>
  </parameter>
  <parameter>
   <name>maxActive</name>
   <value>20</value>
  </parameter>
  <parameter>
   <name>maxIdle</name>
   <value>10</value>
  </parameter>
  <parameter>
   <name>maxWait</name>
   <value>10000</value>
  </parameter>
 </ResourceParams>

   </GlobalNamingResources>
  <Service name="Catalina">
    <Connector acceptCount="100" connectionTimeout="20000" disableUploadTimeout="true" port="8800" redirectPort="8443" maxSpareThreads="75" maxThreads="150" minSpareThreads="25">
    </Connector>
    <Connector port="8009" protocol="AJP/1.3" protocolHandlerClassName="org.apache.jk.server.JkCoyoteHandler" redirectPort="8443">
    </Connector>
    <Engine defaultHost="localhost" name="Catalina">
      <Host appBase="webapps" name="localhost">
        <Logger className="org.apache.catalina.logger.FileLogger" prefix="localhost_log." suffix=".txt" timestamp="true"/>
      </Host>
      <Logger className="org.apache.catalina.logger.FileLogger" prefix="catalina_log." suffix=".txt" timestamp="true"/>
      <Realm className="org.apache.catalina.realm.UserDatabaseRealm"/>
    </Engine>
  </Service>
</Server>
然后在conf/Catalina/localhost下建立与应用同名的.xml文件进行数据源的引用

内容如下：

 

<?xml version='1.0' encoding='utf-8'?>
<Context displayName="DJPT" docBase="E:/mye6.0_workbench/DJPT/WebRoot" path="/DJPT" privileged="true" reloadable="true" workDir="work/Catalina/localhost/DADJPT">
  <ResourceLink global="DJPTDataSource" name="DJPTDataSource" type="javax.sql.DataSource"/>
</Context>

 

 

第二:如果采用发布形式，则在conf目录下的context.xml文件里

 

 <?xml version='1.0' encoding='utf-8'?>
<Context>
   <WatchedResource>WEB-INF/web.xml</WatchedResource>

   <Resource name="DJPTDataSource"
      auth="Container"
      type="javax.sql.DataSource"
      driverClassName="oracle.jdbc.driver.OracleDriver"
      url="jdbc:oracle:thin:@127.0.0.1:1521:ORCL"
      username="djpt"
      password="djpt"
      maxActive="50"
      maxIdle="10"
      maxWait="5000" />

</Context>