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

Ant not working with Oracle 12 JDBC driver ojdbc7.jar

    XMLWordPrintable

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • 1.7.10
    • None
    • Redhat Linux 7.4
    • Rank:
      0|i003tb:
    • 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

            mem61 Mike Mendis
            DonSteger Don Steger
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: