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.以上都是失败。下面是具体错误，江湖救济。那位大佬请指教下我。[font=Tahoma, Arial, sans-serif][size=12px][b]type[/b] Exception report[/size][/font]
[font=Tahoma, Arial, sans-serif][size=12px][b]message[/b][/size][/font]
[font=Tahoma, Arial, sans-serif][size=12px][b]description[/b] [u]The server encountered an internal error () that prevented it from fulfilling this request.[/u][/size][/font]
[font=Tahoma, Arial, sans-serif][size=12px][b]exception[/b][/size][/font]
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)
[font=Tahoma, Arial, sans-serif][size=12px][b]root cause[/b][/size][/font]
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)
[font=Tahoma, Arial, sans-serif][size=12px][b]root cause[/b][/size][/font]
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.<init>(DocumentNavigator.java:895) org.jaxen.dom.DocumentNavigator$1.<init>(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) 管理员在吗。帮忙看下好不 将 sql server的驱动包，放到ｔｏｍｃａｔ的ｌｉｂ目录 下，试试
页:
[1]