JDBC Configuration For Oracle DB

Nadim Muhammad

Mar 02,2025 - 22:11

# JDBC Configuration
spring.datasource.url=jdbc:oracle:thin:@your-database-host:your-port:your-service-name
spring.datasource.username=your-username
spring.datasource.password=your-password
spring.datasource.driver-class-name=oracle.jdbc.OracleDriver
spring.datasource.hikari.maximum-pool-size=10  # Optional, to set the connection pool size
spring.datasource.hikari.minimum-idle=5  # Optional, to set the minimum idle connections
spring.datasource.hikari.idle-timeout=30000  # Optional, set timeout for idle connections in milliseconds

# JPA / Hibernate Configuration (optional, if you are using JPA)
spring.jpa.hibernate.ddl-auto=update  # Optional, to define Hibernate behavior
spring.jpa.show-sql=true  # Optional, to log SQL queries
spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.Oracle12cDialect  # Dialect for Oracle DB

# Additional optional configuration
spring.datasource.initialization-mode=always  # Optional, to always initialize the database schema at startup

Explanation of key properties:

1. spring.datasource.url: The JDBC URL for the Oracle database. Replace your-database-host, your-port, and your-service-name with the actual database details.

   • Example: jdbc:oracle:thin:@localhost:1521:XE (for an Oracle DB on your local machine with the XE service name).

2. spring.datasource.username: The username to connect to the Oracle DB.

3. spring.datasource.password: The password for the provided username.

4. spring.datasource.driver-class-name: The Oracle JDBC driver class.

5. spring.datasource.hikari.maximum-pool-size: The maximum number of connections in the connection pool (you can configure this as needed).

6. spring.datasource.hikari.minimum-idle: The minimum number of idle connections in the pool (configurable).

7. spring.jpa.hibernate.ddl-auto: Configures how Hibernate handles database schema updates. You can use options like none, update, create, or create-drop.

8. spring.jpa.properties.hibernate.dialect: Defines the Hibernate dialect for Oracle. In this case, Oracle12cDialect is used.

9. spring.jpa.show-sql: Enables the logging of SQL queries.

10. spring.datasource.initialization-mode: Configures whether the schema should be initialized when the application starts.

11. <dependency>
        <groupId>com.oracle.database.jdbc</groupId>
        <artifactId>ojdbc8</artifactId>
        <version>19.8.0.0</version>  <!-- Use appropriate version -->
    </dependency>

12. implementation 'com.oracle.database.jdbc:ojdbc8:19.8.0.0'  // Use appropriate version