Spring Boot – Loading Initial Data

by

You can create a data.sql file in your src/main/resources folder and it will be automatically executed on startup. In this file you can add some insert statements, eg.:

INSERT INTO users (username, firstname, lastname) VALUES
  ('lala', 'lala', 'lala'),
  ('lolo', 'lolo', 'lolo');

Similarly, you can create a schema.sql file (or schema-h2.sql) as well to create your schema:

CREATE TABLE task (
  id          INTEGER PRIMARY KEY,
  description VARCHAR(64) NOT NULL,
  completed   BIT NOT NULL);

Though normally you shouldn’t have to do this since Spring boot already configures Hibernate to create your schema based on your entities for an in memory database. If you really want to use schema.sql you’ll have to disable this feature by adding this to your application.properties:

spring.jpa.hibernate.ddl-auto=none

More information can be found at the documentation about Database initialization.

If you’re using Spring boot 2, database initialization only works for embedded databases (H2, HSQLDB, …). If you want to use it for other databases as well, you need to change the spring.datasource.initialization-mode property:

spring.datasource.initialization-mode=always

If you’re using multiple database vendors, you can name your file data-h2.sql or data-mysql.sql depending on which database platform you want to use.

To make that work, you’ll have to configure the spring.datasource.platform property though:

spring.datasource.platform=h2

More Related Contents:

  1. Spring boot – Not a managed type
  2. Disable all Database related auto configuration in Spring Boot
  3. Spring Data – ignore parameter if it has a null value
  4. No property found for type… custom Spring Data repository
  5. Can’t Autowire @Repository annotated interface in Spring Boot
  6. Spring Boot and how to configure connection details to MongoDB?
  7. Configure Multiple MongoDB repositories with Spring Data Mongo
  8. Spring Boot Data JPA – Modifying update query – Refresh persistence context
  9. With Spring Data REST, why is the @Version property becoming an ETag and not included in the representation?
  10. Spring Boot Remove Whitelabel Error Page
  11. Spring Data and Native Query with pagination
  12. What is difference between @RequestBody and @RequestParam?
  13. Spring Boot War deployed to Tomcat
  14. Configure Spring Boot with two ports
  15. How to test Spring’s declarative caching support on Spring Data repositories?
  16. Spring Data optional parameter in query method
  17. Hibernate Transactions and Concurrency Using attachDirty (saveOrUpdate)
  18. Spring Data: “delete by” is supported?
  19. Spring Boot: Is it possible to use external application.properties files in arbitrary directories with a fat jar?
  20. Spring injects dependencies in constructor without @Autowired annotation
  21. Can Spring Data REST’s QueryDSL integration be used to perform more complex queries?
  22. Prevent Spring Boot from registering a servlet filter
  23. How to correctly use PagedResourcesAssembler from Spring Data?
  24. How to get custom user info from OAuth2 authorization server /user endpoint
  25. AFTER upgrade from Spring boot 1.2 to 1.5.2, FileNotFoundException during Tomcat 8.5 Startup
  26. Process Spring Boot externalized property values
  27. Spring Batch skip exception for ItemWriter
  28. Spring Boot JSF Integration
  29. Multiple data source and schema creation in Spring Boot
  30. Configure spring boot to redirect 404 to a single page app [duplicate]

Leave a Comment