SpringBoot+spring-date-jpa+Hibernate 整合mysql 与sqlserver 配置文件信息

Java 同时被 2 个专栏收录
4 篇文章 0 订阅
2 篇文章 0 订阅

SpringBoot+spring-date-jpa+Hibernate 整合mysql  配置文件


#mysql configure
spring.datasource.url = jdbc:mysql://localhost:3306/popularfeelings?serverTimezone=GMT&characterEncoding=utf-8
spring.datasource.username = root
spring.datasource.password = root
spring.datasource.driverClassName = com.mysql.cj.jdbc.Driver
spring.jpa.database = MYSQL
#stripped before adding them to the entity manager
spring.jpa.properties.hibernate.dialect = org.hibernate.dialect.MySQL5Dialect

# Show or not log for each sql query

spring.jpa.show-sql = true

# Hibernate ddl auto (create, create-drop, update)
spring.jpa.hibernate.ddl-auto = update
# Naming strategy
spring.jpa.hibernate.naming-strategy = org.hibernate.cfg.ImprovedNamingStrategy


SpringBoot+spring-date-jpa+Hibernate 整合sqlserver配置文件


#sqlserver configure
spring.datasource.url = jdbc:sqlserver://localhost:1433;DatabaseName=test1
spring.datasource.username = sa
spring.datasource.password = sa
spring.datasource.driverClassName = com.microsoft.sqlserver.jdbc.SQLServerDriver
spring.jpa.database = SQLSERVER
spring.jpa.properties.hibernate.default_schema = dbo

#test1代表数据库名称
spring.jpa.properties.hibernate.default_catalog= test1

#设置hibernate方言
spring.jpa.properties.hibernate.dialect = org.hibernate.dialect.SQLServer2008Dialect

# Show or not log for each sql query
spring.jpa.show-sql = true
# Hibernate ddl auto (create, create-drop, update)
spring.jpa.hibernate.ddl-auto = update
# Naming strategy
spring.jpa.hibernate.naming-strategy = org.hibernate.cfg.ImprovedNamingStrategy

  • 1
    点赞
  • 1
    评论
  • 1
    收藏
  • 一键三连
    一键三连
  • 扫一扫,分享海报

©️2021 CSDN 皮肤主题: 大白 设计师:CSDN官方博客 返回首页
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、C币套餐、付费专栏及课程。

余额充值