今天在win7环境下安装了kettle版本pdi-ce-4.2.0-stable,连接本机Oracle11g时出现如下提示错误:(下面只是列出了前几行)
错误连接数据库 [test] :
org.pentaho.di.core.exception.KettleDatabaseException:
Error occured while trying to connect to the database
Error connecting to database: (using class
oracle.jdbc.driver.OracleDriver)
oracle.i18n.text.converter.CharacterConverterOGS.getInstance(I)Loracle/i18n/text/converter/CharacterConverter;
org.pentaho.di.core.exception.KettleDatabaseException:
Error occured while trying to connect to the database
.......................................................
.......................................................
后来通过查找资料解决,过程如下:
<1>首先,把$Oracle_home/jdbc/lib目录下的两个jar包:ojdbc5.jar和ojdbc6.jar拷贝到D:/pdi-ce- 4.2.0-stable/data-integration/libext/JDBC,然后重新启动kettle,既点击:D:/pdi-ce- 4.2.0-stable/dat