[i@Report5.1] jdbc取数报错

3636
9

liujiao 初学数据Lv2

发表于2020-11-9 16:20

悬赏1

已解决

楼主
企业版 V5.2.1R26-build20170615153234-r8bb93bb的I@report  在 jdbc取数测试时报错,错误详情如下:
com.esen.jdbc.dialect.Dialect.getLimitString(Ljava/lang/String;JI)Ljava/lang/String;
客户端环境:(Other) Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like Gecko
客户端地址:http://172.16.16.153:8085/irpt/e ... amp;sql=select%2520(TOT_DSBR_AMT%252BTOT_DSBR_AMT_CAR)%2520ljtf%252C(TOT_DSBR_INTR_INCM%252BTOT_DSBR_INTR_INCM_CAR)%2520tflx%252C((NEW_NPL_BAL%252BNEW_NPL_BAL_CAR)%252F(TOT_DSBR_AMT%252BTOT_DSBR_AMT_CAR)*100)%2520bldkl%252C((NEW_ODUEL_BAL%252BNEW_ODUEL_BAL_CAR)%252F(TOT_DSBR_AMT%252BTOT_DSBR_AMT_CAR)*100)%2520yql%2520from%2520f_jx_gener_mana_dept%2520where%2520bbq%253D'202009'&ds=sc_dm
服务器版本:V5.2.1R26-build20170615153234-r8bb93bb
java.lang.NoSuchMethodError: com.esen.jdbc.dialect.Dialect.getLimitString(Ljava/lang/String;JI)Ljava/lang/String;
at com.esen.i.action.qs.ActionQsManager.showJDBCTestResults(ActionQsManager.java:331)
at com.esen.i.action.qs.ActionQsManager.execute(ActionQsManager.java:164)
at com.esen.weblib.action.Action.handle(Action.java:66)
at sun.reflect.GeneratedMethodAccessor63.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:219)
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:745)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:686)
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:925)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:856)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:936)
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:827)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:812)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
at com.esen.platform.web.ReleasabledServlet.service(ReleasabledServlet.java:93)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.esen.platform.action.FilterLoginCheck.doFilter(FilterLoginCheck.java:95)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.esen.platform.web.PlatformLocaleContextFilter.doFilter(PlatformLocaleContextFilter.java:47)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.esen.i.action.EsmainActionFilter.doFilter(EsmainActionFilter.java:42)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.esen.platform.sso.SSODelegatingFilter.doFilter(SSODelegatingFilter.java:43)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.esen.ecascore.AbstractCasFilter.doFilter(AbstractCasFilter.java:46)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.esen.ecascore.AbstractCasFilter.doFilter(AbstractCasFilter.java:46)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.esen.ecascore.AbstractCasFilter.doFilter(AbstractCasFilter.java:46)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:492)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:165)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:1025)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:452)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1201)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:654)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:317)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)

最近看过此主题的会员

esen_51WR5SHNFH

lizf

esen_4XW9QT2XNS

Linforever

zhouxm

伶俐

chestnut

bbs

fenglan

L7Aura

xxxl

最佳答案

xxxl

发表于2020-11-9 16:20

只看该作者

取消 关注该作者的回复

liujiao 发表于 2020-11-9 17:27
试了呢   在数据库管理中没问题

刚才和研发确认了 应该是bug,可能是包里缺少缺少getLimitString方法方法导致的,我站内私信您了
9个回答

只看楼主

xxxl 数据领袖Lv6

发表于2020-11-9 16:27

只看该作者

取消 关注该作者的回复

沙发

您jdbc取数怎么设置的 可以看一下吗

liujiao 初学数据Lv2

发表于2020-11-9 16:32

只看该作者

取消 关注该作者的回复

板凳

本帖最后由 liujiao 于 2020-11-9 16:37 编辑

xxxl 发表于 2020-11-9 16:27
您jdbc取数怎么设置的 可以看一下吗
这样设置的,在数据库管理里面执行正常

liujiao 初学数据Lv2

发表于2020-11-9 16:34

只看该作者

取消 关注该作者的回复

地板

xxxl 发表于 2020-11-9 16:27
您jdbc取数怎么设置的 可以看一下吗


xxxl 数据领袖Lv6

发表于2020-11-9 16:48

只看该作者

取消 关注该作者的回复

5#

liujiao 发表于 2020-11-9 16:32
这样设置的,在数据库管理里面执行正常

好的 稍等 我找研发看一下

xxxl 数据领袖Lv6

发表于2020-11-9 17:16

只看该作者

取消 关注该作者的回复

6#

liujiao 发表于 2020-11-9 16:32
这样设置的,在数据库管理里面执行正常

您先将sql放在数据库管理中运行试试看看有问题没

liujiao 初学数据Lv2

发表于2020-11-9 17:27

只看该作者

取消 关注该作者的回复

7#

xxxl 发表于 2020-11-9 17:16
您先将sql放在数据库管理中运行试试看看有问题没

试了呢   在数据库管理中没问题   

xxxl 数据领袖Lv6

发表于2020-11-9 16:20

只看该作者

取消 关注该作者的回复

8#

liujiao 发表于 2020-11-9 17:27
试了呢   在数据库管理中没问题

刚才和研发确认了 应该是bug,可能是包里缺少缺少getLimitString方法方法导致的,我站内私信您了

liujiao 初学数据Lv2

发表于2020-11-10 11:51

只看该作者

取消 关注该作者的回复

9#

xxxl 发表于 2020-11-10 10:31
刚才和研发确认了 应该是bug,可能是包里缺少缺少getLimitString方法方法导致的,我站内私信您了 ...

好的   谢谢啦

xxxl 数据领袖Lv6

发表于2020-11-10 13:45

只看该作者

取消 关注该作者的回复

10#


嗯嗯 不客气

登录后可回答问题,请登录注册

快速回复 返回顶部 返回列表

小时

全天响应

分钟

快速处理问题

工程师强势助力

明星产品
解决方案
联系合作

400咨询:400-0011-866

技术支持QQ:400-0011-866(工作日9:00-18:00)

产品建议邮箱yixin@esensoft.com

关注我们

扫TA学习更多干货

一对一专家交流

版权所有© 2006-2024 北京亿信华辰软件有限责任公司 京ICP备07017321号 京公网安备11010802016281号