Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver") 出錯

[DengXingJie]

Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver")
在JSP下報 錯，但在Java中卻能正常運行

具體代碼：
JSP代碼： 就這三行
<%
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
%>

Java代碼

import java.sql.*; 

public class TestDB { 
	public static void main(String[] args) { 
		String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver"; 
		String dbURL = "jdbc:microsoft:sqlserver://192.168.1.1:1433;DatabaseName=TEST"; 
		String userName = "sa"; 
		String userPwd = "123456"; 
		Connection dbConn ;
	 	Statement sm=null;
		ResultSet rs=null; 
		String sql=null;
		try { 
			Class.forName(driverName); 
			dbConn = DriverManager.getConnection(dbURL, userName, userPwd); 
			sm=dbConn.createStatement();
			sql="select * from User_Info where UserID='07077' and opening='1'";   
			rs=sm.executeQuery(sql);
			if(rs.next()){
				System.out.println(rs.getString("UserName"));
			}
					
			System.out.println("Jesse:Connection Successful!"); 
		} 
		catch (Exception e) { 
			e.printStackTrace(); 
		} 
	} 
} 

Java模式下能正常運行，應該可以說明JDBC是已經正確安裝，SQL Server也符合要求，但在JSP下卻總是報錯，

錯誤如(見回復)

[DengXingJie]

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException: An exception occurred processing JSP page /Test02.jsp at line 2

1: <%
2: Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
3: %>


Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:505)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:398)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:337)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)


root cause

javax.servlet.ServletException: java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:850)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:779)
org.apache.jsp.Test02_jsp._jspService(Test02_jsp.java:61)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:337)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)


root cause

java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1360)
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1206)
org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:128)
org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:66)
java.lang.ClassLoader.loadClassInternal(Unknown Source)
java.lang.Class.forName0(Native Method)
java.lang.Class.forName(Unknown Source)
org.apache.jsp.Test02_jsp._jspService(Test02_jsp.java:54)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:337)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)


note The full stack trace of the root cause is available in the Apache Tomcat/6.0.16 logs.

[wine1]

应该是没引入包吧

[DengXingJie]

Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
沒有引用到其它的包吧

[lijiecsu]

SQLServer连接数据库的包导进来了吗？

[xuexijava]

把包复制到Ｌｉｂ目录下

[closewbq]

在JSP中引入com.microsoft.jdbc.sqlserver.SQLServerDriver包

[andytom]

[Quote=引用 5 楼 xuexijava 的回复:]
把包复制到Ｌｉｂ目录下
[/Quote]
应该是这个原因

[ouyangyh]

没有捕捉异常吧
你用try catch块包起来就可以了

[钱不是问题]

同上

[MJunnnn]

[size=13px]Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();[/size]
语句没写完整啊！

[MJunnnn]

Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();

[DengXingJie]

问题得到解决：
msbase.jar
mssqlserver.jar
msutil.jar
把上面这三个文件COPY到Tomcat 6.0\lib\下即可
谢谢各位!

[DengXingJie]

还有一点得重启Tomcat服务

[dikenalhl]

我的放在哪个目录下了，怎么还不行呀