Pentaho

 View Only
  • 1.  OJDBC driver problem

    Posted 01-19-2023 16:11
    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
    ------------------------------


  • 2.  RE: OJDBC driver problem

    Posted 01-20-2023 01:55
    Can you provide the name of the JDBC driver you are using?
    Have you tested the same JDBC driver with another tool that uses JDBC drivers? eg: squirrelSQL http://www.squirrelsql.org/

    ------------------------------
    Juan Sierra Pons
    Systems Engineer
    Juan Sierra Pons
    ------------------------------



  • 3.  RE: OJDBC driver problem

    Posted 01-20-2023 09:09

    The driver is the ojdbc8.jar, i tested with Other tools that uses JDBC driver too, but i get the same error.

     

    What can i do to resolve this issue?

     

    Thanks for your help!

     

    Thiago Parra de Melo
    Analista de Dados
    +55 (11) 3514-7200 -
    Av. Paulista, 171 8ºandar
    01311-904/SP

     






  • 4.  RE: OJDBC driver problem

    Posted 01-20-2023 09:21
    Make sure that:
    ojdbc8. jar and ojdbc8.pom are present in the .../lib folder
    the driver is suitable for the version of Oracle you want to access.
    the driver is copied to all library folders from where you need to access it.

    Best regards

    ------------------------------
    Carl Messner
    Data Analyst
    MCSF
    ------------------------------



  • 5.  RE: OJDBC driver problem

    Posted 01-20-2023 08:20
    Hi Thiago,
    Make sure that the driver is suitable for the version of Oracle you want to access.
    Make sure that the driver is copied to all library folders from where you need to access it.
    IE for PDI:
    .../design-tools/data-integration/lib
    for Server:
    .../server/pentaho-server/tomcat/lib
    and so on

    Best regards

    ------------------------------
    Carl Messner
    Data Analyst
    MCSF
    ------------------------------



  • 6.  RE: OJDBC driver problem

    Posted 01-20-2023 09:20
    Hi Carl!

    The version of the drive is suitable for the version of oracle and the driver is on the lib folder of data-integration.

    how can i resolve this issue?

    Thanks for your help!

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



  • 7.  RE: OJDBC driver problem

    Posted 01-20-2023 11:17
    Hi Thiago,

    If this is for Pentaho Server, I always put the drivers in both of the following locations:

    ../pentaho-server/tomcat/lib/
    ../pentaho-server/data/lib/

    If that doesn't fix it which it seems it wouldn't since you've tried other design tools, I'd try rolling back to the next newest version of the driver to the one you're using.

    I find it easiest to fish them out of maven here:

    https://mvnrepository.com/artifact/com.oracle.database.jdbc/ojdbc8

    or here:

    https://repo1.maven.org/maven2/com/oracle/database/jdbc/ojdbc8/

    Kind regards

    ------------------------------
    Justin Phebey
    Freelance
    ------------------------------



  • 8.  RE: OJDBC driver problem
    Best Answer

    Posted 01-20-2023 12:53
    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
    ------------------------------



  • 9.  RE: OJDBC driver problem

    Posted 01-20-2023 13:18
    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
    ------------------------------