我的连接池问题,好几天了,帮忙啊
我参考http://expert.csdn.net/Expert/topic/2325/2325295.xml?temp=.4057428 的帖,server.xml已经配置好了 jsp代码如下:
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(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
String strSql = " select * from film ";
ResultSet rs = stmt.executeQuery(strSql);
if(rs.next()){
out.println(rs.getString(1));
out.println(rs.getString(2));
}
}catch(Exception ex){
out.println(ex.getMessage());
}
错误如下:
Cannot load JDBC driver class 'com.microsoft.jdbc.sqlserver.SQLServerDrive' 为什么不能Load?