[CORE-284] Ant not working with Oracle 12 JDBC driver ojdbc7.jar Created: 29/Dec/17 Updated: 25/Apr/18 Resolved: 29/Jan/18 |
|
| Status: | Resolved |
| Project: | i2b2 Core Software |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | 1.7.10 |
| Type: | Bug | Priority: | Major |
| Reporter: | Don Steger | Assignee: | Mike Mendis |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | JDBC-driver, wikirelease | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Environment: | Redhat Linux 7.4 | ||
| Rank: | 0|i003tb: |
| Affects Database/s: |
Oracle
|
| Participant/s: |
| 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. |
| Comments |
| Comment by Mike Mendis [ 29/Jan/18 ] |
| The JDBC drivers have been updated for Oracle to ojdbc8 (jdk 8) and sql server 6.2.2 also jdk 8 |