找文章 / 找答案
精选问答 更多内容

连接数据库失败

yhdata_xrvXuQqg青铜一 显示全部楼层 发表于 2024-3-14 11:02:44 |阅读模式 打印 上一主题 下一主题
1
未解决

连接数据库失败

1000 2
错误代码:110099999
数据集: '未命名-0'   执行用户: 'admin'
g5.util.RTWrappedException: g5.util.exception.ConnException: IO 错误: The Network Adapter could not establish the connection (CONNECTION_ID=Yh4OHqewQKW4o4fdi2jYVw==)
        at g5.qry.driver.ConnectionProvider.getConn(ConnectionProvider.java:115)
        at g5.sv.qry.req.TestQryReq$CreateConnRunable.run(TestQryReq.java:351)
        at g5.thread.ThreadPoolWithChecker$GThread.run0(ThreadPoolWithChecker.java:223)
        at g5.thread.AbsThreadPool$PThread.run(AbsThreadPool.java:325)
Caused by: g5.util.exception.ConnException: IO 错误: The Network Adapter could not establish the connection (CONNECTION_ID=Yh4OHqewQKW4o4fdi2jYVw==)
        at g5.qry.sql.impl.SQLConnBuilder.build0(SQLConnBuilder.java:91)
        at g5.qry.sql.impl.JDBCConnBuilder.build(JDBCConnBuilder.java:66)
        at jdk.internal.reflect.GeneratedMethodAccessor20.invoke(Unknown Source)
        at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.base/java.lang.reflect.Method.invoke(Method.java:566)
        at g5.qry.driver.ConnectionProvider.getConn(ConnectionProvider.java:90)
        ... 3 more
Caused by: java.sql.SQLRecoverableException: IO 错误: The Network Adapter could not establish the connection (CONNECTION_ID=Yh4OHqewQKW4o4fdi2jYVw==)
        at oracle.jdbc.driver.T4CConnection.handleLogonNetException(T4CConnection.java:892)
        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:697)
        at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:1047)
        at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:89)
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:732)
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:648)
        at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677)
        at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:189)
        at g5.qry.sql.impl.SQLConnBuilder.build0(SQLConnBuilder.java:81)
        ... 8 more
Caused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection (CONNECTION_ID=Yh4OHqewQKW4o4fdi2jYVw==)
        at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:715)
        at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:584)
        at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:964)
        at oracle.net.ns.NSProtocol.connect(NSProtocol.java:350)
        at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:2441)
        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:656)
        ... 15 more
Caused by: java.io.IOException: Connection timed out: connect, socket connect lapse 21036 ms. 10.18.60.17 9030  30000 (1/1) true
        at oracle.net.nt.TcpNTAdapter.establishSocket(TcpNTAdapter.java:425)
        at oracle.net.nt.TcpNTAdapter.doLocalDNSLookupConnect(TcpNTAdapter.java:307)
        at oracle.net.nt.TcpNTAdapter.connect(TcpNTAdapter.java:269)
        at oracle.net.nt.ConnOption.connect(ConnOption.java:230)
        at oracle.net.nt.ConnStrategy.executeConnOption(ConnStrategy.java:1014)
        at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:673)
        ... 20 more
Caused by: java.net.ConnectException: Connection timed out: connect
        at java.base/sun.nio.ch.Net.connect0(Native Method)
        at java.base/sun.nio.ch.Net.connect(Net.java:482)
        at java.base/sun.nio.ch.Net.connect(Net.java:474)
        at java.base/sun.nio.ch.SocketChannelImpl.connect(SocketChannelImpl.java:694)
        at java.base/java.nio.channels.SocketChannel.open(SocketChannel.java:194)
        at oracle.net.nt.TimeoutSocketChannel.connect(TimeoutSocketChannel.java:183)
        at oracle.net.nt.TimeoutSocketChannel.<init>(TimeoutSocketChannel.java:157)
        at oracle.net.nt.TcpNTAdapter.establishSocket(TcpNTAdapter.java:384)
        ... 25 more


回复

使用道具 举报

精彩评论2

yhdata_lyaa 显示全部楼层 发表于 2024-3-14 11:09:38
数据源连接失败,在有bi的服务器上用其他工具可以正常连接吗
回复

使用道具 举报

yhdata_yzm 显示全部楼层 发表于 2024-3-14 11:14:42
排查网络,防火墙等安全设置,Url重的用户名密码,数据库服务,jdbc驱动的版本是否能和数据库版本匹配
回复

使用道具 举报

高级模式
您需要登录后才可以回帖 登录 | 免费注册

  • 官方微信

    欢迎关注永洪服务号!收费为0,价值无限

    扫码关注
  • 新浪微博

    让每位用户轻松挖掘数据价值!

    访问新浪微博
  • 智能客服
50W

会员等你来哦

Copyright   ©2012-2024  北京永洪商智科技有限公司  (京ICP备12050607) 京公网安备110110802011451号 |《永洪社区协议》
返回顶部