1、使用url建立数据连接，在设计器中成功

jdbc:oracle:thin:@XXXX.yn.cn:1523/XXXX

2、在帆软中失败

格式如下

报错如下

java.sql.SQLRecoverableException: IO 错误: Unknown host specified at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:774) at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:688) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:39) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:691) at com.fr.third.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1461) at com.fr.third.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1525) at com.fr.third.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2165) Caused by: oracle.net.ns.NetException: Unknown host specified at oracle.net.resolver.HostnameNamingAdapter.resolve(HostnameNamingAdapter.java:209) at oracle.net.resolver.NameResolver.resolveName(NameResolver.java:131) at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:489) at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:660) at oracle.net.ns.NSProtocol.connect(NSProtocol.java:286) at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1438) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:518) ... 6 more

猜测的原因

1、采用url格式不对，解析成为ip连接同样报错

2、该数据库是集群的，但是为什么能够在设计器中连接成功