登录/注册
    我的位置：首页 › 大数据分析-亿信BI › BI-问题求助 › 数据库设置

    [亿信BI4.7] 数据库设置

    复制链接 | 收藏本帖
    5345
    3

    13894878096 小试身手Lv3

    发表于2020-6-24 17:28

    悬赏110

    未解决

    楼主
    本帖最后由 13894878096 于 2020-6-28 09:34 编辑

    数据库是 kingbaseESV8R3，连接失败，我本地数据库管理工具可以连接数据库，需要单独配置数据库驱动？



    QueryObj ERROR:/BI@ReportV4.7.1R222_20190613110352/esmain/setup.do?driverClassName=com.kingbase.Driver&url=jdbc:kingbase://192.168.233.129:54321/KINGDB&username=NSTOR&password=123456&catalog=&maxActive=20&maxWait=10000&logLevel=ERROR&action=testdatasource
    java.lang.RuntimeException: 测试失败,无法获得数据库链接.
    [KingbaseES JDBC Driver]Backend start-up failed: unsupported frontend protocol 3.3: server supports 1.0 to 3.0
    [KingbaseES JDBC Driver]Backend start-up failed: unsupported frontend protocol 3.3: server supports 1.0 to 3.0
      at com.esen.jdbc.SqlFunc.testDataSource(SqlFunc.java:1473)
      at com.esen.platform.server.Jdbc.testDataSource(Jdbc.java:147)
      at com.esen.platform.action.setup.ActionSystemSetup.testDataSource(ActionSystemSetup.java:146)
      at com.esen.platform.action.setup.ActionSystemSetup.jsexecute(ActionSystemSetup.java:102)
      at com.esen.weblib.action.Action_Js.execute(Action_Js.java:73)
      at com.esen.weblib.action.Action.handle(Action.java:66)
      at sun.reflect.GeneratedMethodAccessor50.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.doPost(FrameworkServlet.java:838)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:660)
      at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:812)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
      at com.esen.platform.web.ReleasabledServlet.service(ReleasabledServlet.java:93)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
      at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
      at com.esen.bi.jsp.filter.NoBackendActionFilter.doFilter(NoBackendActionFilter.java:40)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
      at com.esen.bi.jsp.filter.EsmainActionFilter.doFilter(EsmainActionFilter.java:51)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
      at com.esen.platform.action.FilterLoginCheck.doFilter(FilterLoginCheck.java:75)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
      at com.esen.platform.web.PlatformLocaleContextFilter.doFilter(PlatformLocaleContextFilter.java:47)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
      at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
      at com.esen.platform.action.EsCharacterEncodingFilter.doFilterInternal(EsCharacterEncodingFilter.java:27)
      at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
      at com.esen.platform.sso.SSODelegatingFilter.doFilter(SSODelegatingFilter.java:32)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
      at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:543)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
      at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:690)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
      at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:615)
      at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
      at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:818)
      at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1627)
      at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
      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)
    Caused by: [KingbaseES JDBC Driver]Backend start-up failed: unsupported frontend protocol 3.3: server supports 1.0 to 3.0
      at com.kingbase.jdbc2.AbstractJdbc2Connection.parseErrorMessage(Unknown Source)
      at com.kingbase.jdbc2.AbstractJdbc2Connection.openConnectionPV3(Unknown Source)
      at com.kingbase.jdbc2.AbstractJdbc2Connection.openConnection(Unknown Source)
      at com.kingbase.Driver.connect(Unknown Source)
      at java.sql.DriverManager.getConnection(DriverManager.java:664)
      at java.sql.DriverManager.getConnection(DriverManager.java:247)
      at com.esen.jdbc.SqlFunc.testDataSource(SqlFunc.java:1470)
      ... 64 more



    JavaScript StackTrace:
    Error: 测试失败,无法获得数据库链接.
    [KingbaseES JDBC Driver]Backend start-up failed: unsupported frontend protocol 3.3: server supports 1.0 to 3.0
    [KingbaseES JDBC Driver]Backend start-up failed: unsupported frontend protocol 3.3: server supports 1.0 to 3.0
    --detailmessage--
    QueryObj ERROR:/BI@ReportV4.7.1R222_20190613110352/esmain/setup.do?driverClassName=com.kingbase.Driver&url=jdbc%3Akingbase%3A%2F%2F192.168.233.129%3A54321%2FKINGDB&username=NSTOR&password=123456&catalog=&maxActive=20&maxWait=10000&logLevel=ERROR&action=testdatasource
    java.lang.RuntimeException: 测试失败,无法获得数据库链接.
    [KingbaseES JDBC Driver]Backend start-up failed: unsupported frontend protocol 3.3: server supports 1.0 to 3.0
    [KingbaseES JDBC Driver]Backend start-up failed: unsupported frontend protocol 3.3: server supports 1.0 to 3.0
      at com.esen.jdbc.SqlFunc.testDataSource(SqlFunc.java:1473)
      at com.esen.platform.server.Jdbc.testDataSource(Jdbc.java:147)
      at com.esen.platform.action.setup.ActionSystemSetup.testDataSource(ActionSystemSetup.java:146)
      at com.esen.platform.action.setup.ActionSystemSetup.jsexecute(ActionSystemSetup.java:102)
      at com.esen.weblib.action.Action_Js.execute(Action_Js.java:73)
      at com.esen.weblib.action.Action.handle(Action.java:66)
      at sun.reflect.GeneratedMethodAccessor50.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.doPost(FrameworkServlet.java:838)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:660)
      at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:812)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
      at com.esen.platform.web.ReleasabledServlet.service(ReleasabledServlet.java:93)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
      at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
      at com.esen.bi.jsp.filter.NoBackendActionFilter.doFilter(NoBackendActionFilter.java:40)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
      at com.esen.bi.jsp.filter.EsmainActionFilter.doFilter(EsmainActionFilter.java:51)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
      at com.esen.platform.action.FilterLoginCheck.doFilter(FilterLoginCheck.java:75)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
      at com.esen.platform.web.PlatformLocaleContextFilter.doFilter(PlatformLocaleContextFilter.java:47)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
      at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
      at com.esen.platform.action.EsCharacterEncodingFilter.doFilterInternal(EsCharacterEncodingFilter.java:27)
      at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
      at com.esen.platform.sso.SSODelegatingFilter.doFilter(SSODelegatingFilter.java:32)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
      at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:543)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
      at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:690)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
      at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:615)
      at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
      at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:818)
      at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1627)
      at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
      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)
    Caused by: [KingbaseES JDBC Driver]Backend start-up failed: unsupported frontend protocol 3.3: server supports 1.0 to 3.0
      at com.kingbase.jdbc2.AbstractJdbc2Connection.parseErrorMessage(Unknown Source)
      at com.kingbase.jdbc2.AbstractJdbc2Connection.openConnectionPV3(Unknown Source)
      at com.kingbase.jdbc2.AbstractJdbc2Connection.openConnection(Unknown Source)
      at com.kingbase.Driver.connect(Unknown Source)
      at java.sql.DriverManager.getConnection(DriverManager.java:664)
      at java.sql.DriverManager.getConnection(DriverManager.java:247)
      at com.esen.jdbc.SqlFunc.testDataSource(SqlFunc.java:1470)
      ... 64 more

    --messageInfo--
    rootExceptionClass=com.kingbase.util.KSQLException
    at throwError (http://192.168.233.129:8080/BI@R ... /xui/sys.js:1987:14)
    at QueryObj.checkResult (http://192.168.233.129:8080/BI@R ... xui/util.js:1:91253)
    at http://192.168.233.129:8080/BI@R ... main/setup.do:453:7
    at QueryObj._onreadystatechange (http://192.168.233.129:8080/BI@R ... xui/util.js:1:87579)
    at XMLHttpRequest.hp.onreadystatechange (http://192.168.233.129:8080/BI@R ... xui/util.js:1:87904)

    最近看过此主题的会员

    Amazing-wen

    esen_4V5P4W1G9J

    xy6228476

    esen_43MZ4VYW213F

    daix

    947758741

    dch

    sherryxu

    XKINGM

    sxdlik

    hkkks123

    yunxi

    Amyjing9

    esen_3F3Y4FNL8OQN

    未知用户

    我来回答
    QQ空间 微信
    3个回答

    只看楼主

    wut 数据老手Lv5

    发表于2020-6-24 17:48

    丨

    只看该作者

    丨

    取消 关注该作者的回复

    沙发

    数据库的具体版本号是？

    回复

    13894878096 小试身手Lv3

    发表于2020-6-24 17:52

    丨

    只看该作者

    丨

    取消 关注该作者的回复

    板凳

    wut 发表于 2020-6-24 17:48
    数据库的具体版本号是？

    kingbaseES_V008R003


    KingbaseES_V008R003C002B0010_Lin64

    回复

    18943137610 初学数据Lv2

    发表于2020-6-29 09:58

    丨

    只看该作者

    丨

    取消 关注该作者的回复

    地板

    有可能是不支持

    回复

    登录后可回答问题，请登录或注册

    有问题，来提问！
    我要发帖
    热门推荐
    热门视频
    热门产品推荐
    快速回复 返回顶部 返回列表

    小时

    全天响应

    分钟

    快速处理问题

    工程师强势助力

    明星产品
    一站式数据分析平台-亿信ABI
    智能数据治理平台-睿治
    解决方案
    大数据治理方案
    数据标准化及质量管控方案
    主数据管理方案
    数据资产盘点方案
    联系合作

    400咨询：400-0011-866

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

    产品建议邮箱yixin@esensoft.com

    关注我们

    扫TA学习更多干货

    一对一专家交流

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