报表配置数据源后访问服务器报错
产生数据工厂: com.raqsoft.report.dataset.SQLDataSetFactory 失败 (数据集名称):ds1 错误来源:com.gbasedbt.jdbc.Driver
com.raqsoft.report.usermodel.Engine.calcDataSet(Engine.java:177)
com.raqsoft.report.usermodel.Engine.calcDataSet(Engine.java:143)
com.raqsoft.report.usermodel.Engine.calc(Engine.java:94)
com.raqsoft.report.cache.LocalReportCache.getReport(LocalReportCache.java:137)
com.raqsoft.report.cache.ReportCache.getReport(ReportCache.java:177)
com.raqsoft.report.tag.HtmlTag.generateHtmlString(HtmlTag.java:1483)
com.raqsoft.report.tag.HtmlTag.doStartTag(HtmlTag.java:258)
org.apache.jsp.reportJsp.showReport_jsp._jspService(showReport_jsp.java:318)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:750)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:466)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:379)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:327)
javax.servlet.http.HttpServlet.service(HttpServlet.java:750)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:228)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:163)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:190)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:163)
org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:190)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:163)
org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:190)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:163)
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:190)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:163)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:687)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357)
org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:382)
org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:893)
org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1723)
org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
java.lang.Thread.run(Thread.java:748)
这个问题要怎么解决呢,raqsoftConfig.xml 文件也配置好了,本地润乾可以打开报表,放到服务器上就报这个错
改了数据源之后不报错了,但是一直显示在加载报表,报表展示不出来,这是什么情况呢
主贴中的错误是少驱动 jar 包,把 jdbc 驱动 jar 放到 lib 下重启下。新的错误访问一直卡在那个页面,看看后台日志,日志里会有开始取数,开始运算等信息,看看卡在哪了。另外这个表是不是取数比较多或者计算比较复杂,增加下条件减少下数据量看看。也看下是否有错误信息。
本地运行能正常打卡,服务器上就卡在连接数据库开始取数据,但是这是一个空表,不应该这样啊
确定下本地和服务器连的是否是同一个数据库,检查下数据源设置里的数据源连接,包括 ip,数据库名,用户名等。
如果确定是同一个库,那可以更换下数据库连接方式,现在用的是 jdbc 直连方式?也就是将数据库配置都写在了 raqsoftConfig.xml 里的 jdbclist 那。可以换用 jndi 方式试下,将连接写在 web 服务器的 jndi 那,然后配置文件里只引用那个名,一起倒是遇到或 jdbc 直连开始会卡一会的情况,不过这种情况比较少,可以换用试下。