Spring Boot | JPA | MVC | H2 Example

Spring Full Course : courses.telusko.com/learn/Spr...
Spring Full Course (UDEMY) : www.udemy.com/spring-5-with-s...
Angular Full Course : courses.telusko.com/learn/Ang...
Spring Boot | JPA | MVC | H2 Example:- github.com/navinreddy20/Sprin...
Editing Monitors :
amzn.to/2RfKWgL
amzn.to/2Q665JW
amzn.to/2OUP21a.
Check out our website: www.telusko.com
Follow Telusko on Twitter: / navinreddy20
Follow on Facebook:
Telusko : / teluskolearn. .
Navin Reddy : / navintelusko
Follow Navin Reddy on Instagram: / navinreddy20
Subscribe to our other channel:
Navin Reddy : kzbin.info/door/xmk...
Telusko Hindi :
kzbin.info/door/itz...
Donation:
PayPal Id : navinreddy20
Patreon : navinreddy20
www.telusko.com/contactus

[@samarthurs8000]

You're great. Simply Superb. The best part is you make videos with very less/no preparation. All on the fly spontaneously. Just a Genius bro!

[@praveensharma8888]

I have started learning java from basic to advance and getting confidence just because of you. Your excitement level while making video makes more interest as a learner. You are my favorite. please keep sharing your knowledge. Big thumbs up :)

[@awanishmishra9584]

Please more and more video on spring boot..content are very good..and your teaching styles are awesome..good practical video on spring boot..and interview questions also

[@KIDIYABRIAN]

Thanks so much, if all lecturers in the world could teach like this, technology would be growing 10 times.

[@Anyvid95]

After Spring Boot 2.0 the data.sql should be import.sql. Hope someone find this useful. Btw this is an amazing tutorial.

[@saranshagarwal8286]

Thank you so much for the tip.

[@AndreGMendes]

Thanks! :)

[@fourten660]

Big thanks to bro =))

[@kunalsingh-wb1ju]

Thank you so much!!!! I LOVE YOU!!

[@panchananturuk3887]

Thank you so much bro ..Thanks for your tips it's working now

[@kevin-ru6oe]

I had some problems starting this project, but one I solved those, I understand all perfectly. Good video.

[@priyanga.c1065]

You are a really awesome brother. We can easily learn a new framework just because of your teaching style and knowledge. Thanks a lot.

[@vasuudayar3691]

Thank you Sir , you make every topics simple and clean

[@GodOfGizmos]

Great Video Navin! I loved it, in memory database.. I used to think about inbuilt database & now I can use it. I am new to spring boot & I am loving it.

[@larhchimismail3399]

You're the best so far people just must watch and like thanks for your time sir!!

[@vitormatos7483]

New versions of Spring + H2 doesn't create remote database at startup, for security reasons.

[@evg.sidenko]

Thanks a lot! Great video and very detailed description.

[@chinmaydas4053]

Good topics discussed sir.. Many many thanks 🙏..

[@youssefmoussa2523]

You are awesome man. You are the greatest alien i ever seen thanks a lot;

[@kirtim1930]

Nicely explained. Its really helpful.Thank you!

[@olahomori5561]

We'll be waiting for more videos 😊 I've been learning a lot..

[@DhakaToDC]

Learn New things from every video, Thanks

[@rajmodi1313]

Keep posting! We want more :)

[@sunilbiswal5637]

really sir , u r doing good job,ur explantion is super

[@curiously-cinnamon]

If you have created data.sql and written this query : Insert into alien values (101, 'Navin') Then you entered the h2-console and run the following query : Select * from alien And it only shows you an empty table with the column names AID and ANAME but no rows. Then add the following 3 lines in application.properties : spring.sql.init.mode=always spring.jpa.defer-datasource-initialization=true spring.jpa.hibernate.ddl-auto=create-drop After doing this, I was successfully able to insert values into database from data.sql

[@akshatagarwal8125]

Still gives error

[@shankarraj3433]

Thanks a lot. After adding these 3 lines in the 'application.properties' file, I have successfully inserted values into database from the data.sql at Runtime.

[@shankarraj3433]

Thanks a lot, you have saved me a huge amount of time in resolving this issue.

[@curiously-cinnamon]

@@shankarraj3433 Happy to help! Made this comment more than a year ago, but I'm glad it's proving useful to someone!

[@shankarraj3433]

@@curiously-cinnamon Ya, it helped many. Thanks.

[@salamansari145]

Your explanation is very much interesting specially in term of technical things 👍🏻

[@senthilkumars5243]

Thank you sir, It's very helpful for us..

[@sachingaikwad2939]

Thank you sir.. Your videos are very helpfull.

[@krish5960]

Chala easy way lo Cheptunnaru Navin :)

[@vamsikrishna-rc5nt]

Hi sir, in the above program, we had created the text editor to execute the queries in h2 database. But if we use the database as mysql, where we have to execute the queries.

[@neerajkashyap01]

Very nicely explained.

[@TejaDuggirala]

Teluskunnanu. Thank you sir :)

[@shankarraj3433]

Thanks Mr. Navin.

[@shubhammhatre4743]

When i hit the url ...it gives me whitelable error.. so i added @RequestMapping now its printing home.jsp on browser. i am not getting that name and id and submit form. I added home.jsp file in webapp folder as you show and even added jasper dependency. Please help

[@sabyasachirout]

Thanks for the video. I have one concern. Where to write customized method or to solve complex operations or giving more no of parameterized method. Which are not part of Interface.

[@ravijatwa240]

Navin Reddy great man!!

[@Akshoysamir]

@Telusko Learnings Can u please tell me how to get colorful logs in the eclipse console. It would be very much helpful for us.

[@queenskeleton4937]

Too late but. Use Spring Tool Suite and run your webapps as Spring Boot Application

[@akshaytalekar2307]

Thank you, sir You are great

[@ajit287]

Excellent sir.....keep going

[@pickmusic9533]

Can we use multiple database engine (MySQL, PostgreSQL, Mongodb, DynamoDb) for single webpage at a time?

[@elionaiesf]

Very good Thanks!

[@shilpachidura1287]

Very nice video. Why AlienRepo class is not annotated with component but how autowire is still working ?

[@arnabdas6089]

Man you are Great amd so is SpringBoot.:')

[@nitinverma25]

I must say, you are the best alien ;)

[@shankars4281]

I have a question. AlienRepo extending CrudRepository interface. But which class is implementing CrudRepository interface ? without implementing it, can we use it like it ?

[@freesoul2677]

Thank you so much. I have one question, whenever I restart the server all of the submitted data are lost what should I do?

[@ashishb1007]

Hi Naveen Sir, I have a question regarding the Alien repo, I saw that the repo is not annotated but still with Autowired annotation we were able to get that object inside the controller?

[@RezaJafari1984]

This is Perfection

[@SrividyaNatarajan]

Excellent...thq!

[@nafazbenzema9714]

AlienRepo is a interface.how did you create instance for interface through Autowired Annotaion

[@arunavdel86]

Hi Navin... was going through your videos. Its very well expalined. But I am looking for a code which can fetch data from database using non-primary keys. Say for a Employee table(Empid (Primary key), Empname, EmpEmailId, EmpSalary) , I want to write a web rest service to fetch employee details by email id being passed as a path parameter. Any document or suggestion would be really helpful.

[@jaiprakashnarayanjha8862]

Sir, your explanations are superb!!! I get aid, but not getting aname in database while fetching through program jsp page. But while fetching through data.sql or directly in database I got both aid and aname. Could you please guide me. Thanks

[@nidhinchacko6087]

Excellent!

[@olahomori5561]

Thank u for this.

[@WisdomIsAwesome]

For the record, the 1000th like was mine.

[@keerthipatisurendra8284]

how can we put auto-generated id's while deploying the app itself insert into alien values('sk'); now the id's should automatically inserted

[@6977202865]

BRILLIANT!!!!!

[@antrohydon0426]

super bro...

[@sumeshsuseelan7695]

Thank you so much!!!

[@jatinsareen7771]

which is the best screen recorder for laptop

[@aneckumar5701]

I have a Question that AlienRepo is not annotated with @Component annotation then how come Autowiring of the same Object happening?

[@sunnychouhan1228]

How does repository save the data ,as it is the interface and we have not implemented it any where...please explain

[@Icc_18]

When I hit the url it is showing whitelabel error page. The console is displaying an error as: An established connection was aborted by the software in your host machine. What should I do?

[@adilsaju]

Awesome!

[@gunjanrathore8101]

Can anyone please tell me why are we not using @Component in AlienRepo interface, as we are using @Autowired while creating object of this interface in lnside controller.

[@meenakshisundaram3231]

Very nice sir

[@prasadg7463]

Hello Sir, I'm having a problem while inserting data through sql file. The data is not inserted in the columns in order. It builds table with fields in alphabetical order. For example, Table[id,name,college] but it creates as Table[id,college,name]. Please help me to solve this.

[@budgettravelwitharzoo2446]

what is the use of @responsebody controller?

[@ujjawalsharma5549]

I want to use MySQL instead of H2 database in this project, how can I do that?

[@prannavkrishna1004]

Thank you vmuch

[@carlixprincipe]

Correct the classpath of your application so that it contains a single, compatible version of org.apache.tomcat.util.file.ConfigFileLoader How do i get this error?

[@RiteshSingh-gq6hh]

sir when i am adding datasource.url in application.properties and try to run this program it gives me error A file path that is implicitly relative to the current working directory is not allowed in the database URL

[@iamchiranjeevin]

I just now knew that a new runtime database named H2 Exists in a world lol ..but thanks anyway bro :D

[@hariomsinha6894]

can you tell me how to retrieve data from the h2 db?

[@MetaJINX00]

i have doubt that how jpa is capturing the values which you added in the name and id fields?

[@deepakm3839]

After creating data.sql file I am encountered with this error, Exception encountered during context initialization - cancelling refresh attempt:

[@akshaynikam9960]

Hello Sir, can you explain what you did at 2.35, how to make that form tag?, I am new learner, so far enjoying your content.

[@omarabuzaid9642]

at min 4:17 when I run , it gives me the same error , I think I have a problem in request mapping, I wrote same as you , so is it a problem because of the application properties?? or what should I change to run it

[@jelenastefanovic4902]

Hi, sir. I have a problem with h2 database that I do not know how to solve. When I start the application a get a IllegalStateExeption: The file is locked: nio:C:/.../lena.mv.db [1.4.197/7]. What shall I do to solve this ?

[@prayagbhasin9192]

On Which ide you are working?

[@islamayman278]

Thanks

[@abhipatel7883]

I am getting different sequence in my database table inspite of the one which I have written in my view file for example in vo I write stateId,stateName,stateDesc and in database I am getting stateId,stateDesc,stateName please any one can say what is the problem

[@tharlinhtet97]

Sir, it showed the error message that the remote database is not created.what should i do??

[@dhirendrasaxena9477]

Hi Naveen, In JPA want to execute below SQL open query to get the data from the linked server. SELECT * FROM OPENQUERY(PGSERVER, 'select * from shipx where shpxsndn=''6230905235''') I tried by using below but getting an exception : @Query(value = "SELECT * FROM OPENQUERY(PGSERVER, 'select * from shipx where shpxsndn=''6230905235''')", nativeQuery = true) Please advise in resolving the same.

[@vivekguptacs]

Its not working .i did the same . I used 2.0.4.RELEASE SPRING boot version.and h2 database scope is runtime as you shown in your pom. Could you please put this coade on git.. i was not able to see h2 console

[@devbros2241]

I have a really Important request, and that is to show us how to write sql query using spring mvc. It is one of the things I need for a project. Most applications need to run sql in the code, not in the database.

[@deveshrohila1558]

i hv removed my saved setting of H2 db, and now its showing error due to " test connection", so how can i change saved setting to H2 db, plz tell me

[@antoniofalabella4764]

The only bad thing about this video is that I can hit like just one time. I would upvote this 10 times

[@yashgarala6051]

Can you give some information to how to connect database from MySQL.

[@shanmuksandeep9134]

Navin ji, you have not annotated repo interface with any annotation(@Repository) . How come Autowired worked in this scenario??

[@shalinisingh2940]

the repo interface extended CrudRepository, you can go there to check the annotation there.

[@timgarcia4105]

I encountered a problem where the H2 database was not being created, It turns out that the package name of model should be under demo. Because I created mine com.example.model instead of com.example.demo.model.

[@fahmifarhat7076]

Yes, That's it! You have solved my problem. Thank you.

[@SaurabhkrGupta-tc7qs]

How do you define the datsource url ?

[@sablala3116]

good job

[@aswathyadhu6985]

But i am facing a problem that my table is refreshing in each run. how can i overcome that

[@deenanathsingh6959]

Sir go more brief with spring Boot

[@syedmohammadshabbir8195]

do we have to add spring web?

[@naeemghumman]

Very nice

[@2yogeshjadhav]

Can we use spring boot with Mysql Views?

[@mohdfurqan4739]

Awesome

[@ajinkyakadam967]

table is not getting created i have hit localhost:8080/h2-console...... then i put this jdbc:h2:mem:ajinkya which is there in my property file.... after this i have executed code by putting annotations @entity and @id but table is not getting created..... anyone will help on this... ??? thanks in advance

[@dipakmaske1]

Thank you

[@ruban3461]

data.sql file should be in target folder???

[@gangadharkodi5568]

Sir When am trying to test connection of H2 Data Base i got following Error can you help mr how to resolve it.. "not found, either pre-create it or allow remote database creation (not recommended in secure environments) [90149-200] 90149/90149 (Help)"

[@Kavya-jh1yh]

I am getting BeanCreationException. Error, please help me to resolve it

[@aditeemattoo6254]

Thnakyou Sir for the most amazing videos on JAVA one update in configuration in application.properties spring.jpa.defer-datasource-initialization=true spring.h2.console.enabled=true spring.datasource.url=jdbc:h2:mem:adm above will work