Spring boot REST API with Oracle database
springboot
164
restapi
58
Oracle
11
Male avatar

loveprogramming viết ngày 11/05/2021

https://loizenai.com/spring-boot-rest-api-with-oracle-database/

Spring boot REST API with Oracle database

How to connect Oracle database with spring Boot? It is the one of most common questions for developers. So in the post "Spring boot REST API with Oracle database", I will help you to try it with Spring JPA. Here is a to do list for the tutorial:

  • Overview of Project Structure
  • Create SpringBoot with Spring Data JPA and Oracle dependencies
  • Configuration SpringBoot to connect to Oracle
  • Define a data model to map with table's columns in Oracle database
  • Define a JPA Repository to do CRUD operations
  • Use CommandLineRunner to excute above JPA Repository APIs: save, retrieve, update, detele entities

To do the tutorial, you need prepare Java >= 1.8, Spring Tool Suite in local computer for development.

Let's go !

SpringBoot Project Overview - Spring boot REST API with Oracle database

[caption id="attachment_56" align="alignnone" width="378"]Spring boot REST API with Oracle database-Overview-How-to-Integrate-Springboot-2.x-with-postgresql-using-Spring-JPA Project Overview How to Integrate Springboot 2.x with Oracle using Spring JPA[/caption]

In the SpringBoot application, we use Spring JPA to connect and manipulate the data between Application and Oracle database. We define a repository to do CRUD operations (save, retrieve, update, delete) with entities. And for mapping the data between Spring Application with database table's columns, we define a model class.

Create SpringBoot Project

We use Eclipse that had integrated with SpringToolSuite to create a SpringBoot project. Remember we need add 2 dependencies Spring Data JPA and Oracle driver.

Checking pom.xml file we see the needed dependencies as below:

<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>
<dependency>
        <groupId>org.Oracle</groupId>
        <artifactId>Oracle</artifactId>
        <scope>runtime</scope>      
</dependency>
<!-- Oracle Driver -->
<dependency>
    <groupId>com.oracle</groupId>
    <artifactId>ojdbc6</artifactId>
    <version>11.2.0.3</version>
</dependency>

https://loizenai.com/spring-boot-rest-api-with-oracle-database/

Spring boot REST API with Oracle database

Bình luận


White
{{ comment.user.name }}
Bỏ hay Hay
{{comment.like_count}}
Male avatar
{{ comment_error }}
Hủy
   

Hiển thị thử

Chỉnh sửa

Male avatar

loveprogramming

545 bài viết.
97 người follow
Kipalog
{{userFollowed ? 'Following' : 'Follow'}}
Cùng một tác giả
Male avatar
1 0
Tutorial Link: (Link) (Ảnh) Django is a Pythonbased free and opensource web framework that follows the modeltemplateview architectural pattern. A...
loveprogramming viết 9 tháng trước
1 0
Male avatar
1 0
https://loizenai.com/angular11nodejspostgresqlcrudexample/ Angular 11 Node.js PostgreSQL Crud Example (Ảnh) Tutorial: “Angular 11 Node.js Postg...
loveprogramming viết 7 tháng trước
1 0
Male avatar
1 0
Angular Spring Boot jwt Authentication Example Github https://loizenai.com/angularspringbootjwt/ (Ảnh) Tutorial: ” Angular Spring Boot jwt Authe...
loveprogramming viết 7 tháng trước
1 0
Bài viết liên quan
Male avatar
0 0
https://grokonez.com/frontend/angular/angular6/kotlinspringbootangular6crudhttpclientmysqlexamplespringdatajparestapisexample Kotlin Spring Boot +...
loveprogramming viết 4 tháng trước
0 0
{{like_count}}

kipalog

{{ comment_count }}

bình luận

{{liked ? "Đã kipalog" : "Kipalog"}}


Male avatar
{{userFollowed ? 'Following' : 'Follow'}}
545 bài viết.
97 người follow

 Đầu mục bài viết

Vẫn còn nữa! x

Kipalog vẫn còn rất nhiều bài viết hay và chủ đề thú vị chờ bạn khám phá!