jor简表toncat访问500
						
						
																											sql设计工具设计报表正常,显示也是正常。刚下载的时候是无法连接数据库的。因为我的数据库是sql2008.所以自己下载了驱动导入了designer/lib/目录。而后设计好报表,通过tomcat启动再去访问的时候就报找不到类。
java.lang.NoClassDefFoundError: com/microsoft/jdbc/base/BaseDriver后面尝试了好几种方式均失败。一:tomcat项目web-inf目录添加jar包:sqljdbc二:tomcat项目web-inf目录添加jar包:sqljdbc4三:以上添加的jar只保留一种。四:删除原本的jar:jsqlparser五:原本我的jdk是1.8.后更换为1.6.以上都是失败。下面是具体错误,江湖救济。那位大佬请指教下我。type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: com/microsoft/jdbc/base/BaseDriver	org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:460)	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:355)	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)	javax.servlet.http.HttpServlet.service(HttpServlet.java:729)	org.apache.jsp.tools.reportviewer_jsp._jspService(reportviewer_jsp.java:52)	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)	javax.servlet.http.HttpServlet.service(HttpServlet.java:729)	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)	javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
root cause
javax.servlet.ServletException: com/microsoft/jdbc/base/BaseDriver	org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:841)	org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:774)	org.apache.jsp.tools.defaultviewer_jsp._jspService(defaultviewer_jsp.java:255)	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)	javax.servlet.http.HttpServlet.service(HttpServlet.java:729)	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)	javax.servlet.http.HttpServlet.service(HttpServlet.java:729)	org.apache.jsp.tools.reportviewer_jsp._jspService(reportviewer_jsp.java:52)	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)	javax.servlet.http.HttpServlet.service(HttpServlet.java:729)	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)	javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
root cause
java.lang.NoClassDefFoundError: com/microsoft/jdbc/base/BaseDriver	java.lang.ClassLoader.defineClass1(Native Method)	java.lang.ClassLoader.defineClassCond(ClassLoader.java:631)	java.lang.ClassLoader.defineClass(ClassLoader.java:615)	java.security.SecureClassLoader.defineClass(SecureClassLoader.java:141)	org.apache.catalina.loader.WebappClassLoader.findClassInternal(WebappClassLoader.java:1876)	org.apache.catalina.loader.WebappClassLoader.findClass(WebappClassLoader.java:889)	org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1353)	org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1232)	java.lang.Class.forName0(Native Method)	java.lang.Class.forName(Class.java:171)	jatools.data.reader.sql.ConnectionPools.getConnection(ConnectionPools.java:65)	jatools.data.reader.sql.Connection.getConnection(Connection.java:211)	jatools.data.reader.sql.SqlReader.getConnection2(SqlReader.java:338)	jatools.data.reader.sql.SqlReader.readStart(SqlReader.java:217)	jatools.data.reader.sql.SqlReader.getDataset(SqlReader.java:490)	jatools.data.reader.sql.SqlReader.doRead(SqlReader.java:481)	jatools.data.reader.AbstractDatasetReader.read(AbstractDatasetReader.java:88)	jatools.dom.src.DatasetNodeSource.create(DatasetNodeSource.java:130)	jatools.dom.NodeFactory.createChildNodes(NodeFactory.java:45)	jatools.dom.ElementBase.getChildElements(ElementBase.java:500)	jatools.dom.DatasetBasedNode.getLength(DatasetBasedNode.java:396)	jatools.dom.DatasetBasedNode.getFirstChild(DatasetBasedNode.java:239)	org.jaxen.dom.DocumentNavigator$1.getFirstNode(DocumentNavigator.java:155)	org.jaxen.dom.DocumentNavigator$NodeIterator.(DocumentNavigator.java:895)	org.jaxen.dom.DocumentNavigator$1.(DocumentNavigator.java:152)	org.jaxen.dom.DocumentNavigator.getChildAxisIterator(DocumentNavigator.java:152)	org.jaxen.expr.iter.IterableChildAxis.iterator(IterableChildAxis.java:76)	org.jaxen.expr.DefaultNameStep.evaluate(DefaultNameStep.java:199)	org.jaxen.expr.DefaultLocationPath.evaluate(DefaultLocationPath.java:140)	org.jaxen.expr.DefaultXPathExpr.asList(DefaultXPathExpr.java:102)	org.jaxen.BaseXPath.selectNodesForContext(BaseXPath.java:674)	org.jaxen.BaseXPath.selectNodes(BaseXPath.java:213)	jatools.engine.printer.AbstractPrinter.createCursor(AbstractPrinter.java:250)	jatools.engine.printer.AbstractContainerPrinter.print(AbstractContainerPrinter.java:217)	jatools.engine.printer.table.TablePrinter.print(TablePrinter.java:67)	jatools.engine.printer.AbstractContainerPrinter.printChildren(AbstractContainerPrinter.java:150)	jatools.engine.printer.AbstractContainerPrinter.next(AbstractContainerPrinter.java:298)	jatools.engine.printer.AbstractContainerPrinter.print(AbstractContainerPrinter.java:233)	jatools.engine.printer.AbstractContainerPrinter.printChildren(AbstractContainerPrinter.java:150)	jatools.engine.printer.AbstractContainerPrinter.next(AbstractContainerPrinter.java:298)	jatools.engine.printer.AbstractContainerPrinter.print(AbstractContainerPrinter.java:233)	jatools.engine.printer.ReportPrinter.print(ReportPrinter.java:271)	jatools.engine._Job.generatePage(_Job.java:150)	jatools.engine._Job.printAsDHTML2(_Job.java:123)	jatools.engine.ReportJob.printAsDHTML(ReportJob.java:137)	jatools.tags.ReportTag.writeOut(ReportTag.java:156)	jatools.tags.ContainerTag.writeOut(ContainerTag.java:78)	org.apache.jsp.tools.defaultviewer_jsp._jspService(defaultviewer_jsp.java:227)	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)	javax.servlet.http.HttpServlet.service(HttpServlet.java:729)	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)	javax.servlet.http.HttpServlet.service(HttpServlet.java:729)	org.apache.jsp.tools.reportviewer_jsp._jspService(reportviewer_jsp.java:52)	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)	javax.servlet.http.HttpServlet.service(HttpServlet.java:729)	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)	javax.servlet.http.HttpServlet.service(HttpServlet.java:729)