POST data in Mysql database using Spring Boot and Postman tutorial | REST API

How to perform post operation to input data into mysql database in rest api using spring boot and postman is shown
#restapi #mysql #springboot

[@mohomedrimzan8916]

Was going through so many tutorials but yet this was the successful one. Great One!!!

[@unitedtoptech6288]

Great to hear! good luck

[@anithkumar1524]

Thank you very much Brother, i m new to this coding, So Your videos would have helped me a lot to understand simply, Really appreciate your efforts🤩👍

[@unitedtoptech6288]

Wow glad to know man!!

[@erenyeager45god]

Your doing a good job and Straight to the point. 🎉 And thats a "PascalCase" Not a "camelCase".❤

[@unitedtoptech6288]

Thank you so much!!!

[@deeyt7573]

Simple & works fine

[@unitedtoptech6288]

Fantastic

[@jayaprakash1546]

Thank you for tutorial

[@unitedtoptech6288]

Welcome!!

[@GnanaPonneri]

good Explanation

[@unitedtoptech6288]

Thanks for liking!!

[@telugudramaworld8021]

DO we need to write the MySQL code in prior or not needed, pls help here - The one with creating newDB and all in MySQL

[@unitedtoptech6288]

Yeah you need to create the database first using mysql code prior

[@josephrexa5444]

Simply It works

[@unitedtoptech6288]

cool

[@user-ii6rb6nw8c]

thank men

[@unitedtoptech6288]

Any time

[@user-qk2ph7jl1r]

I didnt understand how you created the postman. Like how can you please tell? its not mentioned in the video

[@unitedtoptech6288]

just click on create new workspace option, the one with the plus icon

[@user-jm5ov9gx1v]

Application runs fine but im not getting response in the postman, though the status is 200ok. this is my post request { "marks":100, "name":"Penny" } its my response: {} null values with random id are getting inserted into database. whats wrong? any idea!

[@user-jm5ov9gx1v]

Hibernate: select next_val as id_val from students_db_seq for update Hibernate: update students_db_seq set next_val= ? where next_val=? Hibernate: insert into students_db (st_marks,st_name,id) values (?,?,?)

[@unitedtoptech6288]

Where are you passing the id? I see u have mark , name and id columns

[@mr.khiladi6796]

I am having the same problem, please somebody help us.

[@mr.khiladi6796]

@@user-jm5ov9gx1v did you get your problem solved ? if yes, please help me also.

[@charubabbar8807]

have your problem solved. I am getting same error.

[@Strawhat-lu7ib]

When iam posting json body one of the data is being stored as null in database

[@unitedtoptech6288]

Check if you have the type as json in postman and if you are using express.json() in code

[@user-zv4lv7lg4l]

Hi! thanks for the video, very helpfull. when using postman,I am getting a 500 error, seems like a problem with data base... because if Iam just returning a string there is not an error and if trying update data base - error. if someone knows what can i do

[@unitedtoptech6288]

So you are performing update operation?

[@mr.khiladi6796]

are you using inteellij idea community version? if so, it does not support spring.

[@unitedtoptech6288]

wdym? i am using that one

[@NikitaLazaroSevcisen]

do you have this on some github repository??

[@unitedtoptech6288]

No I don't have

[@_KrishnaMoorthyR]

Sir I send request post and getting output as empty object

[@unitedtoptech6288]

Try changing the request from text to json

[@rajeshkhannaarumugam6699]

will it work with maven

[@unitedtoptech6288]

yeah the code will be the same

[@mamtakurrey6405]

I didn't get table in MySQL

[@unitedtoptech6288]

Can you check the code? or you getting any error?

[@shreyamarya3452]

how to delete the data from Querry through this program

[@unitedtoptech6288]

You mean through query parameter ?

[@clarkkent3004]

W

[@unitedtoptech6288]

thanks W

[@charubabbar8807]

Hi Through postman I am getting response empty { } and rows are inserting in db as : +----+---------+------+ | id | st_mark | name | +----+---------+------+ | 1 | 0 | NULL | +----+---------+------+ Please help! Thanks in advance

[@unitedtoptech6288]

Are you sending response in code , that res send() thing ?

[@gulshankataria77]

I am getting MySQL8 dialect has been deprecated..could you please help ?

[@unitedtoptech6288]

I just did this last week, I didn't get any such things, did you select the java version same as me?

[@manojprabhakar5286]

@@unitedtoptech6288 how can we insert multiple records in to mysql through postman by using nodejs can you please do a video sir

[@unitedtoptech6288]

yep I did , you can send list of objects for that from postman

[@siddhishinde8027]

Thank you sir, i have problem after the post and get my data is not reflecting in mysql workbench , please help me

[@unitedtoptech6288]

What do you get as response? any errors?

[@siddhishinde8027]

@@unitedtoptech6288 no errors sir

[@siddhishinde8027]

@@unitedtoptech6288 no errors postman sending the request and the table is also created in mysql work bench only the data is not getting fetched

[@unitedtoptech6288]

is it fetch all data or fetch by using an id alone?

[@siddhishinde8027]

@@unitedtoptech6288 am providing only first name, last name and email the id is automatically generated (employee management system)

[@numzikshiuaxing1600]

As you didn't mention anything about postman,could you please tell me regarding what i should do in postman?I have to idea what url should I type or the localhost.

[@unitedtoptech6288]

Just type the same URL as I have done in postman, It is just a tool for making API calls, please learn about it first

[@numzikshiuaxing1600]

@@unitedtoptech6288 Error: connect ECONNREFUSED 127.0.0.1:3000 Request Headers Content-Type: application/json User-Agent: PostmanRuntime/7.37.3 Accept: */* Postman-Token: be86e12b-13d6-4992-a219-ffec31712fba Host: localhost:3000 Accept-Encoding: gzip, deflate, br Connection: keep-alive I get this when I click send after typing the url.

[@unitedtoptech6288]

Is your spring boot application running on port 3000?

[@numzikshiuaxing1600]

@@unitedtoptech6288 yeahh...I figured it out..thank you!

[@unitedtoptech6288]

Was that the issue?

[@ArthurCnap]

Hi, im having a problem with starting an application it throws: "Field studentRepository in com.project.ToDoList.Service.StudentService required a bean of type 'com.project.ToDoList.Repository.StudentRepository' that could not be found." Thought it might happen because there's no @Repository annotation but adding it didn't help. Also the informations about creating the table in run console do not appear, i have spring.jpa.show-sql=true and spring.jpa.generate-ddl=true in my aplication properties

[@unitedtoptech6288]

Please check if you have added autowired annotation to repository and service object variables

[@ArthurCnap]

@@unitedtoptech6288 I figured it out, guess there was a problem with MySQL Driver cause I was working on a project generated a few days ago. I took some random dependency from maven repo and that created all the problems. Thank you for the response mate

[@unitedtoptech6288]

ohh glad it woked for you now! welcome