Kettle 连接 Oracle 问题总结

前端之家收集整理的这篇文章主要介绍了Kettle 连接 Oracle 问题总结前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。

一、

Driver class 'oracle.jdbc.driver.OracleDriver' could not be found,make sure the 'Oracle' driver (jar file) is installed.
oracle.jdbc.driver.OracleDriver

缺少Oracle JDBC jar包,将ojdbc-x.jar 放在lib目录下

二、

Error connecting to database: (using class oracle.jdbc.driver.OracleDriver)
Listener refused the connection with the following error:
ORA-12505,TNS:listener does not currently know of SID given in connect descriptor

jdbc连接数据库的时候,需要使用数据库的sid_name,而不是数据库的services_name

作者:itmyhome

猜你在找的Oracle相关文章