一.错误信息:
2025-06-25 20:25:50.870 ERROR [ai-manage-center,,] --- [ruid-ConnectionPool-Create-1057240219] DruidDataSource : create connection SQLException, url: jdbc:postgresql://10.10.60.227:5432/ai_dify1?sslmode=disable¤tSchema=public, errorCode 0, state 08P01
org.postgresql.util.PSQLException: 通讯协定错误,Session 初始化失败。
at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:815)
at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:150)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:219)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:53)
at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:229)
at org.postgresql.Driver.makeConnection(Driver.java:562)
at org.postgresql.Driver.connect(Driver.java:315)
at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:156)
at com.alibaba.druid.filter.stat.StatFilter.connection_connect(StatFilter.java:251)
at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:150)
at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1659)
at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1723)
at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2838)
二. springboot配置信息:
# 默认数据源设置
spring.datasource.dynamic.primary = default
# 数据源1 (mysql)
spring.datasource.dynamic.datasource.default.url = jdbc:mysql://${DATASOURCE_A_ADDRESS}/ai_manage_center
spring.datasource.dynamic.datasource.default.username = ${DATASOURCE_A_USERNAME}
spring.datasource.dynamic.datasource.default.password = ${DATASOURCE_A_PASSWORD}
spring.datasource.dynamic.datasource.default.driver-class-name = com.mysql.cj.jdbc.Driver
# 数据源2 (PostgreSQL)
# 修改后的PostgreSQL连接配置
spring.datasource.dynamic.datasource.ai-dify.url = jdbc:postgresql://10.101.30.20:5432/dify1?sslmode=disable¤tSchema=public
spring.datasource.dynamic.datasource.ai-dify.username = ai_dify
spring.datasource.dynamic.datasource.ai-dify.password = 123456
spring.datasource.dynamic.datasource.ai-dify.driver-class-name = org.postgresql.Driver
三.maven配置
<dependency>
<groupId>org.postgresql</groupId>
<artifactId>postgresql</artifactId>
<version>42.7.7</version>
</dependency>
四. 解决方案
删除vastbase-jdbc-2.10p.jar,重新启动即可。
按照网上的方案改了一次又一次,最后发现是这个包跟pom里引入的包冲突导致的