是呀,现在关键是我放了之后,用eclipse建了个jsp文件进行测试后,出现type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception javax.servlet.ServletException: com.microsoft.jdbc.sqlserver.SQLServerDriver org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:845) org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:778) org.apache.jsp.test01_jsp._jspService(org.apache.jsp.test01_jsp:111) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:99) javax.servlet.http.HttpServlet.service(HttpServlet.java:802) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:325) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:245) 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:1332) org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1181) org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:148) org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:69) java.lang.ClassLoader.loadClassInternal(Unknown Source) java.lang.Class.forName0(Native Method) java.lang.Class.forName(Unknown Source) org.apache.jsp.test01_jsp._jspService(org.apache.jsp.test01_jsp:65) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:99) javax.servlet.http.HttpServlet.service(HttpServlet.java:802) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:325) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:245) javax.servlet.http.HttpServlet.service(HttpServlet.java:802) note The full stack trace of the root cause is available in the Apache Tomcat/5.5.4 logs. 这种错误呀?郁闷!不知错在哪里???
net.sourceforge.jtds.jdbc.Driver
url
jdbc:jtds:sqlserver://【server】/【db】
应该不难,楼主应该自己动手经过多次尝试才会学得扎实啊
配置呀,把驱动的包写入classapath
然后写一个测试的程序
Connection con = null;
try {
Class.forName(dbDriver).newInstance();
con = DriverManager.getConnection(URL, user, passwd);
return con
}
catch (Exception e) {
e.printStackTrace(System.out);
return null;
}
}
其中:
dbDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
URL = "jdbc:microsoft:sqlserver://ip:1433;DatabaseName=db_name";
2.安装
3.拷贝3个jar文件到tomcat的lib里另,用jb时建一个配置文件
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:845)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:778)
org.apache.jsp.test01_jsp._jspService(org.apache.jsp.test01_jsp:111)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:99)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:325)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:245)
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:1332)
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1181)
org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:148)
org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:69)
java.lang.ClassLoader.loadClassInternal(Unknown Source)
java.lang.Class.forName0(Native Method)
java.lang.Class.forName(Unknown Source)
org.apache.jsp.test01_jsp._jspService(org.apache.jsp.test01_jsp:65)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:99)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:325)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:245)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
note The full stack trace of the root cause is available in the Apache Tomcat/5.5.4 logs.
这种错误呀?郁闷!不知错在哪里???
或者你就在classpath里面设置也可以
参考http://tech.ccidnet.com/pub/article/c1110_a173155_p1.html
http://search.csdn.net/Expert/topic/2107/2107299.xml?temp=.6797449
http://search.csdn.net/Expert/topic/872/872123.xml?temp=.2768061