Spring Boot - Spring Data REST and JPA example | Tech Primers

This Video covers the Spring Data frameworks which are out there and an hands on implementation with example on Spring Data REST and JPA.
🔗Code on GitHub: github.com/TechPrimers/spring...
📌 Related Playlist
================
🔗Spring Boot Primer - • Spring Boot Primer
🔗Spring Cloud Primer - • Spring Cloud Primer
🔗Spring Microservices Primer - • Spring Microservices P...
🔗Spring JPA Primer - • Spring JPA Primer
🔗Java 8 Streams - • Java 8 Streams
💥Join TechPrimers Slack Community: bit.ly/JoinTechPrimers
💥Telegram: t.me/TechPrimers
💥TechPrimer HindSight (Blog): / techprimers
💥Website: techprimers.com
💥Slack Community: techprimers.slack.com
💥Twitter: / techprimers
💥Facebook: TechPrimers
💥GitHub: github.com/TechPrimers or techprimers.github.io/
🎬Video Editing: iMovie
---------------------------------------------------------------
🔥 Disclaimer/Policy:
The content/views/opinions posted here are solely mine and the code samples created by me are open sourced.
You are free to use the code samples in Github after forking and you can modify it for your own use.
All the videos posted here are copyrighted. You cannot re-distribute videos on this channel in other channels or platforms.
#Spring #SpringBoot #TechPrimers

[@johnwau2485]

It is very clear,thank-you for the tutorial bro..

[@kemparaj565]

Simple, Elegant. A quick tour to SpringJPA. Thanks

[@yashjain611]

Nice and Easy, just as we all want. Thank you Tech Primers for such great explanation.

[@harinitatipelli7869]

Thank you so much for this tutorial. It helped me to understand the spring jpa in less time

[@herbtea1260]

I think it is the best lecture. Simple and easy to follow.

[@muks]

Great explanation Dude !! In this video you explained the steps which is very important and in some part also why we have to do it. It's very important to explain why and how rather than just giving coding video. kudos !!!

[@TechPrimers]

Thanks Mukul. Glad that was helpful

[@amitchechare3454]

Just Awesome ......Must say Gr8 peace of work.

[@vijayroy3173]

excellent job Ajay

[@srikanthch575]

Great explanation dude

[@samuelvishesh]

6:10 use the keyboard shortcut *Alt + Insert* to Generate code / bring up code assistance 😊

[@sourav5562]

which editor is it?

[@gayathrikandaswamy739]

Thanks Techprimer for this wonderful video. Can you please do a video on how an app with local DB can be deployed in cloud. or if have done it already please reply with the link. Thanks

[@biswanathbehera1057]

Grt content..sir please upload video on soap webservice and spring Jax ws Integration.

[@TechPrimers]

sure biswa. will do soon

[@biswanathbehera1057]

Tech Primers thanks

[@biswanathbehera1057]

Sir will u please update about Apache cfx.

[@20min8s]

Hi Ajay. Can you please do a video on connecting to multiple Ldap servers using spring boot?

[@ShinAkuma]

I have been searching for some time now. How do you perform complex queries using JPA ? I want to return a result that contains data from a query using several joins on several tables and other where conditions and returns specific columns from each table as required, how do I do that ?

[@Azhagusuryaa2696]

@ 11:00 , you didn't tell how you start the inbuilt tomcat server.and you didnt explain how the h2 database accept the post call for load

[@sureshbabumaddula3005]

check @ 1:38 added web and h2 d.b from spring starter which adds dependencies in pom.xml

[@rorytowler3464]

What application are you using to create and send the JSON to local host? Edit: I did a bit of looking around and think it's Postman

[@TechPrimers]

Yes Rory. Its postman REST client.

[@vikasbhardwaj1502]

Nyc post can you post this with query dsl also

[@jasper5016]

Can you please explain how can we use multiple joins ( 4 to 5 tables) or complex SQL queries using JPA?

[@JeanCarlos-ni4fv]

Do you edited the interface JpaRepository before implement the code because the interface not permit personalize the methods ?

[@TechPrimers]

nope. can you check if the spring boot version is different

[@johnmoe2806]

In the @RestController you did a save then find. There is no need as you can do "return userRepository.save(user);"

[@vinodmahato2505]

sir, my application is not starting, also i checked that the h2 database dependency is present in the pom file, it shows error: Failed to configure a DataSource: 'url' attribute is not specified and no embedded datasource could be configured.

[@yaroslavsoltys4846]

Why does program failled and write that a bean of the EntityManagerFactory are required?

[@KistlakRajapakshaSevenNet]

Great Video Bro !! :D Can we use custom query like "SELECT devname,projname FROM tablename WHERE id='userId'" ??

[@KistlakRajapakshaSevenNet]

Prathemesh Kumar - Did you try source code from the GitHub ?? I think you can get an idea by using the source code..

[@TechPrimers]

yes u can use custom queries

[@somanathbhat5517]

which IDE are you using?

[@TechPrimers]

+Somanath Bhat Hi Somanath, I use IntelliJ IDEA from JetBrains. :)

[@chinmayabehera513]

I have created a Springboot,Jpa project and configured 2 databases. Can we update the existing records with Unique constraint? Table doesn't have Primary Key. Here, I am fetching the records from Azure MS SQL Server View and Loading into On Premise Oracle DB Table. In Azure Microsoft SQL Server View, most of columns are having duplicate values. Here, I am fetching the data from Azure DB , then deleting the existing records from Oracle table and inserting the Azure Db data into Oracle DB table. Instead of deleting the existing records from Oracle Db table, can we update the existing records in Oracle DB table ??

[@rajeshchilukuri335]

why is that save method for me is not throwing any error and generating id properly, but when i check DB, the data is not present

[@madhusudhan9346]

Hi Your video is very helpful. I have one doubt.After executing "gradle clean build",In mysql - table is becoming empty. Why? what is the issue?

[@TechPrimers]

you need to check your settings in jpa. if you have instructed jpa to clean up the table after shutdown, it will clean it up

[@ayeshabegum24]

Hi Ajay I am getting null values for findAll(). I have few data in the table. Pls advice

[@TechPrimers]

looks like your data is not matching your POJO

[@RavindraKumar-st3or]

please tell me the name of the tool which you have used to hit the url and also i want to know where you are posting the data after hitting the url

[@TechPrimers]

It's Postman client

[@sapnakondapallii9135]

Hi good tutorial..... but I am getting error while running app from Eclipse...failed to execute goals spring-boot-maven plugin 1.5.16 .....

[@swapnamosali4241]

can youplease explain how to use websphere JNDI in spring boot data JPA. I have tried many ways its not working.Many people explaining with external tomcat. But I need my application in websphere 9.0.0.7

[@miguel1795]

ajay what tool is that on 0:34 showing spring data connection

[@TechPrimers]

It's Xmind. Mind mapping tool

[@miguel1795]

tnx bro will try it out

[@manashranjan1267]

Invalid derived query! No property name found for type User in JPARepository interface can you explain me sir what to do here

[@anandharajanandharaj6231]

You are searching with invalid name.. you should Search with the value which you you have in your entity class.. For an example in your entity class you have an variable name , age but you are searching by address then JPA doesn't build the query it will throw the error.. you should Search either name or age

[@kumarr6195]

how to the load Data

[@prathemeshkumar4258]

I have raised an Issue on your GitHub repo "github.com/TechPrimers/spring-data-rest-jpa-example". I tried to follow your steps (and also used your repo directly by cloning it), but could never get it to run. Could you please help out?

[@ArunabhFunWorld]

Hi Ajay, I need your bit of help as I am getting couple of issues in the above example . I am trying to set up the code that you have shared in git and having following issue. -->When I ran the pom it didn't get the javax.persistence.* dependencies for which Users class started giving compilation error . For which I added below javax.persistence persistence-api 1.0.2 provided ---> After adding the above I am getting following org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'entityManagerFactory' defined in class path resource [org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaAutoConfiguration.class]: Unsatisfied dependency expressed through method 'entityManagerFactory' parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'entityManagerFactoryBuilder' defined in class path resource [org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaAutoConfiguration.class]: Unsatisfied dependency expressed through method 'entityManagerFactoryBuilder' parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'jpaVendorAdapter' defined in class path resource [org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaAutoConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.springframework.orm.jpa.JpaVendorAdapter]: Factory method 'jpaVendorAdapter' threw exception; nested exception is java.lang.NoClassDefFoundError: javax/persistence/spi/ProviderUtil Waiting for your help.

[@TechPrimers]

Can you check if you are using the same version of spring boot?

[@ArunabhFunWorld]

My persistent API jar under m2 was corrupt . So I deleted the hibernate folder under m2 and then it started working. Thanks

[@sidramowlana]

Is this spring mvc? because if Spring Data Rest is used u wont be needing controllers ryt

[@TechPrimers]

yes. it is spring mvc

[@vk2537]

I m getting this error when i tried using postman "timestamp": "2018-04-05T22:18:08.539+0000", "status": 415, "error": "Unsupported Media Type", "message": "Content type 'text/plain;charset=UTF-8' not supported", "path": "/users/load"

[@TechPrimers]

you will have to pass the header Content-Type as "application/json"

[@amritasingh1105]

What is the IDE you are using ?

[@TechPrimers]

IntelliJ IDEA

[@paulvincent9473]

How to connect with mssql server...??

[@TechPrimers]

you can add the necessary configs for the spring data connections. do check my video on connecting to mysql database, it will be similar -> kzbin.info/www/bejne/m3rCiZKBlL2ifNU&index=10

[@ajitpawar6566]

But what's code you used for jpa query... You just show basics

[@jamuna5181]

.save(users); is showing error [create the method save(users)].Could someone help me by saying why this error occurs.

[@nandasagar3973]

in ur repo interface have u written @component , and have u extended the interface to jpa Repository. if its properly written check ur controller if u have created an instance of repository and have u autowired it or not .

[@madhusudhan9346]

IntelliJ IDEA is not for free right?what should i use?

[@kalyankumar239]

Community version is open source, which is enough for spring-boot

[@TechPrimers]

It has both version Madhu

[@lostalone6816]

@@TechPrimers k

[@jeftc7122]

Hello Ajay , i have coded locally and everything looks fine , it looks like yours , but when i try my endpoint , it just doesnt return anything ...it would be great if you can help please

[@TechPrimers]

What did do u see in the logs?

[@jeftc7122]

@@TechPrimers Thank you so much replying back Ajay, appreciate it. I think the problem with me i am using Oracle as DB ..and most of you guys use either MYSQL , H2 etc . ANd based on what have been told from forums videos etc, i have done that for Oracle drivers etc , we use maven and appears that maven doesnt provide oracle dependencies etc ...so at the the moment this is what we are getting in the logs - java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver would be great if you can help on this Ajay , really your help is much much appreciated . Thank you

[@sapnakondapallii9135]

Where is the db connection managed

[@TechPrimers]

By hibernate/hikari datasource

[@ILyaCyclone]

Spring Data REST is a specific Spring Data project and this video has nothing about it. Video title is misleading and made me waste some time here. :/

[@thannasip8001]

Which tool is this?

[@Explore-world-]

intelliJ ide

[@taufiquealam1614]

Hello Bro....It's not Spring Data Rest, Please modify title and if you have made videos on Spring Data Rest please share. Thanks for Spring Data JPA.

[@jeftc7122]

Anybody can help me please ?

[@ashgs3460]

Hi, Thanks for creating this video. It is helpful. I am getting an error when starting the application, let me explain the major steps. I copied the code from the github repository and running the application under eclipse I get the following: *************************** APPLICATION FAILED TO START *************************** Description: Field userJpaRespository in com.techprimers.controller.UsersController required a bean of type 'com.techprimers.repository.UserJpaRespository' that could not be found. Action: Consider defining a bean of type 'com.techprimers.repository.UserJpaRespository' in your configuration. Do I need to add an implementation of the interface 'com.techprimers.repository.UserJpaRespository'? Warm Regards, ~Ash

[@ashgs3460]

Managed to fix the issue. The following was needed in SpringBootJpaDemoApplication.java import org.springframework.boot.SpringApplication; import org.springframework.boot.autoconfigure.SpringBootApplication; import org.springframework.boot.autoconfigure.domain.EntityScan; import org.springframework.context.annotation.ComponentScan; import org.springframework.data.jpa.repository.config.EnableJpaRepositories; @ComponentScan("com.techprimers") @EntityScan("com.techprimers.model") @EnableJpaRepositories("com.techprimers.repository") Can someone explain the meaning of @EnableJpaRepositories and @EnityScan? Warm Regards, ~Ash

[@TechPrimers]

+Ash Gs3 Hi Ash, glad you had it fixed @EnableJpaRepositories - Here we are telling spring boot enable JPA usage. @EntityScan - you provide the package where your entities are placed (models) so that spring can use them for Hibernate

[@vamshikrishna8143]

for all those, getting white label error, move the main application file SpringBootDemoApplication to the root of the project, not inside any folder. The file is inside the folder if you use spring.io website to download project

[@vishnudixit68]

this is not spring data rest example,you have written only namesake it is spring data with JPA not spring data Rest

[@NaveenAmruth]

I couldn't able to run the application. I don't know where I am doing wrong, I double verified all the classes seems to be correct to me Every time I am seeing same error, localhost:8080/user/all Whitelabel Error Page This application has no explicit mapping for /error, so you are seeing this as a fallback. Wed May 10 16:28:55 EDT 2017 There was an unexpected error (type=Not Found, status=404). No message available

[@TechPrimers]

Hi Naveen. Looks like your REST end point is not getting mapped to /user/all. can you share the RestController/Resource file?

[@NaveenAmruth]

Thank you for very quick response. I appreciate it. here is the code what I am using, package controller; import java.util.List; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.boot.autoconfigure.web.ErrorController; import org.springframework.web.bind.annotation.GetMapping; import org.springframework.web.bind.annotation.PathVariable; import org.springframework.web.bind.annotation.PostMapping; import org.springframework.web.bind.annotation.RequestBody; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RestController; import com.nsr.model.Users; import com.nsr.repository.UserJpaRepository; @RestController @RequestMapping("/users") public class UsersController implements ErrorController { @Autowired private UserJpaRepository userJpaRepository; @GetMapping(value="/all") public List findAll(){ return userJpaRepository.findAll(); } @GetMapping(value="/{name}") public Users findByName(@PathVariable final String name){ return userJpaRepository.findByName(name); } @PostMapping(value="/load") public Users load(@RequestBody final Users users){ userJpaRepository.save(users); return userJpaRepository.findByName(users.getName()); } private static final String PATH = "/error"; @RequestMapping(value = PATH) public String error() { return "Error handling"; } @Override public String getErrorPath() { return PATH; } }

[@NaveenAmruth]

Hi, Could you please help me on below issue. Thanks!

[@TechPrimers]

Hi Naveen, What's the significance of adding ErrorController into the same RestController? May be thats the issue here, since you have implemented Error Controller, only "/error" is getting mapped. As you now, Spring is opinionated, you have to do it the way spring wants it. can you split this class and use only the REstController and move ErrorController to a new class.

[@boudforsaad5278]

the right url is localhost:8080/users/all

[@huanzhang788]

口音真难受