Spring Boot - Building a RESTful Web Service with MySql access
I try via the Rest-API to add an object into MySql database. This project is based on example project "petclinic" from git hub.
The objects are stored temporarily at runtime but not in the database.
The database works fine if I use the forms on "petclinic" Webpage to add or modify the database entries.
To the base project i added an Respository-Interface and a Controller.
Here is the Rest-Controller
@RestController
public class OwnerRestController {
@Autowired
private final OwnerRestRepository repo;
public OwnerRestController(OwnerRestRepository repo) {this.repo = repo;}
@RequestMapping(value="/owner/add", method=RequestMethod.POST)
public Owner create(@RequestBody Map<String, String> body){
Owner o = new Owner();
o.setFirstName(body.get("firstName"));
o.setLastName(body.get("lastName"));
o.setAddress(body.get("address"));
o.setCity(body.get("city"));
o.setTelephone(body.get("telephone"));
this.repo.save(o);
return o;
}
}
Here is the Repository Interface
public interface OwnerRestRepository extends CrudRepository<Owner,integer>{}
Here is the JSON-Object Owner
{
"firstName":"fname",
"lastName":"lname",
"address":"address1",
"city":"city1",
"telephone":"4711"
}
Server Response - Added Object locally
{
"id": 11,
"firstName": "fname",
"lastName": "lname",
"address": "address1",
"city": "city1",
"telephone": "4711",
"pets": ,
"new": false
}
What's wrong in the code that the data can't be stored in the database?
Best regards, Mux
spring rest api spring-boot
asked Dec 31 '18 at 16:46
MuxMux
12
add a comment |
I try via the Rest-API to add an object into MySql database. This project is based on example project "petclinic" from git hub.
The objects are stored temporarily at runtime but not in the database.
The database works fine if I use the forms on "petclinic" Webpage to add or modify the database entries.
To the base project i added an Respository-Interface and a Controller.
Here is the Rest-Controller
@RestController
public class OwnerRestController {
@Autowired
private final OwnerRestRepository repo;
public OwnerRestController(OwnerRestRepository repo) {this.repo = repo;}
@RequestMapping(value="/owner/add", method=RequestMethod.POST)
public Owner create(@RequestBody Map<String, String> body){
Owner o = new Owner();
o.setFirstName(body.get("firstName"));
o.setLastName(body.get("lastName"));
o.setAddress(body.get("address"));
o.setCity(body.get("city"));
o.setTelephone(body.get("telephone"));
this.repo.save(o);
return o;
}
}
Here is the Repository Interface
public interface OwnerRestRepository extends CrudRepository<Owner,integer>{}
Here is the JSON-Object Owner
{
"firstName":"fname",
"lastName":"lname",
"address":"address1",
"city":"city1",
"telephone":"4711"
}
Server Response - Added Object locally
{
"id": 11,
"firstName": "fname",
"lastName": "lname",
"address": "address1",
"city": "city1",
"telephone": "4711",
"pets": ,
"new": false
}
What's wrong in the code that the data can't be stored in the database?
Best regards, Mux
spring rest api spring-boot
asked Dec 31 '18 at 16:46
MuxMux
12
The objects are stored locally at runtime environment but not in the database.
– Mux
Jan 1 at 11:43
So your question is: is it possible to store data in memory? Yes, of course it is. It's probably not a good idea, and you need to make it thread-safe, but sure, it's possible.
– JB Nizet
Jan 1 at 11:46
add a comment |
I try via the Rest-API to add an object into MySql database. This project is based on example project "petclinic" from git hub.
The objects are stored temporarily at runtime but not in the database.
The database works fine if I use the forms on "petclinic" Webpage to add or modify the database entries.
To the base project i added an Respository-Interface and a Controller.
Here is the Rest-Controller
@RestController
public class OwnerRestController {
@Autowired
private final OwnerRestRepository repo;
public OwnerRestController(OwnerRestRepository repo) {this.repo = repo;}
@RequestMapping(value="/owner/add", method=RequestMethod.POST)
public Owner create(@RequestBody Map<String, String> body){
Owner o = new Owner();
o.setFirstName(body.get("firstName"));
o.setLastName(body.get("lastName"));
o.setAddress(body.get("address"));
o.setCity(body.get("city"));
o.setTelephone(body.get("telephone"));
this.repo.save(o);
return o;
}
}
Here is the Repository Interface
public interface OwnerRestRepository extends CrudRepository<Owner,integer>{}
Here is the JSON-Object Owner
{
"firstName":"fname",
"lastName":"lname",
"address":"address1",
"city":"city1",
"telephone":"4711"
}
Server Response - Added Object locally
{
"id": 11,
"firstName": "fname",
"lastName": "lname",
"address": "address1",
"city": "city1",
"telephone": "4711",
"pets": ,
"new": false
}
What's wrong in the code that the data can't be stored in the database?
Best regards, Mux
spring rest api spring-boot
asked Dec 31 '18 at 16:46
MuxMux
12
I try via the Rest-API to add an object into MySql database. This project is based on example project "petclinic" from git hub.
The objects are stored temporarily at runtime but not in the database.
The database works fine if I use the forms on "petclinic" Webpage to add or modify the database entries.
To the base project i added an Respository-Interface and a Controller.
Here is the Rest-Controller
@RestController
public class OwnerRestController {
@Autowired
private final OwnerRestRepository repo;
public OwnerRestController(OwnerRestRepository repo) {this.repo = repo;}
@RequestMapping(value="/owner/add", method=RequestMethod.POST)
public Owner create(@RequestBody Map<String, String> body){
Owner o = new Owner();
o.setFirstName(body.get("firstName"));
o.setLastName(body.get("lastName"));
o.setAddress(body.get("address"));
o.setCity(body.get("city"));
o.setTelephone(body.get("telephone"));
this.repo.save(o);
return o;
}
}
Here is the Repository Interface
public interface OwnerRestRepository extends CrudRepository<Owner,integer>{}
Here is the JSON-Object Owner
{
"firstName":"fname",
"lastName":"lname",
"address":"address1",
"city":"city1",
"telephone":"4711"
}
Server Response - Added Object locally
{
"id": 11,
"firstName": "fname",
"lastName": "lname",
"address": "address1",
"city": "city1",
"telephone": "4711",
"pets": ,
"new": false
}
What's wrong in the code that the data can't be stored in the database?
Best regards, Mux
spring rest api spring-boot
spring rest api spring-boot
asked Dec 31 '18 at 16:46
MuxMux
12
asked Dec 31 '18 at 16:46
MuxMux
12
edited Jan 1 at 12:03
Mux
asked Dec 31 '18 at 16:46
MuxMux
12
asked Dec 31 '18 at 16:46
MuxMux
12
asked Dec 31 '18 at 16:46
MuxMux
12
12
The objects are stored locally at runtime environment but not in the database.
– Mux
Jan 1 at 11:43
So your question is: is it possible to store data in memory? Yes, of course it is. It's probably not a good idea, and you need to make it thread-safe, but sure, it's possible.
– JB Nizet
Jan 1 at 11:46
add a comment |
The objects are stored locally at runtime environment but not in the database.
– Mux
Jan 1 at 11:43
So your question is: is it possible to store data in memory? Yes, of course it is. It's probably not a good idea, and you need to make it thread-safe, but sure, it's possible.
– JB Nizet
Jan 1 at 11:46
The objects are stored locally at runtime environment but not in the database.
– Mux
Jan 1 at 11:43
The objects are stored locally at runtime environment but not in the database.
– Mux
Jan 1 at 11:43
So your question is: is it possible to store data in memory? Yes, of course it is. It's probably not a good idea, and you need to make it thread-safe, but sure, it's possible.
– JB Nizet
Jan 1 at 11:46
So your question is: is it possible to store data in memory? Yes, of course it is. It's probably not a good idea, and you need to make it thread-safe, but sure, it's possible.
– JB Nizet
Jan 1 at 11:46
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53989633%2fspring-boot-building-a-restful-web-service-with-mysql-access%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53989633%2fspring-boot-building-a-restful-web-service-with-mysql-access%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
The objects are stored locally at runtime environment but not in the database.
– Mux
Jan 1 at 11:43
So your question is: is it possible to store data in memory? Yes, of course it is. It's probably not a good idea, and you need to make it thread-safe, but sure, it's possible.
– JB Nizet
Jan 1 at 11:46