Db configuration in application.properies file | JPA with Spring Boot | Spring boot tutorial

[@aishwaryadwani9365]

The reason spring boot framework is used because it saves much time and developer efforts , on the top of that you are using IDE's intellisense feature which means now you don't have to write even a single line as a whole. If we were capable of understanding at such speed then why we were here ?. Please try to cover broad topics also so that newbies know why and how things are working behind the scenes. Dileact ? Crud Repository ? Why that generic is used ?.

[@RupeshSaxena]

you only focus on writing business logic, is what the intentions of Spring Boot framework developers wanted to solve..

[@KejriwalBhakt]

Bhai tu khud ki videos ke neeche ke comments dekhta hai kya? 2 saal se bando ko error aa rakka hai and you haven't replied them. I thought of going for your paid course but bhai tu bass ek baar vdeo bana karr choor deta hai... Last 3 hours se ek hi error parr hoon jo common error hai bando ki comment section mein.

[@aniketvitekar1221]

The method save(S) in the type CrudRepository is not applicable for the arguments (User)

[@vinaykaple1663]

Yaar Durgesh bhai, ek no. padhate ho aap!!

[@sagarray283]

Spring Boot + Snowflake DB ka bhi playlist bnaiye sir....

[@Anshika0326]

Thanks, sir. Today I am learn 100% about JPA because of You.

[@Dhiraj-nd9vy]

thora english bhi sikh lijie sir

[@rahul-java-dev]

G Sir..bahut achhe se smjh aa rhi h. Thank u so much. Spring boot me security bata dijiyega Sir ji

[@sameerkadam4830]

User Entity class me each name and city ko column name and class name ko table name diye bina kaise kaam kiya?

[@eshankyadav2354]

Sad to see, such a knowledgeable video but has only 249 likes

[@bobyburman6763]

For Exception: "Bean not available" --> create only one package and put all the classes(pojo, main) and interface(UserRepository) inside that package (Forget about loose coupling for a bit and do that ). Update ur project and restart it again..try it

[@rohanmohite8741]

yes it's working Thanks.

[@rohanmohite8741]

i got this Exception.

[@vinaykumard1386]

Tanx a lot man ..i resolved my issue ...tq a lot

[@vasusrivastav]

Thanks bro

[@siddharthsahu8763]

for loose coupling how to do?

[@therandomchannel02]

"The method save(User) is undefined for the type UserRepository" this error comes at 6:38

[@Ashish.YouTube.]

userRepository (small 'u' . Method ko reference variable ke through access karo bhai.)

[@Kritida]

Hi, Amazing, your video is really helping me in our project. How do I utilize my existing database and table in sql server. Can you please create a video on that too. I've my project in jsp+servlet and now converting them to spring boot, so, I've my existing database, how can I utilize it.

[@parasbillore]

Use {jakarta.persistence}. "the javax namespace changed to jakarta for frameworks whose APIs have moved to Jakarta EE"

[@tabishquadri]

"user" is a reserved keyword in postgresql. Change your table name to something else

[@aaqibperwez6761]

Sir please tell us how to create test database in MySQL

[@akankshajain5978]

Write a query Create database test And execute it

[@ashishdevnani]

ensure that you are in correct user of mysql and fire the command create database test

[@sakshammishra2456]

the method setcity is undefined for the type security.properties Any solution? Please help!

[@kanchandeshmukh7131]

What is ctrl shift for dialect

[@nishcurse69]

what is the solution for this error please help The method setCity(String) is undefined for the type SecurityProperties.User The method setStatus(String) is undefined for the type SecurityProperties.User

[@megalifehack143]

Same problem

[@megalifehack143]

Bhai Jo package user ka hai use hata do uski jagah Import com.jpa.test.entities.User Lagao sahi ho jayega

[@utkarshsinghrajput4522]

​@@megalifehack143nhi ho rha bhai

[@JayeshMali-er1yo]

hello sir how to add php database to spring bootapp and sir there issue to source path how to solve error is "Failed to configure a DataSource: 'url' attribute is not specified and no embedded datasource could be configured. Reason: Failed to determine a suitable driver class".

[@UPlusPlus]

How to use jpa in mvc web app?

[@shankarraj3606]

Hi, This video is nice but the "url' attribute is not specified and no embedded datasource could be configured ". tried all of the steps, None of them works, Is there anything you can do

[@anuraaagistan5173]

How to resolve this?

[@ajcoders6748]

Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near "user" Position: 13 I am using postgresql

[@atharvsingh6901]

bro guarranted solution for postgresql db. just go via this stackoverflow link below try to change user table name with @table , as user is reserved key in postgres stackoverflow.com/questions/40399460/psqlexception-error-syntax-error-at-or-near/40399758

[@mohitpatil5673]

@@atharvsingh6901 nhi hua yar

[@atharvsingh6901]

@@mohitpatil5673 bro User table ka naam change kardo using @Table(name="user_details") bcz User name is a reserved keyword in postgresql. i spent a whole day resolving this issue

[@bainapalliakash7039]

@@atharvsingh6901 thanks bro

[@atharvsingh6901]

@@bainapalliakash7039 you are welcome bro

[@akankshajain5978]

My table is not created in mysql

[@KhushbooDailyVlogs0506]

I am getting error: org.springframework.beans.factory.NoSuchBeanDefinitionException: No qualifying bean of type. please help! I have coded exactly same step by step as shown in the video.

[@piyushmathpal4244]

hey did you find any solution to this?

[@raushankr1156]

@LearnCodeWithDurgesh sir, It's a common error being thrown and being faced. No solution was found after trying a lot.

[@ganeshkokate5555]

@@piyushmathpal4244 did you get solutions i also tried with @Repository on my interface

[@mdimtiyaz2013]

Description: Failed to configure a DataSource: 'url' attribute is not specified and no embedded datasource could be configured. getting this error

[@sagarpund6042]

Same Error ...

[@PunjabiBoyz]

Getting this error Description: Failed to configure a DataSource: 'url' attribute is not specified and no embedded datasource could be configured. Reason: Failed to determine a suitable driver class tried everything from google , stackoverflow, quora etc but problem remained same

[@saurabhkumarjha2370]

got any solution for this error?

[@saurabhkumarjha2370]

Try this configuration spring.datasource.url=jdbc:mysql://localhost:3306/dbName spring.datasource.driverClassName=com.mysql.cj.jdbc.Driver spring.datasource.username= spring.datasource.password= spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.MySQL8Dialect spring.datasource.initialization-mode=always spring.jpa.defer-datasource-initialization= true spring.sql.console.enabled=true spring.jpa.hibernate.ddl-auto=update

[@paragnaik5097]

same error

[@saurabhkumarjha2370]

​@@paragnaik5097 do try above configuration

[@paragnaik5097]

@@saurabhkumarjha2370 didn't work, tried all the stackoverflow suggestion

[@codingstudy786]

Sir I have mysqlDialect problem. I have tried many time but I can't resolve this problem.

[@poojarath7087]

i was facing same issue .. Now i m using spring.hibernate.dialect=org.hibernate.dialect.MySQLDialect spring.jpa.hibernate.ddl-auto=update in Application.Properties file and the issue solved .. i m able to get data in table

[@sagarsoni1983]

@@poojarath7087 ty

[@FAITH__2025]

Getting error .... Exception in thread main no qualifying bean ..... Please help to resolve.

[@Vinu-Arts]

thank you so much sir..........

[@anirbanmanna2897]

Solution of etting error in user.setCity and user.setStaus etc :- ------------------------------------------------------------------------------------------------ delete all other import of 'User' and include the below one import com.example.demo.entity.User; // or your own entity user class

[@skdp3292]

bro help me getting same problem still didn't getting

[@akshayparsade9678]

sir, i am getting this error nd i import it in user but error not gone, help me

[@anirbanmanna2897]

@@akshayparsade9678 first import your own User class, not any predefined User class

[@akshayparsade9678]

@@anirbanmanna2897 yes i import my own user, nd deleted all this @Entity @Id @GeneratedValue import but error comes again in it.

[@sanamsahu9836]

@@akshayparsade9678 have you resolved that problem im getting the same problem

[@ishitakundu8129]

I am getting driver class name not found instead of implementing every steps. How to resolve this sir?

[@shubhi2648]

In UserRepository we have not added any @component, any @Repository etc.. how it's bean is getting created ? Pls help sir.

[@shubhamsinghal3326]

we dont need to add @controller and @repository all objects are created by main class which are within the package

[@arnabsarkar2224]

@@shubhamsinghal3326 giving me an error in the UserRepository line

[@skdp3292]

Hi ..when I am going for user.setCity there is no option Comming for city name what should i do

[@O_c.478]

check that you mention the String city as a field in the entity class or generate a getter setter of it !!

[@prashantrai7047]

Sir auto suggestion is not working in sts (only when writing code in application.properties file).I have tried many solutions but none of them worked for me.please if have some solution regarding this then tell me... thanks 🙏

[@shqnz]

Add required plugins

[@jaysoni6292]

Sir how to find MySQL Dialect class in visual studio code ......

[@muskanjain1413]

Do you know now???

[@muskanjain1413]

If yes, then please tell

[@madhumatiswami3446]

Hi Durgesh sir, I am getting APPLICATION FAILED TO START *************************** Description: Failed to configure a DataSource: 'url' attribute is not specified and no embedded datasource could be configured. Reason: Failed to determine a suitable driver class Action: Consider the following: If you want an embedded database (H2, HSQL or Derby), please put it on the classpath. If you have database settings to be loaded from a particular profile you may need to activate it (no profiles are currently active). this error.(added correct properties in application.properties file ) but still I am facing this issue . Please, help me 🙏 to solve this error .

[@saurabhmishra6893]

Hii brother, I fixed the issue

[@ece03abhisheksrivastava64]

Got error Error creating bean with name 'entityManagerFactory' defined in class path resource [org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaConfiguration.class]: Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment] due to: Unable to resolve name [org.hibernate.dialect.MySQL5Dialect] as strategy [org.hibernate.dialect.Dialect] Solution : Remove that dialect property ( Using spring 3.2.2 )

[@prasad2136]

thanks man

[@mogamboo_vlog]

Your solution is very helpful ❤

[@raghubansal4143]

Where is solution?

[@IsitaGhosh-e2j]

I am getting user_seq table alongside with user table in DB

[@poojarath7087]

yes , this is correct , because we are using Id to be auto generated

[@sachinKumar-hu9gj]

Sir jldi jldi videos laao sir Spring BOOT p

[@ViditChandraMathur]

try to use else User name class

[@kanishkawadhwani7485]

How to know dialect of my sql ?

[@poojarath7087]

for me org.hibernate.dialect.MySQLDialect is working fine

[@IsitaGhosh-e2j]

How to use auto complete in application.properties file?

[@laflame1896]

CTRL+Space

[@shwetasinha2482]

Facing the issue "no qualifying bean of type User Repository" available.. Please help.. I have spent hours figuring this out.. P. S I HAVE ALREADY TRIED BY KEEPING THE POJO, DAO AND MAIN CLASS IN SAME PACKAGE.. IT DIDN'T WORK

[@akritimishra4971]

hii..i am also facing the same error ? have u got the sol?

[@ABHISHEKSHARMABCE-cv1kr]

@@akritimishra4971 did anyone get the solution to this problem?

[@DeepakYadav-hv8ln]

have you got the solution? i am also facing same problem.

[@saurabh7nt]

@@DeepakYadav-hv8ln anyone got the solution????????

[@DeepakYadav-hv8ln]

Just update the project and restart sts

[@himanshujain_2817]

@6.00 i m getting error in user.setCity and user.setStaus. I only get recommendation of user.setName..........plz reply(anyone...)

[@anirbanmanna2897]

same here

[@anirbanmanna2897]

delete all other import of 'User' and include the below one import com.example.demo.entity.User;

[@himanshujain_2817]

@@anirbanmanna2897 thanks man👍👍

[@skdp3292]

@@anirbanmanna2897 this i have to do in user class na

[@skdp3292]

@@anirbanmanna2897 thanks bro solved..What you have suggested ..We have to do it in main() method class..without deleting any import packages

[@PRISOM1988]

Good Video

[@tanmaysenapati1328]

MySQL57Dialect and MySQL8Dialect are depricated so what to use??

[@Prince-sq7ro]

use MYSQLDialect instead

[@shyamkumarrana5856]

Sir payment gateway ka tutorial dijye java par

[@majidasgharofficial]

Please make video on Spring microservices.

[@shubhamtiwari-oz1dz]

ctrl+ shift and ??????

[@rashid7449]

t

[@lakshaykumar8691]

From where and how to download SQL yog??

[@dixitnadda3380]

Solution for BeanCreation Exception: When we copy paste dialect , in properties file , remove ~package~ keyword and only use package name . Save And run..

[@aquibali6798]

Great experience learning

[@adityajaiswal5603]

good

[@RajaRaj-du6zm]

Nice explanation

[@supriyaargade8991]

Hellosir,I have followed all steps, table is created in database but data was not inserted... could you please suggest any solution for this

[@muskanjain1413]

Same problm

[@allunique9171]

Same problem

[@sagarpund6042]

Failed to configure a DataSource: 'url' attribute is not specified and no embedded datasource could be configured...

[@viswanadhuvaddadi1863]

How will we know which SQL dialect version we have to use?

[@aniketjha7606]

That depends on which version of Sql you are using. As I have mysql 8.0.31 version I will use MySql8Dialect.

[@ashishdevnani]

​@@aniketjha7606 Yes. org.hibernate.dialect.MySQL8Dialect is correct for the above version. i too have MySQL8 and the version you mentioned works for me.

[@afrida6672]

i will subscribe you if you answer my question?. my question my sql data base stored and how to set my sql work bench part is not underrstood.

[@271000abhi1]

I am getting ": CLIENT_PLUGIN_AUTH is required" error while running the program. I have been following your tutorials of Spring core, Spring MVC and now Spring boot. But there i am facing this error. Please try to help me out.

[@O_c.478]

For databases above 5.1, running the FLUSH HOSTS command may help monitoring to be re-established.

[@abhishekkuwar1119]

My question is that You didn't pass the id so how did it show inside the table??

[@Deep_Aman]

it's using auto-generated value for id. given by the annotation.

[@abhishekkuwar1119]

@@Deep_Aman Thanks for reply to me,,, later that que i read about it on web then realised that there are several strategies to create id in the table. Spring boot really is a powerful framework. Thanks again

[@utkarshnamdev441]

sir please tell how to create test in mysql workbench and how to connect sts and workbench

[@MOHAMMADSAIF-lv2yy]

bhai pta chala kya kaise krte hai ?agar ha to tu hi bta de 2 saal ho gye.. mereko nhi pta

[@ashfak6801]

hello sir plz ans my question how do u directly call this user repository.class inside of getbean method , even if this is interface and u r not @Autowired any where

[@O_c.478]

brother beacuse he makes the object of repo interface in class

[@sachinKumar-hu9gj]

Sir jobs k liye bhi kuch daal do job kaise dhundee aur aapne kaise job Search ki thi

[@shriramkulkarni9756]

can anyone plss how can i see my my hybernate dialect version in my sts pls what should i type in class sir talked that fast crtl+shift +what plss tell me

[@gourvigupta4991]

Ctrl+shift+T

[@co_pratikshaahire9841]

User user1=UserRepo.save(userm); Ihave Error this line "Cannot make a static reference to the non-static method save(User) from the type CrudRepository" please help me

[@poojarath7087]

Anywhere u have used static key word ?

[@mayankaggarwal4045]

Hi, I am facing problem while configuring "org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'userRepository' defined in com.jpa.test.dao.UserRepository defined in @EnableJpaRepositories declared on BootJpaExampleApplication: Not a managed type: class com.jpa.test.entities.User". Please help me to continue further

[@aryanV10G]

i am facing same problem . please help

[@sunnyd9878]

Just awesome

[@anurag9110]

Nice video 👍. How can we store database password in production?

[@RupeshSaxena]

use password hashing and salting

[@PriyeshGupta-s3m]

pleased any one know how to solve jni exception pls help me...

[@souravmahinia9174]

good but sir code ka link v post kr dete

[@gajju652]

why you have written '.class' in the code : context.getBean(UserRepo.class) ??? because UserRepo is interface not a class time : 5:50

[@Venus.D]

I'm getting communication link failed error....please help!

[@BharatReacts229]

Error gya ya nhi

[@samarpitgupta8000]

how did you resolve it ?

[@aqibishaq885]

sir g rest controller annotations laye aur spring boot ki baki annotations lao

[@mukeshkumar-sc7bk]

Thank you sir

[@amanmahour6542]

Sir kisi bhi java file mei akar ctrl shift ke baad konsi key press krni h samajh ni ahh rha...

[@neerajverma942]

you can press these with together then you will get MySQL dilect: ctrl+shift+T

[@akshayshahasane7290]

​@@neerajverma942 For intellij??

[@brtechvlogs2657]

How to connect with db?

[@anuragarora2960]

Ye Id 5 kyun ha 1 se shru nhi hoga ?

[@AbdulRahaman-zl8gv]

Thanks bro

[@debasisjena1210]

awesome

[@CreativeSamCS]

My database is not showing in workbench Reason??

[@567qbb]

same problem..can u help me?

[@akshayshahasane7290]

​@@567qbb Same problem

[@prashantpuse6934]

Kam se kam 20 munits ka video banaiye sir

[@aarifislam9956]

when executing the code the table is getting created as expected and data is also getting stored in the table but one other table is getting created named user_seq with a single column next_val can anyone let me know why is it happening

[@poojarath7087]

Yes , this is because we are making Id column as Auto generate , so , Fisrt hibernate is generating Sequence table in DB and than updating User Table

[@GautamKumar-yv7li]

when i run this program it show error org.hibernate.exception.GenericJDBCException: Unable to open JDBC Connection for DDL execution its show sql error also please tell me what to do without this program we can't perfor crud operation

[@atharvsingh6901]

bro guarranted solution for postgresql db. just go via this stackoverflow link below try change user table name via @table stackoverflow.com/questions/40399460/psqlexception-error-syntax-error-at-or-near/40399758

[@abhijeetbasfore6816]

@@atharvsingh6901 thank you so much brother

[@noushadkhan360]

Would you please tell us the solution

[@anjeel1772]

4:07 -> ctrl + shift + p is not working in mac any alternative for mac ?

[@comedybro716]

ctrl+shift+t

[@yashvardhan786]

@@comedybro716 no it's wrong

[@sheetallarya]

Command+ shift + T

[@aj11anuj]

@@sheetallarya I'm using vs code and it's not working

[@SachinKumar-hw5gc]

Table is created in database but the data not interested

[@pankajpandey1862]

u got it solved ?? what was the error ?? same issue mine !!

[@Santoshkumar-bp2up]

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'userRepo' defined in com.jpa.test.dao.UserRepo defined in @EnableJpaRepositories declared on JpaRepositoriesRegistrar.EnableJpaRepositoriesConfiguration: Invocation of init method failed; nested exception is java.lang.IllegalArgumentException: Not a managed type: class com.jpa.entities.User getting this error...any solution plz..

[@shqnz]

not a managed type meant that either you have not declared your Entity as entity using annotation (@entity) or you have not added type generics to the CRUDRepository interface( it should be extended as public YourRepository extends CRUDRepository ) ---> here entity type is a type of your entity you want to do crud operations on. Ex : Student or User etc if its still not working, then let spring boot scan the entity package by using @componentscan(basePackages="com.entities")

[@Deepaksahu-zv3du]

Error creating bean with name 'entitymanagerfactory'

[@amitraaz7231]

Solution mila bhai?

[@pratibhadhekale2163]

Plz tell me ...I also found same eri

[@pratibhadhekale2163]

@@amitraaz7231 plz tell me I have also found same error

[@seetesmallik5830]

🔥

[@shubhamjaiswal3743]

I am facing issue"No qualifying bean of type UserRepo available.

[@shubhamjaiswal3743]

Please help me to sort out this problem

[@pragatikamble9584]

Check where is your main application. That should be in the root package

[@kvnagendra5354]

I've followed the same steps but it showing dialect error

[@O_c.478]

you can also use h2 database instead of using mySql

[@aqibishaq885]

Sir userrepository aik interface ha iska object kasa ban ra aur hama kasa mil ra help help help

[@LearnCodeWithDurgesh]

Implementation claass ka object bantna

[@akritimishra4971]

@@LearnCodeWithDurgesh sir still i have not understood how getBean is used with interface "UserRepository".Kindly explain it.

[@factoffacts4500]

@@akritimishra4971 give package name like this com.jpa.test com.jpa.test.dao com.jpa.test.entities

[@prisinha]

4:00 dialect

[@sonalichatterjee4610]

Some video are very improper😢😢😢...

[@eset7708]

10:46

[@prisinha]

1:18 voice disappeared

[@AjayKumar-fm7oh]

BIG RED FLAG It is not recommended for Beginners.

[@tuhinjana9853]

The method setCity(String) is undefined for the type Security properties.User I got the error for setCity and setStatus can anybody help me Also can anybody tell in com.jpa.test which packages are imported?

[@shubhamrasal388]

check import class name i also got same error but now resolved

[@mohitpatil5673]

please help

[@sayakbanerjee9990]

if you are getting errors still like file not found or shutdown @EnableJpaRepositories("com.jpa.test.dao") @EntityScan("com.jpa.test.entities") use this in the main file and also in dialect the dialect is- spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.MySQLDialect now the version needn't be given anymore

[@yashvardhan786]

ctrl+shift+what?

[@soldierbuoy4292]

T

[@rajpervi]

received below error Error creating bean with name 'userRepository' defined in com.jpa.test.dao.UserRepository defined in @EnableJpaRepositories declared on JpaRepositoriesRegistrar.EnableJpaRepositoriesConfiguration: Not a managed type: class com.jpa.test.entities.User

[@TusharGupta-sp9jq]

Bhai mila solution ?? Please mila toh btaao