Pentaho

 View Only
  • 1.  The Network Adapter could not establish the connection

    Posted 18 days ago
    Hi!

    I have an IO error that doesn´t allow me to connect to an oracle database

    Error connecting to database: (using class oracle.jdbc.driver.OracleDriver)
    Erro de ES: The Network Adapter could not establish the connection

    But i can conect the oracle database with other platforms like Power BI

    How i can resolve this issue?

    ------------------------------
    Thiago Melo
    Data Service Manager
    VLM
    ------------------------------


  • 2.  RE: The Network Adapter could not establish the connection

    Posted 15 days ago
    Hi Thiago

    I think the problem is the oracle driver name is hard-coded into Pentaho - there is the same problem with MySQL 8 drivers - and  'sun.jdbc.odbc.JdbcOdbcDriver'  is not the name of the driver anymore.  The error "rro de ES: The Network Adapter could not establish the connection" is usually because the driver is too old

    Try making a connection as a generic database type and use the name 'oracle.jdbc.OracleDriver'  (don't forget to put the up-to-date oracle jdbc back in the lib folder)  and a connection string in the form jdbc:oracle:thin:@//hostname:port/service_name


    ------------------------------
    Andrew Cave
    Systems Engineer
    BizCubed Pty Ltd
    Australia
    ------------------------------