POST data in Mysql database using Spring Boot and Postman tutorial | REST API
Vložit
- čas přidán 24. 01. 2023
- How to perform post operation to input data into mysql database in rest api using spring boot and postman is shown
#restapi #mysql #springboot - Věda a technologie
Was going through so many tutorials but yet this was the successful one. Great One!!!
Great to hear! good luck
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🤩👍
Wow glad to know man!!
Your doing a good job and Straight to the point. 🎉 And thats a "PascalCase" Not a "camelCase".❤
Thank you so much!!!
Thank you for tutorial
Welcome!!
Simple & works fine
Fantastic
good Explanation
Thanks for liking!!
Simply It works
cool
thank men
Any time
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
Yeah you need to create the database first using mysql code prior
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!
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 (?,?,?)
Where are you passing the id? I see u have mark , name and id columns
I am having the same problem, please somebody help us.
@@user-jm5ov9gx1v did you get your problem solved ? if yes, please help me also.
have your problem solved. I am getting same error.
I didnt understand how you created the postman. Like how can you please tell? its not mentioned in the video
just click on create new workspace option, the one with the plus icon
When iam posting json body one of the data is being stored as null in database
Check if you have the type as json in postman and if you are using express.json() in code
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
So you are performing update operation?
are you using inteellij idea community version? if so, it does not support spring.
wdym? i am using that one
do you have this on some github repository??
No I don't have
Thank you sir, i have problem after the post and get my data is not reflecting in mysql workbench , please help me
What do you get as response? any errors?
@@unitedtoptech6288 no errors sir
@@unitedtoptech6288 no errors postman sending the request and the table is also created in mysql work bench only the data is not getting fetched
is it fetch all data or fetch by using an id alone?
@@unitedtoptech6288 am providing only first name, last name and email the id is automatically generated (employee management system)
Sir I send request post and getting output as empty object
Try changing the request from text to json
how to delete the data from Querry through this program
You mean through query parameter ?
I am getting MySQL8 dialect has been deprecated..could you please help ?
I just did this last week, I didn't get any such things, did you select the java version same as me?
@@unitedtoptech6288 how can we insert multiple records in to mysql through postman by using nodejs can you please do a video sir
yep I did , you can send list of objects for that from postman
will it work with maven
yeah the code will be the same
I didn't get table in MySQL
Can you check the code? or you getting any error?
W
thanks W
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
Are you sending response in code , that res send() thing ?
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.
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
@@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.
Is your spring boot application running on port 3000?
@@unitedtoptech6288 yeahh...I figured it out..thank you!
Was that the issue?
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
Please check if you have added autowired annotation to repository and service object variables
@@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
ohh glad it woked for you now! welcome