＋设为首页 ＋添加到收藏夹
我把这页放在struts-blank基础生成，按照原来tomcat的连接池配置方法。
运行时提示
Cannot load JDBC driver class com.microsoft.jdbc.sqlserver.SQLServerDriver
难道struts不能用tomcat的连接池？？请帮忙!
－－－－－－－－－
pool.jsp
<%@ page contentType="text/html; charset=GBK" %>
<%@ page import="javax.naming.Context" %>
<%@ page import="javax.sql.DataSource"%>
<%@ page import="javax.naming.InitialContext"%>
<%@ page import="java.sql.*"%>
<%
DataSource ds = null;
Connection conn = null;
try{
Context initCtx = new InitialContext();
Context envCtx = (Context) initCtx.lookup("java:comp/env");
ds = (DataSource)envCtx.lookup("jdbc/lybdb");
conn = ds.getConnection();
if(conn!=null)
out.println("Connection is OK!");
else
out.println("Connection Failed!");
}catch(Exception e){
out.println(e.getMessage());
}
%>
在struts-confi.xml中配置数据库连接和tomcat是不一样的,这边有个例子,可以参考一下:
配置:
<data-sources>
<data-source>
<set-property property="driverClass" value="com.inet.tds.TdsDriver" />
<set-property property="url" value="jdbc:inetdae:127.0.0.1:1433?charset=gb2312&database=pubs" />
<set-property property="maxCount" value="5" />
<set-property property="minCount" value="1" />
<set-property property="user" value="sa" />
<set-property property="password" value="" />
</data-source>
</data-sources>
代码:
ServletContext context = this.servlet.getServletContext();
DataSource ds = (DataSource) context.getAttribute(Globals.DATA_SOURCE_KEY);
Connection conn = ds.getConnection();
.........
顶！！！！！！！
up！！！！！！！！
up ! up ! up !
:)
