1、pom.xml中使用
com.oracle
ojdbc6
12.1.0.1-atlassian-hosted
2、db.properties中已默认mysql配置,再配置oracle
jdbc.many.myoracle.type=druid
jdbc.many.myoracle.url=jdbc:oracle:thin:@38.43.64.103:1521:orcl:myoracle
...
3、日志中报错信息
2019-04-01 22:24:46 [ Druid-ConnectionPool-Create-644345897:1807 ] - [ ERROR ] create connection SQLException, url: jdbc:oracle:thin:@38.43.64.103:1521:orcl:myoracle, errorCode 17002, state 08006
java.sql.SQLRecoverableException: IO 错误: Invalid connection string format, a valid format is: "host:port:sid"
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:673)
at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:711)
at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:385)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:30)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:558)
at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:156)
at com.alibaba.druid.filter.stat.StatFilter.connection_connect(StatFilter.java:218)
at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:150)
at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1572)
at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1636)
at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2505)
Caused by: oracle.net.ns.NetException: Invalid connection string format, a valid format is: "host:port:sid"
at oracle.net.resolver.AddrResolution.resolveSimple(AddrResolution.java:535)
at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:441)
at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:594)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:229)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1360)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:486)
... 10 more