logo
社区首页 / 全域数据集成平台 / 问题详情
标题
docker 安装restcloud 数据源连接 oracle 11g,一直报超时 time out
0
用户头像
楼主:1598378****
主题:2     回复:5     获赞:0 注册日期:2023-05-18

请问下,支持 restcloud ETL 支持 oracle 11g吗 ?,oracle 是安装在公网上的。程序都能连接上,

图片alt![图片alt]

使用的是阿里巴巴连接池 尝试了两种均不行: 方式一 驱动:oracle.jdbc.OracleDriver url: jdbc:oracle:thin:@xxxx:5721:helowin

方式二 驱动:oracle.jdbc.driver.OracleDriver 驱动:jdbc:oracle:thin:@xxxx:5721/helowin

---------------------------------------------------
签名:
共6回答
0
用户头像
回答者: 管理员
获赞:141 注册于:2017-07-02 回答于 2023-05-20 17:08:04 #1

oracle 11g肯定是支持,你可以用短链接进行测试是不是可以通,也可以把log错误发出来看看是什么原因 。

---------------------------------------------------
签名:我是一个码农...
0
用户头像
回答者: 1598378****
获赞:0 注册于:2023-05-18 回答于 2023-05-20 17:18:00 #2

一直报错 超时

ETL01:admin at 05/20 17:03:29 traceId:64688ce1a6160a6075785a02 =&gt准备测试数据库网络连通性 ETL01:admin at 05/20 17:03:29 traceId:64688ce1a6160a6075785a02 =&gt测试数据库地址(XXXX:5721) java.net.SocketTimeoutException: connect timed out at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:476) at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:218) at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:200) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:394) at java.net.Socket.connect(Socket.java:606) at cn.restcloud.datasource.util.DataSourceTestConnector.testNetworkConnectivity(DataSourceTestConnector.java:732) at cn.restcloud.datasource.util.DataSourceTestConnector.getDataSourceOrConnection(DataSourceTestConnector.java:97) at cn.restcloud.datasource.util.DataSourceTestConnector.testConnection(DataSourceTestConnector.java:69) at cn.restcloud.coreservice.setting.controller.DataSourceConfigRest.testDataSourceConnect(DataSourceConfigRest.java:667) 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.apache.commons.beanutils.MethodUtils.invokeMethod(MethodUtils.java:278) at org.apache.commons.beanutils.MethodUtils.invokeMethod(MethodUtils.java:222) at cn.restcloud.framework.core.util.BeanUtil.invokeMethod(BeanUtil.java:37) at cn.restcloud.framework.core.container.BeanEngine.call(BeanEngine.java:74) at cn.restcloud.framework.dispatcher.ControllerDispatcher.executeControllerBean(ControllerDispatcher.java:222) at cn.restcloud.framework.dispatcher.ActionDispatcher.execute(ActionDispatcher.java:211) at cn.restcloud.springboot.init.RestCloudServlet.doGet(RestCloudServlet.java:60) at cn.restcloud.springboot.init.RestCloudServlet.doPost(RestCloudServlet.java:69) at javax.servlet.http.HttpServlet.service(HttpServlet.java:696) at javax.servlet.http.HttpServlet.service(HttpServlet.java:779) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at cn.restcloud.springboot.filter.AppRequestFilter.doFilterInternal(AppRequestFilter.java:30) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at cn.restcloud.framework.filters.ServiceFilter.doFilter(ServiceFilter.java:42) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.springframework.boot.web.servlet.support.ErrorPageFilter.doFilter(ErrorPageFilter.java:128) at org.springframework.boot.web.servlet.support.ErrorPageFilter.access$000(ErrorPageFilter.java:66) at org.springframework.boot.web.servlet.support.ErrorPageFilter$1.doFilterInternal(ErrorPageFilter.java:103) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) at org.springframework.boot.web.servlet.support.ErrorPageFilter.doFilter(ErrorPageFilter.java:121) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:687) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:893) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1789) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:750)

---------------------------------------------------
签名:
0
用户头像
回答者: 管理员
获赞:141 注册于:2017-07-02 回答于 2023-05-20 17:37:50 #3

图片alt 公网的Oracle 119测试链接是没有问题的,socket报错一般来说是网络不通,你可以在里面去telnet下oracle的这个端口.

---------------------------------------------------
签名:我是一个码农...
0
用户头像
回答者: 1598378****
获赞:0 注册于:2023-05-18 回答于 2023-05-22 10:15:03 #4

有社区交流群吗, 不能老总在这提问题把,(lll¬ω¬)

---------------------------------------------------
签名:
0
用户头像
回答者: 管理员
获赞:141 注册于:2017-07-02 回答于 2023-05-22 10:54:12 #5

你可以先在这里问,群要晚点再开放加入,到时发个二维码给你

---------------------------------------------------
签名:我是一个码农...
0
用户头像
回答者: 1598378****
获赞:0 注册于:2023-05-18 回答于 2023-05-22 11:45:27 #6

好的 谢谢

---------------------------------------------------
签名: