tomcat与orcale的连接 池问题，

Question

关注与学习ing...如问题已解决,烦请楼主发个消息给我,我也学习一下.谢谢先!!!

Answer 1

下面是一个成功事例：
conf/server.xml的修改
<!-- Tomcat Root Context -->
        
          <Context path="" docBase="ROOT" debug="0">
                      
          <Resource name="jdbc/OracleDB" auth="Container"
                      
          type="javax.sql.DataSource"/> 
                             
          <ResourceParams name="jdbc/OracleDB">
                             
            <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:@your ip address:1521:oracle</value>
                             
            </parameter>
                             
            <parameter>
                                    
          <name>username</name>
                                    
          <value>oracle</value>
                             
            </parameter>
                             
            <parameter>
                                    
          <name>password</name>
                                    
          <value>oracle</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>
我改的是根目录。
测试页面：
<%@ page contentType="text/html;charset=GBK"%>
<%@ page import= "java.sql.* "%>
<%@ page import= "javax.naming.* "%>
<%
try{
          Context initCtx = new InitialContext();
          javax.sql.DataSource ds = (javax.sql.DataSource) initCtx.lookup("java:comp/env/jdbc/OracleDB");
          Connection conn = ds.getConnection();
          System.out.println("conn------"+conn);           
          Statement stmt = conn.createStatement();
          System.out.println("stmt------"+stmt);           
          String strSql = " select id,name from staff";
          ResultSet rs = stmt.executeQuery(strSql);
                    while(rs.next()){
          out.println(rs.getString(1));                 
          out.println(rs.getString(2));
          }
}catch(Exception ex){
                      
          ex.printStackTrace();
                throw new SQLException("cannot get Connection pool.");
               }
        %>
        <hr>

Answer 2

如果没有jdbc for sql server2000就会出现这个错误，你可以看看tomcat控制台，那里有具体的出错信息