Reputation: 294
I'm trying to setup Pentaho connection with my Oracle DataWarehouse (localhost). However, this error "ConnectionServiceImpl.ERROR_0009 - Connection to database [DBNAME] failed" appears when I try to test the connection. The information about server should be right, and I also added the JDBC to the tomcat folder.
Error capture
Database Connection information
Upvotes: 0
Views: 1309
Reputation: 4544
Check your catalina.out log. You should have the cause of the error there. It could be a bad url, bad db name, bad credentials, missing jdbc driver, among many other reasons.
Catalina.out is inside your tomcat/logs folder by default.
Upvotes: 1