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

    [亿信BI4.7] 数据库设置支持kingbaseESV8R3数据库吗？

    复制链接 | 收藏本帖
    5619
    6

    13894878096 小试身手Lv3

    发表于2020-6-29 16:55

    悬赏100

    已解决

    楼主
    数据库设置支持kingbaseESV8R3数据库吗？

    最近看过此主题的会员

    hulu6160

    daix

    sherryxu

    西瓜小姐

    18351927161

    Amyjing9

    xiewenze

    dongying

    lii_chen1234

    1505121235

    yangqh

    最佳答案

    1505121235

    发表于2020-6-29 16:55

    丨

    只看该作者

    丨

    取消 关注该作者的回复

    http://bbs.esensoft.com/thread-135434-1-1.html
    这是我们已经支持的数据库，你参考一下
    QQ空间 微信
    6个回答

    只看楼主

    1505121235 数据老手Lv5

    发表于2020-6-29 16:55

    丨

    只看该作者

    丨

    取消 关注该作者的回复

    沙发

    http://bbs.esensoft.com/thread-135434-1-1.html
    这是我们已经支持的数据库，你参考一下

    回复

    13894878096 小试身手Lv3

    发表于2020-6-30 16:24

    丨

    只看该作者

    丨

    取消 关注该作者的回复

    板凳

    1505121235 发表于 2020-6-29 17:07
    http://bbs.esensoft.com/thread-135434-1-1.html
    这是我们已经支持的数据库，你参考一下
    ...

    这三种试过都连接不上，您那边有人部署过kingbaseESV8R3这个数据库吗，最好试试，然后能不能给解决一下

    回复

    1505121235 数据老手Lv5

    发表于2020-6-30 16:40

    丨

    只看该作者

    丨

    取消 关注该作者的回复

    地板

    本帖最后由 1505121235 于 2020-6-30 16:43 编辑

    13894878096 发表于 2020-6-30 16:24
    这三种试过都连接不上，您那边有人部署过kingbaseESV8R3这个数据库吗，最好试试，然后能不能给解决一下
    ...

    连接不上报什么错,将驱动放进bi的web-inf/lib目录下；清理缓存后重启服务器 kingbase8-8.2.0.jre7.zip (801.12 KB, 下载次数: )

    回复

    13894878096 小试身手Lv3

    发表于2020-6-30 16:41

    丨

    只看该作者

    丨

    取消 关注该作者的回复

    5#

    1505121235 发表于 2020-6-30 16:40
    连接不上报什么错

    参照：http://bbs.esensoft.com/thread-136228-1-1.html

    回复

    13894878096 小试身手Lv3

    发表于2020-6-30 17:21

    丨

    只看该作者

    丨

    取消 关注该作者的回复

    6#

    1505121235 发表于 2020-6-30 16:40
    连接不上报什么错,将驱动放进bi的web-inf/lib目录下； ...

    我试试

    回复

    13894878096 小试身手Lv3

    发表于2020-6-30 19:01

    丨

    只看该作者

    丨

    取消 关注该作者的回复

    7#

    1505121235 发表于 2020-6-30 16:40
    连接不上报什么错,将驱动放进bi的web-inf/lib目录下； ...

    我这边安装的jdk是1.8，所以驱动包放的这个kingbase8-8.2.0.jar，数据库选的kingbaseES，连接地址j我是这么写的jdbc:kingbase8://192.168.233.129:54321/KINGDB看日志还是说找不到的意思，但是bi/WEB-INF/lib下已经有了，tomcat缓存也清理了，整个war包也是删除后放进去的，依然报错！！！确认是支持kingbase8吗？
    报错：
    QueryObj ERROR:/bi/esmain/setup.do?driverClassName=com.kingbase.Driver&url=jdbc:kingbase8://192.168.233.129:54321/KINGDB&username=NSTOR&password=123456&catalog=&maxActive=20&maxWait=10000&logLevel=ERROR&action=testdatasource
    java.lang.RuntimeException: 测试失败,无法获得数据库链接.
    java.sql.SQLException: No suitable driver found for jdbc:kingbase8://192.168.233.129:54321/KINGDB
    No suitable driver found for jdbc:kingbase8://192.168.233.129:54321/KINGDB
      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.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
      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: java.sql.SQLException: No suitable driver found for jdbc:kingbase8://192.168.233.129:54321/KINGDB
      at java.sql.DriverManager.getConnection(DriverManager.java:689)
      at java.sql.DriverManager.getConnection(DriverManager.java:247)
      at com.esen.jdbc.SqlFunc.testDataSource(SqlFunc.java:1470)
      ... 65 more



    JavaScript StackTrace:
    Error: 测试失败,无法获得数据库链接.
    java.sql.SQLException: No suitable driver found for jdbc:kingbase8://192.168.233.129:54321/KINGDB
    No suitable driver found for jdbc:kingbase8://192.168.233.129:54321/KINGDB
    --detailmessage--
    QueryObj ERROR:/bi/esmain/setup.do?driverClassName=com.kingbase.Driver&url=jdbc%3Akingbase8%3A%2F%2F192.168.233.129%3A54321%2FKINGDB&username=NSTOR&password=123456&catalog=&maxActive=20&maxWait=10000&logLevel=ERROR&action=testdatasource
    java.lang.RuntimeException: 测试失败,无法获得数据库链接.
    java.sql.SQLException: No suitable driver found for jdbc:kingbase8://192.168.233.129:54321/KINGDB
    No suitable driver found for jdbc:kingbase8://192.168.233.129:54321/KINGDB
      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.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
      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: java.sql.SQLException: No suitable driver found for jdbc:kingbase8://192.168.233.129:54321/KINGDB
      at java.sql.DriverManager.getConnection(DriverManager.java:689)
      at java.sql.DriverManager.getConnection(DriverManager.java:247)
      at com.esen.jdbc.SqlFunc.testDataSource(SqlFunc.java:1470)
      ... 65 more

    --messageInfo--
    rootExceptionClass=java.sql.SQLException
    at throwError (http://192.168.233.129:8080/bi/xui/sys.js:1987:14)
    at QueryObj.checkResult (http://192.168.233.129:8080/bi/xui/util.js:1:91253)
    at http://192.168.233.129:8080/bi/esmain/setup.do:453:7
    at QueryObj._onreadystatechange (http://192.168.233.129:8080/bi/xui/util.js:1:87579)
    at XMLHttpRequest.hp.onreadystatechange (http://192.168.233.129:8080/bi/xui/util.js:1:87904)

    回复

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

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

    小时

    全天响应

    分钟

    快速处理问题

    工程师强势助力

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

    400咨询：400-0011-866

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

    产品建议邮箱yixin@esensoft.com

    关注我们

    扫TA学习更多干货

    一对一专家交流

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