关于tomcat连接池的配置问题
我的环境是:
Tomcat/4.1.24
j2sdk1.4.2
window2000server
出现如下错误:
Name java:comp is not bound in this Context
jsp文件如下:
<%@ page contentType="text/html;charset=GBK"%>
<%@ page import= "javax.sql.*" %>
<%@ page import= "javax.naming.* "%>
<%@ page import= "java.sql.*" %>
<%
try{
Context initCtx = new InitialContext();
Context ctx = (Context) initCtx.lookup("java:comp/env");
Object obj = (Object) ctx.lookup("JDBC/mySqlSvr");
//Object obj = (Object) initCtx.lookup("java:comp/env/JDBC/mySqlSvr");
javax.sql.DataSource ds = (javax.sql.DataSource)obj;
Connection conn = ds.getConnection();
Statement stmt = conn.createStatement();
String strSql = "select * from BS_test";
ResultSet rs = stmt.executeQuery(strSql);
if(rs.next())
{
out.println(rs.getString(1));
out.println(rs.getString(2));
}
}catch(Exception e){
out.println(e.getMessage());
}
%>
<hr>
如我不用连接池就能访问成功。