Using Oracle with Spring Boot

oracleJDBCSetup

If you do not have an oracle driver do steps 1 and 2 first.  Otherwise skip to step 3.

1) Download the jdbc driver from oracle.

2) Install the driver into your local maven .m2 repository. Example:

mvn install:install-file -DgroupId=com.oracle -DartifactId=ojdbc6 -Dversion=11.2.0.4 -Dpackaging=jar -Dfile=ojdbc6.jar -DgeneratePom=true

In the above example the ojdbc6.jar version 11.2.0.4 is used.  Replace the -DartifactId=ojdbc6 -Dversion=11.2.0.4 and -Dfile=ojdbc6.jar with the driver name/version you downloaded.

3) Add the dependency to your build.gradle file. Example:
dependencies {
    ...
    runtime("com.oracle:ojdbc6:11.2.0.4")
    ...
}

replace driver name and version with the one you downloaded

4) In spring boot add/modify the application.properties file to use your db url, username and password.  Example:

spring.datasource.driverClassName=oracle.jdbc.driver.OracleDriver
spring.datasource.url=jdbc:oracle:thin:@127.0.0.1:1521:orcl


spring.datasource.username=username
spring.datasource.password=secret

Hi, Monica!
I'm hitting an issue I can't find a solution for. Any chance you have some insights? Any help will be appreciated.
I'm sure this is a silly configuration issue as I'm just starting to learn Spring...
Anyways, I created a gist, if you'd be so kind as to take a look.
C ya