Pfthb

You can simply create a data.sql file (or data-h2.sql if you only want it to be applied in case H2 is your database) in your src/main/resources folder and it will be automatically executed on startup. In this file you just 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 I just want to insert simple test data I often implement a ApplicationRunner. Implementations of this interface are run at application startup and can use e.g. a autowired repository to insert some test data.

I think such an implementation would be slightly more explicit than yours because the interface implies that your implementation contains something you would like to do directly after your application is ready.

Your implementation would look sth. like this:

@Component
public class DataLoader implements ApplicationRunner 

 private UserRepository userRepository;

 @Autowired
 public DataLoader(UserRepository userRepository) 
 this.userRepository = userRepository;
 

 public void run(ApplicationArguments args) 
 userRepository.save(new User("lala", "lala", "lala"));
 

As suggestion try this:

@Bean
public CommandLineRunner loadData(CustomerRepository repository) 
 return (args) -> 
 // save a couple of customers
 repository.save(new Customer("Jack", "Bauer"));
 repository.save(new Customer("Chloe", "O'Brian"));
 repository.save(new Customer("Kim", "Bauer"));
 repository.save(new Customer("David", "Palmer"));
 repository.save(new Customer("Michelle", "Dessler"));

 // fetch all customers
 log.info("Customers found with findAll():");
 log.info("-------------------------------");
 for (Customer customer : repository.findAll()) 
 log.info(customer.toString());
 
 log.info("");

 // fetch an individual customer by ID
 Customer customer = repository.findOne(1L);
 log.info("Customer found with findOne(1L):");
 log.info("--------------------------------");
 log.info(customer.toString());
 log.info("");

 // fetch customers by last name
 log.info("Customer found with findByLastNameStartsWithIgnoreCase('Bauer'):");
 log.info("--------------------------------------------");
 for (Customer bauer : repository
 .findByLastNameStartsWithIgnoreCase("Bauer")) 
 log.info(bauer.toString());
 
 log.info("");
 

Option 2: Initialize with schema and data scripts

Prerequisites: in application.properties you have to mention this:

spring.jpa.hibernate.ddl-auto=none (otherwise scripts will be ignored by hibernate, and it will scan project for @Entity and/or @Table annotated classes)

Then, in your MyApplication class paste this:

@Bean(name = "dataSource")
public DriverManagerDataSource dataSource() 
 DriverManagerDataSource dataSource = new DriverManagerDataSource();
 dataSource.setDriverClassName("org.h2.Driver");
 dataSource.setUrl("jdbc:h2:~/myDB;MV_STORE=false");
 dataSource.setUsername("sa");
 dataSource.setPassword("");

 // schema init
 Resource initSchema = new ClassPathResource("scripts/schema-h2.sql");
 Resource initData = new ClassPathResource("scripts/data-h2.sql");
 DatabasePopulator databasePopulator = new ResourceDatabasePopulator(initSchema, initData);
 DatabasePopulatorUtils.execute(databasePopulator, dataSource);

 return dataSource;

Where scripts folder is located under resources folder (IntelliJ Idea)

Hope it helps someone

You can add a spring.datasource.data property to application.properties listing the sql files you want to run. Like this:

spring.datasource.data=classpath:accounts.sql, classpath:books.sql, classpath:reviews.sql

The sql insert statements in each of these files will then be run, allowing you to keep things tidy

You can use something like this:

@SpringBootApplication 
public class Application 

@Autowired
private UserRepository userRepository;

public static void main(String args) 
 SpringApplication.run(Application.class, args);


@Bean
InitializingBean sendDatabase() 
 return () -> 
 userRepository.save(new User("John"));
 userRepository.save(new User("Rambo"));
 ;
 

Spring Boot allows you to use a simple script to initialize your database, using Spring Batch.

Still, if you want to use something a bit more elaborated to manage DB versions and so on, Spring Boot integrates well with Flyway.

See also:

• Spring Boot Database initialization

Here is the way I got that:

@Component
public class ApplicationStartup implements ApplicationListener<ApplicationReadyEvent> 

 /**
 * This event is executed as late as conceivably possible to indicate that
 * the application is ready to service requests.
 */

 @Autowired
 private MovieRepositoryImpl movieRepository;

 @Override
 public void onApplicationEvent(final ApplicationReadyEvent event) 
 seedData();
 

 private void seedData() 
 movieRepository.save(new Movie("Example"));

 // ... add more code
 

Thanks to the author of this article:

http://blog.netgloo.com/2014/11/13/run-code-at-spring-boot-startup/

In Spring Boot 2 data.sql was not working with me as in spring boot 1.5

import.sql

In addition, a file named import.sql in the root of the classpath is executed on startup if Hibernate creates the schema from scratch (that is, if the ddl-auto property is set to create or create-drop).

Note very important if you insert Keys cannot be duplicated do not use ddl-auto property is set to update because with each restart will insert same data again

For more information you vist spring websit

https://docs.spring.io/spring-boot/docs/current/reference/html/howto-database-initialization.html

You can simply create a import.sql file in src/main/resources and Hibernate will execute it when the schema is created.

If someone are struggling in make this to work even following the accepted answer, for me only work adding in my src/test/resources/application.yml the H2 datasource details:

spring:
 datasource:
 platform: h2
 url: jdbc:h2:mem:test;DB_CLOSE_DELAY=-1
 driver-class-name: org.h2.Driver
 username: sa
 password:

I solved similar problem this way:

@Component
public class DataLoader 

 @Autowired
 private UserRepository userRepository;

 //method invoked during the startup
 @PostConstruct
 public void loadData() 
 userRepository.save(new User("user"));
 

 //method invoked during the shutdown
 @PreDestroy
 public void removeData() 
 userRepository.deleteAll();
 

you can register and event listener to achieve that like below:

@EventListener
public void seed(ContextRefreshedEvent event) 
 userRepository.save(new User("lala", "lala", "lala"));

When the ContextRefreshEvent is fired, we get access to all autowired beans in the application — including models and repositories.

This will also work.

 @Bean
 CommandLineRunner init (StudentRepo studentRepo)
 return args -> 
 // Adding two students objects
 List<String> names = Arrays.asList("udara", "sampath");
 names.forEach(name -> studentRepo.save(new Student(name)));
 ;
 

The most compact (for dynamic data) put @mathias-dpunkt solution into MainApp (with Lombok @AllArgsConstructor):

@SpringBootApplication
@AllArgsConstructor
public class RestaurantVotingApplication implements ApplicationRunner 
 private final VoteRepository voteRepository;
 private final UserRepository userRepository;

 public static void main(String args) 
 SpringApplication.run(RestaurantVotingApplication.class, args);
 

 @Override
 public void run(ApplicationArguments args) 
 voteRepository.save(new Vote(userRepository.getOne(1), LocalDate.now(), LocalTime.now()));