Posted: 19 May 2018 1:34 EDT Last activity: 19 Mar 2019 1:55 EDT
Version of JDBC driver with Oracle
In our project we use Pega 7.3.1 on Oracle 11g database, Tomcat 8.5, and JDK 8. Which JDBC driver should we be using, ojdbc6.jar or ojdbc7.jar? Or does it even matter?
Oracle 11g database product comes with ojdbc6.jar. I don't think ojdbc7.jar was even developed when 11g was released, so I am not sure if Oracle 11g is compatible with this version. However, according to the platform support guide, it seems like ojdbc7.jar had better be used for Java 8. I don't know if we should go for ojdbc7.jar based on Java version, or ojdbc6.jar based on Oracle release period. Please give me some guidance.