Spring Boot Connect to Oracle Database Example

Learn how to write Java code that connects to Oracle Database Server in a Spring Boot application with two ways:
- Using JdbcTemplate and connect a local instance of Oracle database server
- Using Spring Data JPA with Hibernate framework and connect to a remote instance of Oracle database server.

You will also learn how to specify dependency for Oracle JDBC driver and configure data source properties (JDBC URL, username, password, show SQL, format SQL and database dialect).

Software programs:
- Java Development Kit (JDK)
- Spring Tool Suite IDE (STS)
- Oracle Express & SQL Developer tool

[arulprakasan]

Real Guru !! Fantastic example !! amazing video .. thanks alot for this hands on session !!

[ysc]

can you give us a example using Oracle's enterprise DB (not XE) to connect to spring boot. I have hard time if I had serviceName instead of SID

[HuongNguyen-slpw]

very helpful video!! thank you so much.

[cutenessoverloaded]

Thanks Brother. I tried various videos, but this helped me.

[LiMITZERO]

Very straight forward tutorial... new subs here.

[juanmanuelcataldopavan]

Hello! Thanks for this tutorial. I'm having an issue : when i run the java app, i dont have any query result. What could it be? The Database is OK, i can access through SQL Developer, created the table, populated too. Not getting any connection errors either. Thanks in advance.

[sukurumuku]

Thanks a lot for your excellent examples. I was wondering what is the difference between jpa repository and crudrepository. Please, keep your good work up!

[guitarDad]

This was a very good video. Thanks for sharing.

[saitarun]

Thanks for the tutorial it was very helpful.
I am able to connect to the DB, even though there is data in the table it's returning null values.
Any idea what's the reason?

[aruldaspaul]

Here you're fetching...like how to insert the record here??? Can anyone help me please

[indian-cricket-lover]

Nice work.

I am trying to use Spring Boot JPA and getting below error-
Failed to initialize JPA EntityManagerFactory: [PersistenceUnit: default] Unable to build Hibernate SessionFactory; nested exception is Cannot invoke "String.length()" because "str" is null

Any inputs on this issue?

[shubhamswaraj]

How can we set up oracle native encryption for spring boot application?

[MahadiHasan-qbzw]

can you please make some tutorial on making report like using BIRT report ?
or suggest any sources ? i really need help

[mukeshmahadev]

Would be helpful push to git and attach the link in description

[TheLEGOman]

Can we then use this to connect to a react.js frontend?

[anindyabasak]

It is saying Jdbc template is null..
Can you please help me on this?

[yesidcalle]

Excelente, unir listado ==> web with angular?

[BBonable]

could I have the GIT source of this tutorial? :D great video though! Thank you

[vadderamanjineyulu]

How to know my Local host number can plz tell me

[vehmszo]

I think this is nice tutorial, but it's so hard to understand you! PLEASE make english subtitles