Pentaho Data Integration中Oracle驱动安装及数据库连接问题求助

Hey there, let's get that Oracle database connection working in Pentaho. The error you're seeing is straightforward—Pentaho can't locate the Oracle JDBC driver jar file, even though you've downloaded it. Here's how to fix it, depending on your Pentaho setup:

Where to Place the Oracle JDBC Jar #

1. For Pentaho Data Integration (PDI) Desktop (Spoon) #

• Older PDI versions (5.x and earlier): Look for the lib-ext folder inside your main PDI installation directory (usually data-integration/lib-ext). If you can't find it, double-check your installation path—common locations are C:\Program Files\Pentaho\data-integration (Windows) or /opt/pentaho/data-integration (Linux/Mac). Drop your Oracle driver jar (like ojdbc8.jar for Oracle 12c+) here.
• Newer PDI versions (8.x and later): Pentaho moved third-party JDBC drivers to the data-integration/lib folder, often in a dedicated jdbc subdirectory. If there's no jdbc folder, just place the jar directly in lib.

2. For Pentaho Server (Web-Based) #

If you're using the web version of Pentaho, copy the Oracle driver jar to pentaho-server/tomcat/lib. Important: You must restart the Pentaho Server after adding the jar—otherwise, the driver won't be loaded.

Critical Notes to Avoid Issues #

• Make sure your driver jar version matches your Oracle database version: Use ojdbc6.jar for Oracle 11g, ojdbc8.jar for Oracle 12c/18c/19c, etc. Mismatched versions can cause unexpected errors.
• After placing the jar, close and restart Spoon (or the Pentaho Server) to ensure the driver is picked up.
• If you still can't find the right folder, use your system's search tool to look for lib within your Pentaho installation directory—you'll definitely locate it.

内容的提问来源于stack exchange，提问作者Jose Ramon Rubio