Oracle数据库连接池问题在tomcat下的配置

  1.tomcat配置

       <Context path="/manager" docBase="../server/webapps/manager"
            debug="0" privileged="true"></Context>

       <Context path="" docBase="f:/test" debug="0" reloadable="true">
       <Resource name="test" auth="Container"  type="javax.sql.DataSource"/>
         <ResourceParams name="test">
          <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:@192.168.0.1:shark</value>
          </parameter>
           <parameter>
            <name>username</name>
             <value>aqgl</value>
             </parameter>
          <parameter>
              <name>password</name>
              <value>welcome</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>        
        
       </Context>
       <Logger className="org.apache.catalina.logger.FileLogger"
               directory="logs"  prefix="ystatistics_log." suffix=".txt"
               timestamp="true"/>
2.连接池类

 

package com;

import java.sql.Connection;

import javax.naming.InitialContext;
import javax.sql.DataSource;

public class GetCon {

 public Connection getCon() throws Exception {
  InitialContext initialcontext = new InitialContext();
  DataSource datasource = (DataSource) initialcontext
    .lookup("java:comp/env/assistpro");
  Connection connection = (Connection) datasource.getConnection();

  return connection;
 }

}

3.测试jsp

 

<%@ page import="javax.naming.Context" %>
<%@ page import="javax.sql.DataSource"%>
<%@ page import="javax.naming.InitialContext"%>
<%@ page import="java.sql.*"%>
<%@ page import="com.GetCon"%>

test start<br>
<%
GetCon getcon = new GetCon();
Connection conn = getcon.getCon();
   if(conn!=null){
   out.print("Connection OK!");
   }
   Statement stmt = conn.createStatement();
   ResultSet rs = stmt.executeQuery("select * from task");
   while(rs.next()){
   out.print(rs.getString(1));
   out.print("<br>");
   
   }
   
   
   
%>