Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Migrating from pdi3 to pdi4: libraries problems

  1. #1
    Join Date
    May 2006

    Default Migrating from pdi3 to pdi4: libraries problems

    an application I use has kettle inside (with some libs of kettle3.2.0).
    Now I want to migrate to PDI4.
    I copied these libraries (the same ones I had before, but newer versions):
    - js.jar
    - jxl.jar
    - kettle-core.jar
    - kettle-db.jar
    - kettle-engine.jar
    - kettle-vfs-20100924.jar
    - ognl-2.6.9.jar
    - pentaho-database-4.0.5.jar

    When I launch the functionality using kettle I get this error:
    Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
    database type with plugin id [Oracle] couldn't be found!

    at org.pentaho.di.core.database.DatabaseMeta.findDatabaseInterface(
    at org.pentaho.di.core.database.DatabaseMeta.getDatabaseInterface(
    at org.pentaho.di.core.database.DatabaseMeta.setValues(
    ... 93 more

    Linking the source code I found that the problem is in in the method:

    * Find the plugin ID based on the name of the plugin
    * @param pluginType the type of plugin
    * @param pluginName The name to look for
    * @return The plugin with the specified name or null if nothing was found.
    public PluginInterface findPluginWithName(Class<? extends PluginTypeInterface> pluginType, String pluginName) {
    for (PluginInterface plugin : getPlugins(pluginType)) {

    if (plugin.getName().equals(pluginName)) {
    return plugin;
    return null;

    What I do not understand is why Oracle, I don't use it, but postgres.
    Maybe I missed some libraries or some file where is located the mapping needed to that class.

    So I ask you for some suggestions, please.

    Thank you,

  2. #2
    Join Date
    Nov 1999


    It's an interesting observation. For your situation it would indeed be best to skip those database plugins that don't have a driver installed.
    It currently considers all plugins from kettle-database-types.xml

    File a JIRA case and I'll try to fix it ASAP.

  3. #3
    Join Date
    May 2006


    Bye and thanks a lot,

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.