How to connect to oracle database using spring boot

Question

I'm working with Spring Boot application and trying to access an Oracle database. Although it was successfully built, it gives the error below when I am trying to deploy in Kubernetes.

I changed the application.properties file and pom.xml file with below configurations:

application.properties

spring.datasource.url=jdbc:oracle:thin:@<IP>:1521:orcl
spring.datasource.username=<username>
spring.datasource.password=<password>
spring.datasource.driver.class=oracle.jdbc.driver.OracleDriver

POM file

 <dependency>
     <groupId>org.springframework.boot</groupId>
     <artifactId>spring-boot-starter-jdbc</artifactId>
 </dependency>

Exception

***************************
APPLICATION FAILED TO START
***************************
 Description:
 Failed to bind properties under '' to com.zaxxer.hikari.HikariDataSource:
     Property: driverclassname
    Value: oracle.jdbc.OracleDriver
    Origin: "driverClassName" from property source "source"
    Reason: Failed to load driver class oracle.jdbc.OracleDriver in either of 
            HikariConfig class loader or Thread context classloader
 Action:
 Update your application's configuration

Check my answer on spring.datasource.driver.class=oracle.jdbc.driver.OracleDriver it should be driver.class-name — smilyface
– smilyface, Commented Jan 23, 2019 at 6:43
@Dhanushka - If the issue fixed, please select correct answer. It might be useful for others. Cheers — smilyface
– smilyface, Commented May 20, 2019 at 5:28

President James K. Polk · Accepted Answer · 2025-07-12 19:32:10Z

9

Maven dependency:

<dependency>
    <groupId>com.oracle</groupId>
    <artifactId>ojdbc7</artifactId>
    <version>12.1.0</version>
</dependency>

application.properties file:

# Oracle settings
spring.datasource.url=jdbc:oracle:thin:@localhost:1521:xe
spring.datasource.username=system
spring.datasource.password=password
spring.datasource.driver.class-name=oracle.jdbc.OracleDriver

Note: driver.class-name

Sometimes you may need to add

spring.jpa.database-platform=org.hibernate.dialect.Oracle10gDialect

to application.properties file (for Oracle 10).

edited Jul 12 at 19:32

President James K. Polk

42.3k34 gold badges113 silver badges149 bronze badges

answered Jan 22, 2019 at 9:54

smilyface

5,56111 gold badges44 silver badges60 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

agilgur5 · Accepted Answer · 2025-07-14 01:12:28Z

5

Add below dependency and repository in the pom.xml:

    <dependency>
        <groupId>com.oracle</groupId>
        <artifactId>ojdbc6</artifactId>
        <version>11.2.0.3</version>
    </dependency>
    
    <repositories>
        <repository>
            <id>codelds</id>
            <url>https://code.lds.org/nexus/content/groups/main-repo</url>
        </repository>
    </repositories>

Also add the following properties in the application.properties:

spring.datasource.driver-class-name=oracle.jdbc.driver.OracleDriver
spring.datasource.url=jdbc:oracle:thin:@localhost:1521:xe(SID)
spring.datasource.username=system
spring.datasource.password=pw

edited Jul 14 at 1:12

agilgur5

2,0925 gold badges50 silver badges71 bronze badges

answered Aug 13, 2019 at 10:23

Abdullah Imran

3998 silver badges17 bronze badges

Comments

Soumen Mukherjee · Accepted Answer · 2019-10-23 18:12:19Z

1

Update the db driver in the file Application.yml to

spring.datasource.driver-class-name=oracle.jdbc.**driver**.OracleDriver or spring.datasource.driver-class-name=oracle.jdbc.OracleDriver

edited Oct 23, 2019 at 18:12

Soumen Mukherjee

3,3023 gold badges26 silver badges37 bronze badges

answered Oct 23, 2019 at 16:16

user12264329

111 bronze badge

3 Comments

user12264329 Over a year ago

Another inconsistency? spring.datasource.driver.class-name v/s spring.datasource.driver-class-name

mypetlion Over a year ago

Requests for clarification or further information from OP should go in a comment, not an answer. Please only post an answer if it actually answers the question.

user12264329 Over a year ago

By the way, I found the answers to my questions:use spring.datasource.driver-class-name=oracle.jdbc.OracleDriver for >Oracle 9i (no driver needed) However, if I unpack the ojdbc6.jar I see both classes there. And the correct attribute to use is spring.datasource.driver-class-name

agilgur5 · Accepted Answer · 2025-07-13 06:12:24Z

1

I used implementation 'com.oracle:ojdbc7:12.1.0.2.0 gradle dependency.

Added below in the application.properties:

# hibernate configs
spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.Oracle10gDialect

# database details
spring.datasource.url=jdbc:oracle:thin:@//<host>:<port>/<database>
spring.datasource.username=<username>
spring.datasource.password=<password>
spring.datasource.driver.class-name=oracle.jdbc.OracleDriver

You can use different OracleDialect if it's not working for you.

For me above code is working without any issue.

edited Jul 13 at 6:12

agilgur5

2,0925 gold badges50 silver badges71 bronze badges

answered Nov 27, 2023 at 9:15

Shrip

1912 silver badges8 bronze badges

Comments

Nirmala · Accepted Answer · 2019-01-23 01:17:58Z

0

You can check if the SpringBoot app example helps.

answered Jan 23, 2019 at 1:17

Nirmala

1,3521 gold badge10 silver badges12 bronze badges

Comments

agilgur5 · Accepted Answer · 2025-07-13 06:51:50Z

0

You just need to add these two dependencies in your pom.xml file and it will work fine:

<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>

<dependency>
    <groupId>com.oracle.database.jdbc</groupId>
    <artifactId>ojdbc8</artifactId>
    <scope>runtime</scope>
</dependency>

edited Jul 13 at 6:51

agilgur5

2,0925 gold badges50 silver badges71 bronze badges

answered Jun 13, 2022 at 4:47

priyansh490

13 bronze badges

Comments

Rohit Gupta · Accepted Answer · 2025-07-14 03:24:37Z

0

Use this configuration in application.properties:

spring.jpa.show-sql=true

spring.h2.console.enabled=true
    
# Using SID
spring.datasource.url= jdbc:oracle:thin:@localhost:1521:ORCL
spring.datasource.username=SYSTEM   
spring.datasource.password=SYSTEM
spring.datasource.driver-class-name=oracle.jdbc.OracleDriver
    
# hibernate configs
spring.jpa.database-platform=org.hibernate.dialect.OracleDialect
spring.jpa.hibernate.ddl-auto=update

Caution:

org.hibernate.dialect.Oracle10gDialect has been deprecated.
You need to check jdbc:oracle:thin:@localhost:1521:ORCL if the last part of this database URL is "ORCL" OR "XE". See below screenshot:

edited Jul 14 at 3:24

Rohit Gupta

4,27723 gold badges36 silver badges47 bronze badges

answered Dec 22, 2022 at 13:56

Amit Kumar Tiwari

31 silver badge7 bronze badges

Comments

Ritunjay kumar · Accepted Answer · 2025-07-27 04:53:33Z

0

For Oracle DB,

Maven settings:

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

Properties settings:

spring.datasource.url=jdbc:oracle:thin:@172.16.10.12:1521/orcl11
spring.datasource.username=[username]
spring.datasource.password=[password]

Don't use

spring.datasource.driver-class-name=oracle.jdbc.OracleDriver

edited Jul 27 at 4:53

answered Nov 12, 2021 at 11:25

Ritunjay kumar

4756 silver badges11 bronze badges

Comments

apramit roy · Accepted Answer · 2025-07-27 06:47:35Z

0

You can use the Connection class in SpringBoot to establish Connection, also make sure that the port id, is correct, it will ease a lot of hardwork.

answered Jul 27 at 6:47

apramit roy

111 bronze badge

1 Comment

Jeremy Caney Jul 27 at 7:20

Thank you for your interest in contributing to the Stack Overflow community. This question already has a few answers—including at least one that has been validated by the community. It would be useful to explain how your approach is different, under what circumstances your approach might be preferred, and/or why you think the previous answers aren’t sufficient. Can you kindly edit your answer to offer an explanation?

Darshan Mehta · Accepted Answer · 2019-01-22 09:47:12Z

-1

You need to download Oracle JDBC driver jar file and add it into your classpath in order for your application to load oracle.jdbc.OracleDriver class.

Driver can be downloaded from here.

answered Jan 22, 2019 at 9:47

Darshan Mehta

31k14 gold badges75 silver badges111 bronze badges

2 Comments

Dhanushka Sampath Over a year ago

I already tried it in InteliJ. It successfully build it in IDE. But when I try to deploy it in kubernetes, it gives the error. please help

Darshan Mehta Over a year ago

Are you creating a fat jar? If yes then you can include driver jar explicitly.

Collectives™ on Stack Overflow

How to connect to oracle database using spring boot

10 Answers 10

Comments

Comments

3 Comments

Comments

Comments

Comments

Comments

Comments

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

10 Answers 10

Comments

Comments

3 Comments

Comments

Comments

Comments

Comments

Comments

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related