Integrate Oracle and Hibernate in a Spring Boot application

 Oracle and Hibernate in a Spring Boot application.

1. Add the following dependencies to your pom.xml file:

<dependency>
  <groupId>com.oracle.ojdbc</groupId>
  <artifactId>ojdbc8</artifactId>
  <version>19.7.0.0</version>
</dependency>

<dependency>
  <groupId>org.hibernate</groupId>
  <artifactId>hibernate-core</artifactId>
  <version>5.4.15.Final</version>
</dependency>

2. Create a properties file (application.properties) to configure the database connection:

spring.datasource.url=jdbc:oracle:thin:@host:port:sid
spring.datasource.username=username
spring.datasource.password=password
spring.datasource.driver-class-name=oracle.jdbc.OracleDriver

# Hibernate Configuration
spring.jpa.show-sql=true
spring.jpa.hibernate.dialect=org.hibernate.dialect.Oracle12cDialect
spring.jpa.hibernate.ddl-auto=update

3. Create a class that extends JpaRepository to interact with the database:

import org.springframework.data.jpa.repository.JpaRepository;

public interface UserRepository extends JpaRepository<User, Long> {
}

4. Create a model class to represent a table in the database:

import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;

@Entity
public class User {

  @Id
  @GeneratedValue(strategy = GenerationType.IDENTITY)
  private Long id;

  private String name;
  private String email;

  // getters and setters
}

5. Add a configuration class to enable JPA and Hibernate:

import org.springframework.boot.autoconfigure.domain.EntityScan;
import org.springframework.context.annotation.Configuration;
import org.springframework.data.jpa.repository.config.EnableJpaRepositories;

@Configuration
@EntityScan(basePackages = "com.example.model")
@EnableJpaRepositories(basePackages = "com.example.repository")
public class JpaConfig {
}

Now, you have successfully integrated Oracle and Hibernate in your Spring Boot application. You can now create, read, update, and delete data in your database using Hibernate and JPA.