Uploaded image for project: 'i2b2 Core Software'
  1. i2b2 Core Software
  2. CORE-284

Ant not working with Oracle 12 JDBC driver ojdbc7.jar

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.7.10
    • Component/s: None
    • Environment:
      Redhat Linux 7.4
    • Rank:
      0|i003tb:
    • Affects Database/s:
      Oracle

      Description

      Using Redhat Linux 7.4 with Oracle 12.1, attempting to run Ant in step 3.4.3 Create Crcdata Tables, from community install guide for i2b2.

      Command is: ant -v -f data_build.xml create_crcdata_tables_release_1-7

      When using JDBC Driver ojdbc14.jar, which is an older JDBC driver, I get the error: java.sql.sqlException ORA-28040: No matching authentication protocol. After googleing the error, it seems ojdbc14.jar is not compatible with oracle 12.

      So I downloaded ojdbc7.jar and modified data_build.xml to use ojdbc7.jar
      Then running ant command, same as above, I get the following error:
      Class Not Found: JDBC driver oracle.jdbc.driver.Oracle could not be loaded. Note: $CLASSPATH is not set. ojdbc7.jar is in same location as ojdbc14.jar.

      It seems ojdbc14.jar is not compatible with Oracle 12.1, but I do not understand why ojdbc7.jar is not being found. With the -v switch on the Ant command it shows the proper classpath to ojdbc7.jar. Any ideas? Thanks for the help.

        Attachments

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Git Source Code