第一次使用的配置是嵌入式的:
spring.datasource.url=jdbc:h2:file:.db/mobile;AUTO_SERVER=TRUE;
导致一旦从IDEA启动项目后,就因为每次只能有一个客户端连接而不能从web端访问;但是一关闭IDEA项目,就无法访问。后来改成了混合式的:
spring.datasource.url=jdbc:h2:~/test;AUTO_SERVER=TRUE;
很好用,但是需要重新改一遍哈哈哈,其实把sql文件留下来就好了。
完整配置application.properties:
spring.datasource.url=jdbc:h2:~/test;AUTO_SERVER=TRUE;
spring.datasource.driverClassName=org.h2.Driver
spring.datasource.username=sa
spring.datasource.password=sa
spring.datasource.data=classpath:mobile.sql
#spring.datasource.schema=classpath:db/schema.sql
#resources/db/schema.sql
#spring.datasource.data=classpath:db/data.sql
#resources/db/data.sql
spring.h2.console.settings.web-allow-others=true
spring.h2.console.path=/h2
spring.h2.console.enabled=true
spring.jpa.database-platform=org.hibernate.dialect.H2Dialect
spring.jpa.generate-ddl=true
spring.jpa.show-sql=true
spring.jpa.hibernate.ddl-auto=update
spring.datasource.platform=h2
logging.level.root=INFO
logging.level.org.hibernate=INFO
logging.level.org.hibernate.type.descriptor.sql.BasicBinder=TRACE
logging.level.org.hibernate.type.descriptor.sql.BasicExtractor=TRACE
logging.level.com.sguess=DEBUG
sql文件见另一篇:
https://blog.csdn.net/qq_45128278/article/details/105590536