Hello,
I have a Oracle Database and I'm trying to use the kettleTransFromFile DataSource to call a PDI Transformation from my CDE Dashboard.
When I execute this datasource, I receive the following error:
Database lookup.0 - Error connecting to database: (using class oracle.jdbc.driver.OracleDriver)
Database lookup.0 - Erro de ES: NL Exception was generated
I thought I had a problem with my connection, so I've created a DataSource inside Pentaho with the same parameters from the Transformation Connection and created a SQL Datasource in my CDE Dashboard.
Everything worked fine, so I can see that I don't have a problem in my connection.
Maybe someone could give me any idea about this situation? I'm not sure but I think the problem is in JDBC Driver, the kettleTransFromFile datasource also uses the JDBC drivers located in: tomcat/lib ?
Thanks!