{"id":1930,"date":"2019-06-14T12:00:00","date_gmt":"2019-06-14T10:00:00","guid":{"rendered":"https:\/\/kindsonthegenius.com\/blog\/h2-in-memory-database-step-by-step-tutorial\/"},"modified":"2026-07-05T03:23:49","modified_gmt":"2026-07-05T01:23:49","slug":"h2-in-memory-database-step-by-step-tutorial","status":"publish","type":"post","link":"https:\/\/kindsonthegenius.com\/blog\/h2-in-memory-database-step-by-step-tutorial\/","title":{"rendered":"H2 In-Memory Database Step by Step Tutorial"},"content":{"rendered":"

This is Similar to the Spring with MVC Procedure<\/a><\/p>\n

    \n
  1. Create a new Starter project. Add Web, jpa and H2 dependencies<\/li>\n
  2. Examine the pom.xml<\/li>\n
  3. Create a Student class in the models package<\/li>\n
  4. Annotate the class with @Entity annotation, Annotate the the Id with @Id annotation and @GeneratedValue<\/li>\n
  5. Create a StudentRepostory interface in the repositories package. Make it extend CrudRepository<T, Type><\/li>\n
  6. Create a StudentController in the controllers package. Annotate with @RestController<\/li>\n
  7. Annotate the controller with @RequestMapping of \/springh2<\/li>\n
  8. Enable h2 console, datasource and url in the application.properties file<\/li>\n<\/ol>\n

     <\/p>\n

    <\/p>\n

    spring.h2.console.enabled=true\nspring.datasource.platform=h2\nspring.datasource.url=jdbc:h2:mem:<dbname><\/span>\nspring.jpa.hibernate.ddl-auto=update\n<\/pre>\n
     <\/p>\n
      \n
    1. Run the application<\/li>\n
    2. Visit http:\/\/localhost:8080\/h2-console<\/li>\n
    3. Change the jdbc url to what you already specified in the application.properties<\/li>\n
    4. Click on Connect. Notice that the STUDENT table is created. This is made possible by springboot autoconfiguration<\/li>\n
    5. Create a separate data.sql file in the resources folder. Write a query to insert a couple of records in the database<\/li>\n
    6. Relaunch the application.<\/li>\n
    7. Refresh the console and check that this initial data is inserted<\/li>\n
    8. Autowire the StudentRepository into the StudentController<\/li>\n
    9. Write a method getAllStudents in the Controller that uses the findAll() method of the repository to return all student records<\/li>\n
    10. Add the @GetMapping of \/students to the getAll Students method<\/li>\n
    11. Write the getStudentByID method to return the student with a particular Id<\/li>\n
    12. Test the application<\/li>\n<\/ol>\n
      Add Update and Delete Methods<\/strong><\/p>\n
        \n
      1. Write the Add Method<\/li>\n
      2. Write the Update Method<\/li>\n
      3. Write the Delete Method<\/li>\n
      4. Test the application<\/li>\n
      5. Use Advanced Rest Client to add some records<\/li>\n
      6. Check Spring Console to see that the records are there<\/li>\n<\/ol>\n
        Implementing a Service Layer (You should be able to do this by now)<\/strong><\/p>\n
          \n
        1. To Implements a Service Layer, simply add a class called StudentService.<\/li>\n
        2. Annotate this class with the @Service annotation<\/li>\n
        3. Write the all the same methods you have in the controller file in in the service file. (without the @RequestMapping, @PathVariable or @RequestBody annotations<\/li>\n
        4. Adjust the StudentController file so that it calls the functions in the StudentService file<\/li>\n
        5. Modify the StudentService class to calls methods in the StudentRepository.<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"
          This is Similar to the Spring with MVC Procedure Create a new Starter project. Add Web, jpa and H2 dependencies Examine the pom.xml Create a … <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"pagelayer_contact_templates":[],"_pagelayer_content":"","footnotes":""},"categories":[414],"tags":[],"class_list":["post-1930","post","type-post","status-publish","format-standard","hentry","category-programming"],"_links":{"self":[{"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/posts\/1930","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/comments?post=1930"}],"version-history":[{"count":1,"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/posts\/1930\/revisions"}],"predecessor-version":[{"id":2098,"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/posts\/1930\/revisions\/2098"}],"wp:attachment":[{"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/media?parent=1930"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/categories?post=1930"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/tags?post=1930"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}