Spring Boot Connect to MySQL Database Example

Learn how to configure a Spring Boot application to connect to MySQL database server in two kinds of applications:
- Spring Boot console program with JdbcTemplate
- Spring boot webapp with Spring Data JPA

How to configure Data Source Properties for a Spring Boot project?
- JDBC url, username & password
- JDBC Driver class name
- Database dialect class (Hibernate)
- Show & Format SQL statements (Hibernate)
- DDL Auto (Hibernate)

Software programs:
- Java Development Kit (JDK)
- Spring Tool Suite IDE (STS)
- MySQL Community server & MySQL Workbench

#springboot #mysql #java #jdbc #database #springframework #springdata

[vinaykumard]

Really, you have bright furture in kidding... ur cls helps me a lot pls give the methods of crud. tanx for giving gud stuff to us

[pratimmoulik]

I was finally able to execute a query statement in Java after watching this video.

[emilio]

Danke diesem Video schaffe ich die Matura👍🤴🏿

[aces]

thank you my brother from another mother

[jorgeepk]

Hello, it was going all good until 15:34. I don't understand from where you get those credentials! I guess that from your db, but I have tried it and for me doesn't work. Maybe are the fields of your table? My table has id, user and password. Thank you.

[tsvetanivanov]

is it possible to use that connection for a desktop app

[prashanthms]

how did ya create that table and schema in mysql work bench

[peaksjournals]

JdbcTemplate at 8:32 showing error ? Any solution

[reddyvlogs]

Do i have to do something on MySQL workbench before starting anything in SPRING BOOT APPLICATION??? coz i have done nothing in MySQL workbench before starting to do what you have said. I have just installed the MySQL Workbench & nothing else i have done in that. Do i have to do anything in that ???? Plz reply!!! Getting error after running the program, not getting "a new row has been inserted" what to do plz help!!!

[arwaalblooshi]

hello, thanks for the videos. very helpful.
i have a question: i have two tables in my database, i have a signup, login and welcome page and services page ( page that asks for additional information. )
one table store user details, email, firstname and lastname
and in the other table, logged in email gets save + additional information from services page.

now in the controller when i try to retrieve info from table2 based on logged in email, i get errors.

do u have a solution for that?

[padmak]

how will u get thet url to add in springboot application properties

[mansoorganie]

sorry sir, i tried many times, but i couldn't create tables inside database, when connect spring boot with MySql 😑😑

[nml]

Gave up after the first lesson. The next lesson had a lot of missing steps. The first one did too but was able to figure them out from past experience as little as that is. There's gotta be a better tutorial.

[padmesh]

Can you please upload a video on how to push fetched data to kafka

[NguyenVan-tdnh]

are you vietnamese sir??. your voice is like vietnamese

[sarangipradhan]

Not able to follow second part but good efforts.

[reddyvlogs]

Do i have to enter my actual Gmail Id there???

[berkaygungor]

Description:

Failed to configure a DataSource: no embedded datasource could be configured.

Reason: Failed to determine a suitable driver class

hello sir, what is the reason of this error? thx.

[maheshreddym]

I'm getting error can you please tell me how to fix it

Error starting ApplicationContext . To display the conditions report re-run your application with enable debug

[codemuni]

You didn't show the class configuration in web api lessons directly added some properties