In this quick tutorial, we show how to connect the Spring boot application with the Oracle database.
We assume that you have installed the Oracle database on your machine.
Steps to Connect Spring boot application to Oracle Database
Step1: Add Oracle JDBC Driver Dependency
Open your Spring boot application pom.xml file and add the below Oracle JDBC driver dependency in it:
<dependency>
<groupId>com.oracle.database.jdbc</groupId>
<artifactId>ojdbc8</artifactId>
<scope>runtime</scope>
</dependency>
Step 2: Connect to Oracle Database with Spring Data JPA
Let's add Spring Data JPA starter dependency to talk with the Oracle database. Open the pom.xml file and add the following dependency to it:
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>
Step 3: Configure Oracle Database in Spring Boot Application
Next, we need to configure Oracle database details in our Spring boot application. Open the application.properties file and add the following configuration to it:
# Datasource properties
spring.datasource.url=jdbc:oracle:thin:@localhost:1521:xe
spring.datasource.username=username
spring.datasource.password=password
# Hibernate properties
spring.jpa.hibernate.ddl-auto=update
spring.jpa.show-sql=true
spring.jpa.properties.hibernate.format_sql=true
spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.Oracle10gDialect
Here, the JDBC URL points to an instance of an Oracle database server running on localhost:spring.datasource.url=jdbc:oracle:thin:@localhost:1521:xe
Make sure that you have changed the database username and password as per your Oracle installation on your machine:
spring.datasource.username=username
spring.datasource.password=password
We have added Hibernate dialect for the Oracle database:
spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.Oracle10gDialect
Comments
Post a Comment