Why These six jars are not needed for normal use of the JDBC driver, only for specific functionality. If any errors/problems arise when using this file, then use ojdbc6.jar (which also comes from the Oracle 11G Rel2 client) instead. Note that OJDBC7.jar will download all the dependent jar files such as osdtcore.jar, xdb6.jar, xmlparserv2.jar etc.If just using in-memory database (see below), the version used in maven actually doesnt matter. Since the version of Java DB comes with JDK 7 is 10.8.3.x, we also use 10.8.3.0 in our maven project. mvn install:install-file -Dfile/home/cm/Videos/ojdbc8. TIP: Assuming you have installed the Oracle 11G rel2 client in the default location, then you can find this (on the Controller application server) here: C:\app\Administrator\product\11.2.0\client_1\jdbc\lib Theres only one dependency needed to use Derby database. Since Oracle JDBC Driver is not in Maven repository, Download ojdbc8.jar and run the below command.Use the ojdbc5.jar file (which comes from the Oracle 11G Rel2 client), because this is the version that is most tested 'in the field'.
We will create a simple Employee management application which has abilities to create a new employee, update the existing employee, get a particular employee/ all. In this Spring CRUD Example, we will build a Simple Spring Application and perform CRUD operations using Spring JdbcTemplate. If using Oracle 11G R2 as your database server: Spring CRUD Example with JdbcTemplate + Maven + Oracle.
However, based on customer feedback, IBM Support recommends the following as a basic guideline:
At the time of writing (August 2016), the current latest version of Controller (10.2.1 FP4) supports Oracle 11G R1, Oracle 11G R2 and Oracle 12C R1.īecause of a high amount of compatibility (between different JAR files) it is likely that Controller would work OK with many different OJDBC files. First execution of this target will try to download from Maven publics repostories Oracle JDBC driver and Oracle-Lucene artifacts, this Mavens artifacts.Different versions of Controller support different versions of Oracle