springboot整合H2和JPA

maven添加依赖

<!-- JPA -->

<dependency>

<groupId>org.springframework.boot</groupId>

<artifactId>spring-boot-starter-data-jpa</artifactId>

</dependency>

<!-- H2 -->

<dependency>

<groupId>com.h2database</groupId>

<artifactId>h2</artifactId>

</dependency>

修改springboot配置

application.porperties

#H2

spring.datasource.url=jdbc:h2:file:~/test

spring.datasource.driverClassName=org.h2.Driver

spring.datasource.username =sa

spring.datasource.password =sa

 

spring.datasource.schema=classpath:config/test.sql

#spring.datasource.data=classpath:data.sql

spring.jpa.database-platform=org.hibernate.dialect.H2Dialect

spring.jpa.database = H2

spring.jpa.show-sql = true

spring.jpa.hibernate.ddl-auto = update

spring.h2.console.enabled=true

spring.h2.console.path=/h2_console