我也是这种问题,我甚至重新安装MSSQL SP3/JDK/TOMCAT/MS SQL JDBC问题依旧
错误提示
exception
javax.servlet.ServletException: com.microsoft.jdbc.sqlserver.SQLServerDrver
……root cause
java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDrver有大虾给点建议么??这可是我的终身大事啊(毕业论文)!
错误提示
exception
javax.servlet.ServletException: com.microsoft.jdbc.sqlserver.SQLServerDrver
……root cause
java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDrver有大虾给点建议么??这可是我的终身大事啊(毕业论文)!
都放了的
若xp打了patch 则sqlserver必须打patch3,否则sqlserver不用打patch3
另外,那三个jar文件要从你的sqlserver2000 jdbc目录下考到%tomcat%/webapps/你的站点/WEb-INF/lib下并且要设置系统环境变量的classpath(将这三个文件的路径和文件名加进去)
Connection con=java.sql.DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=bankdb2","sa","");
改为:
Connection con=java.sql.DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=bankdb2; ","sa","");
我不知道是不是这地方一定要加分号的(在DatebaseName=bankdb2后)
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)
org.apache.jsp.query_jsp._jspService(query_jsp.java:76)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1340)
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1189)
org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:148)
org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:69)
java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302)
java.lang.Class.forName0(Native Method)
java.lang.Class.forName(Class.java:141)
org.apache.jsp.query_jsp._jspService(query_jsp.java:46)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
note The full stack trace of the root cause is available in the Apache Tomcat/5.0.28 logs.
java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
可是依然没解决问题.急啊!!!
提示是找不到驱动类
你要把jar文件放到正确的位置
放到你的webapp/WEB-INF/lib下面
或者tomcat的/common/lib/下也许是和补丁有关,我一直用的Mysql
Connection con=java.sql.DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=bankdb2;method=cursor","sa","");
mssqlserver要打上sp3