hibernate Spring JPA应用程序.属性使用SSL

qfe3c7zg  于 2022-11-14  发布在  Spring
关注(0)|答案(4)|浏览(207)

我正在尝试关闭本地MySQL数据库的SSL。但我无法在Spring Applation.Properties文件中找到执行此操作的实际属性。
我当前的文件是:

# ===============================
# = DATA SOURCE
# ===============================

# Set here configurations for the database connection

# Connection url for the database "test"
spring.datasource.url = jdbc:mysql://localhost:3306/test
spring.datasource.driver-class-name=com.mysql.jdbc.Driver

# Username and password
spring.datasource.username = root
spring.datasource.password = blah

# Keep the connection alive if idle for a long time (needed in production)
spring.datasource.testWhileIdle = true
spring.datasource.validationQuery = SELECT 1

# ===============================
# = JPA / HIBERNATE
# ===============================

# Use spring.jpa.properties.* for Hibernate native properties (the prefix is
# stripped before adding them to the entity manager).

# Show or not log for each sql query
spring.jpa.show-sql = true

# Hibernate ddl auto (create, create-drop, update): with "update" the database
# schema will be automatically updated accordingly to java entities found in
# the project
spring.jpa.hibernate.ddl-auto = update

# Naming strategy
spring.jpa.hibernate.naming-strategy = org.hibernate.cfg.ImprovedNamingStrategy

# Allows Hibernate to generate SQL optimized for a particular DBMS
spring.jpa.properties.hibernate.dialect = org.hibernate.dialect.MySQL5Dialect

我试过spring.datasource.useSSl=false,但不起作用。我也试过spring.datasource.url = jdbc:mysql://localhost:3306/test&useSSL=false

mec1mxoz

mec1mxoz1#

我解决了以下问题:

jdbc:mysql://localhost:3306/test?verifyServerCertificate=false&useSSL=false&requireSSL=false
jchrr9hc

jchrr9hc2#

你不是应该用‘?’吗?而不是‘&’
这是你的

spring.datasource.url =jdbc:mysql://localhost:3306/test&useSSL=false

我想说的是

spring.datasource.url = jdbc:mysql://localhost:3306/test?useSSL=false
0qx6xfy6

0qx6xfy63#

我不喜欢污染java选项或系统属性,它们在应用程序容器中无论如何都是无用的……
您可以通过以下方式编程设置MySQL连接的SSL证书:
Jdbc:mysql://example.com:3306/MYDB?verifyServerCertificate=true&useSSL=true&requireSSL=true&clientCertificateKeyStoreUrl=file:cert/keystore.jks&clientCertificateKeyStorePassword=123456&trustCertificateKeyStoreUrl=file:cert/truststore.jks&trustCertificateKeyStorePassword=123456
它记录在案:

swvgeqrz

swvgeqrz4#

如果你还在寻找它,那么这里有安斯沃斯:
How to add datasource url query parameters as application.properties?

spring.datasource.hikari.data-source-properties.useSSL=false

相关问题