tomcat连接池得到的连接在jsp中测试成功，在java main方法中测试conn为null

Question

直接上代码

//测试类
 public class Draft {
    public static void main(String args[]){
        Connection conn=Fconn.getPoolConn();
        System.out.println(conn.toString());
    }
}

 //jsp测试页
 <%
    Connection conn=Fconn.getPoolConn();
    out.println(conn.toString());
  %>

//从池中获取连接功能类，测试程序中我用下面的工厂获得连接
 public class GetConnectionFromPool {
    private Connection conn=null;
    public Connection getMySQLConnection(){
        try{
            String datasourcename="java:comp/env/jdbc/HanLinMysql";
            Context cont=new InitialContext();
            DataSource datasource=(DataSource)cont.lookup(datasourcename);
            this.conn=datasource.getConnection();
        }catch(Exception e){
            //this.conn=null;
        }


        return this.conn;
    }
    public Connection getSQLServerConnection(){
        try{
            String datasourcename="java:comp/env/jdbc/HanLinSQLServer/hanlinsale";
            Context cont=new InitialContext();
            DataSource datasource=(DataSource)cont.lookup(datasourcename);
            this.conn=datasource.getConnection();
        }catch(Exception e){
            //this.conn=null;
        }

        return this.conn;
    }

}

 //连接工厂
 public class Fconn {
    public static Connection getPoolConn(){
        Connection conn=null;
        GetConnectionFromPool pool=new GetConnectionFromPool();
        conn=pool.getSQLServerConnection();
        return conn;
    }
}

Answer 1

环境问题？你再试试从新配置环境变量