Hi Thiago,
That may be because you've gone so far back on the ojdbc driver version that it isn't intended for use with the more recent JDK versions.
If you're using Pentaho 9.4 then you should be using Oracle OpenJDK 11.0.13 (Certified) or something from the 11.x range as this is at least supported according to the Components Reference. (https://help.hitachivantara.com/Documentation/Pentaho/9.4/Setup/Components_Reference)
If you were using ojdbc 21.8.0.0, I would roll back more gradually to the next newest which is 21.7.0.0. All the ojdbc8 drivers from 12.2.x and up are listed as compatible with JDK11, whereas the ojdbc6 only lists JDK compatibility up to and including JDK8.
Kind regards
------------------------------
Justin Phebey
Freelance
------------------------------
Original Message:
Sent: 01-20-2023 12:53
From: Thiago Melo
Subject: OJDBC driver problem
I think i was able to find a solution by swithcing to an older version of the conector, i used the ojdbc6, but now i have an IO error in the network adapter
Error connecting to database: (using class oracle.jdbc.driver.OracleDriver)
Erro de ES: The Network Adapter could not establish the connection
Maybe i have to open a new discusson for this one, thanks for all the help!
------------------------------
Thiago Melo
Data Service Manager
VLM
Original Message:
Sent: 01-19-2023 16:10
From: Thiago Melo
Subject: OJDBC driver problem
Hi!
i've been having a problem when connecting to an oracle database, the following error pops-up:
Driver class 'sun.jdbc.odbc.JdbcOdbcDriver' could not be found, make sure the 'Oracle' driver (jar file) is installed.
sun.jdbc.odbc.JdbcOdbcDriver
But i have the ojdbc in the lib folder, all the system paths from pentaho to java seems to be correct.
Any guess? how can i resolve this problem?
Thank you for any help!
------------------------------
Thiago Melo
Data Service Manager
VLM
------------------------------