spring-cloud-config加载配置源码分析：解决sql报错问题

         spring-cloud-config与mysql结合使用的配置中心资料较少，但是spring-cloud-config原理较为简单，源码比较清晰，不妨直接看源码排查问题。

一、问题描述

        使用 spring cloud config配置中心，配置存储为MySQL，spring-cloud-config-server版本为 3.1.5。配置好spring cloud-server端后，能正常启动，指定配置表为 config_properties表，但是client端启动拉取配置时，server端报下面错误：

具体报错堆栈如下：

2024-07-18 18:58:10 [http-nio-8888-exec-1] WARN  o.s.c.c.s.e.EnvironmentController - Error getting the Environment with name=application profiles=dev label=null includeOrigin=true
org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [SELECT "KEY", "VALUE" from PROPERTIES where APPLICATION=? and PROFILE is null and LABEL=?]; nested exception is java.sql.SQLSyntaxErrorException: Table 'config_db.PROPERTIES' doesn't exist
	at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:239)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)
	at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1541)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:667)
	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:713)
	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:744)
	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:763)
	at org.springframework.cloud.config.server.environment.JdbcEnvironmentRepository.addPropertySource(JdbcEnvironmentRepository.java:131)
	at org.springframework.cloud.config.server.environment.JdbcEnvironmentRepository.findOne(JdbcEnvironmentRepository.java:117)
	at org.springframework.cloud.config.server.environment.EnvironmentRepository.findOne(EnvironmentRepository.java:30)
	at org.springframework.cloud.config.server.environment.CompositeEnvironmentRepository.findOne(CompositeEnvironmentRepository.java:64)
	at org.springframework.cloud.config.server.environment.EnvironmentEncryptorEnvironmentRepository.findOne(EnvironmentEncryptorEnvironmentRepository.java:61)
	at org.springframework.cloud.config