Hitachi Vantara Pentaho Community Forums
Results 1 to 6 of 6

Thread: DatabaseMeta is not JNDI, it is OCI

  1. #1
    Join Date
    Apr 2016
    Posts
    4

    Default DatabaseMeta is not JNDI, it is OCI

    Hi,

    PentahoDI does not support Oracle databases using Oracle OCI? It supports only JDBC connections?
    The database connection check ok, but when I'm trying to interrogate a table is giving me the above error.

    Thanks and Regards,
    Stefan

  2. #2

    Default

    i have the same probleme but i can't find a solution

  3. #3
    Join Date
    Apr 2016
    Posts
    4

    Default

    The problem seems to be in the class org.pentaho.metaverse.api.model.ExternalResourceInfoFactory (JdbcResourceInfo/JndiResourceInfo). The "OCI" goes on the JNDI branch:


    Code:
     public static IExternalResourceInfo createDatabaseResource( DatabaseMeta databaseMeta, boolean isInput ) {
        BaseDatabaseResourceInfo resourceInfo;
        if ( "Native".equals( databaseMeta.getAccessTypeDesc() ) ) {
          resourceInfo = new JdbcResourceInfo( databaseMeta );
        } else {
          resourceInfo = new JndiResourceInfo( databaseMeta );
        }
        resourceInfo.setInput( isInput );
        return resourceInfo;
      }


    I think OCI should be treated as an JDBC type (the check in JdbcResourceInfo should include OCI).




    Regards
    Last edited by StefanG; 04-26-2016 at 05:51 AM.

  4. #4
    Join Date
    Apr 2016
    Posts
    4

    Default [SOLVED] DatabaseMeta is not JNDI, it is OCI

    The solution is to configure the connection as JNDI in <kettle_root>/simple-jndi/jdbc.properties

    adding something like this:

    Code:
    MyConn/type=javax.sql.DataSource
    MyConn/driver=oracle.jdbc.driver.OracleDriver
    MyConn/url=jdbc:oracle:oci:/@MyDb
    MyConn/user=MyUser
    MyConn/password=MyPassword
    In Spoon when defining a connection is simple:

    Name:  conn.jpg
Views: 390
Size:  31.0 KB

    Regards

  5. #5
    Join Date
    Nov 2017
    Posts
    3

    Default

    Hi,
    is there any solution found for this issue, please suggest.
    I am facing similar issue for pentaho-8.1 testing also, my transformations are using OCI.
    But testing fails with "Unable to open transformation: DatabaseMeta is not JNDI, it is OCI " .

    We cannot use JNDI as it may cause to change lot of source code, using only oci solution will be very helpful.
    Last edited by abnewuser; 11-28-2017 at 10:48 AM.

  6. #6
    Join Date
    Nov 2017
    Posts
    3

    Default

    This issue persists in pdi-ce-8.2.0.0-342
    Does anyone found solution for this issue

Tags for this Thread

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.