tomcat5.0配置方法

tomcat5.0配置方法

1、首先在server.xml里面配置，找到下面的</Host> 在它的上面写上下面的内容

path 写的是 虚拟目录的名字

docBase写的是工程文件的名字及位置 若放在tomcat默认的目录下面就不用培植位置了

若放在其他地方可以配置此位置 例如:docBase="d:/byisdb"运行的工程就放在了d盘的byisdb里

<Context path="/byisdb" docBase="byisdb" debug="5" reloadable="true" crossContext="true">

2、在里面增加一个Resource

       <Resource name="jdbc/byisdb"

                auth="Container"

                type="javax.sql.DataSource"/>

 

3、在下面增加属性

 

   <ResourceParams name="jdbc/byisdb">

     <parameter>

       <name>factory</name>

       <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>

     </parameter>

     <!-- Maximum number of dB connections in pool. Make sure you

          configure your mysqld max_connections large enough to handle

          all of your db connections. Set to 0 for no limit.

          -->

     <parameter>

       <name>maxActive</name>

       <value>100</value>

     </parameter>

     <!-- Maximum number of idle dB connections to retain in pool.

          Set to -1 for no limit.   See also the DBCP documentation on this

          and the minEvictableIdleTimeMillis configuration parameter.

          -->

     <parameter>

       <name>maxIdle</name>

       <value>30</value>

     </parameter>

     <!-- Maximum time to wait for a dB connection to become available

          in ms, in this example 10 seconds. An Exception is thrown if

          this timeout is exceeded.   Set to -1 to wait indefinitely.

          -->

     <parameter>

       <name>maxWait</name>

       <value>10000</value>

     </parameter>

     <!-- MySQL dB username and password for dB connections   -->

     <parameter>

      <name>username</name>

      <value>una_oa</value>

     </parameter>

     <parameter>

      <name>password</name>

      <value>una_oa</value>

     </parameter>

     <!-- Class name for the old mm.mysql JDBC driver - uncomment this entry and comment next

          if you want to use this driver - we recommend using Connector/J though

     <parameter>

        <name>driverClassName</name>

        <value>org.gjt.mm.mysql.Driver</value>

     </parameter>

      -->

    

     <!-- Class name for the official MySQL Connector/J driver -->

     <parameter>

        <name>driverClassName</name>

        <value>oracle.jdbc.driver.OracleDriver</value>

     </parameter>

    

     <!-- The JDBC connection url for connecting to your MySQL dB.

          The autoReconnect=true argument to the url makes sure that the

          mm.mysql JDBC Driver will automatically reconnect if mysqld closed the

          connection.   mysqld by default closes idle connections after 8 hours.

          -->

     <parameter>

       <name>url</name>

       <value>jdbc:oracle:thin:@192.168.1.210:1521:byisdb</value>

     </parameter>

   </ResourceParams>

4、在你的应用的web.xml里面增加

<resource-ref>

<description>postgreSQL Datasource example</description>

<res-ref-name>jdbc/byisdb</res-ref-name>

<res-type>javax.sql.DataSource</res-type>

<res-auth>Container</res-auth>

</resource-ref>

</Context>

可以用下面的几段代码进行测试

Context initContext = new InitialContext();

Context envContext   = (Context)initContext.lookup("java:/comp/env");

DataSource ds = (DataSource)envContext.lookup("jdbc/byisdb");

Connection conn = ds.getConnection();

out.println("conn is:"+conn);