The Network Adapter could not establish the connection | Pentaho

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
——————————

Original Message:
Sent: 01-20-2023 13:02
From: Thiago Melo
Subject: The Network Adapter could not establish the connection

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
——————————

Hi ThiagoI 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 oldTry 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 CaveSystems EngineerBizCubed Pty LtdAustralia——————————