我的tomcat连接池配制总是不成功

Question

你的代码写得不完全，必要的封闭没有完成。get Connection pool.");重点检查。

Answer 1

                throw new SQLException("cannot 
          get Connection pool.");
写到一行中   throw new SQLException("cannot get Connection pool.");

Answer 2

.....................测试代码已改好了,现在显示另外的错误信息.....................org.apache.jasper.JasperException: cannot get Connection pool.
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:254)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain
...........................................................................
<%@ page contentType="text/html;charset=GBK"%>
        <%@ page import= "java.sql.* "%>
        <%@ page import= "javax.naming.* "%>
        <%
               try{
                      
          Context initCtx = new InitialContext();
                      
          Context ctx = (Context) initCtx.lookup("java:comp/env");
                //获取连接池对象
                      
          Object obj = (Object) ctx.lookup("jdbc/SqlServerDB");    
        
                //类型转换
                      
          javax.sql.DataSource ds = (javax.sql.DataSource)obj;
                      
          Connection conn = ds.getConnection();
                      
          Statement stmt = conn.createStatement();
                      
        String strSql = "insert into test(id,name) values('00001','holen')";
                      
         stmt.executeUpdate(strSql);
                      
         strSql = " select * from test ";
                      
          ResultSet rs = stmt.executeQuery(strSql);
                    if(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>