2024年5月6日发(作者：)

java连接MySQL时报错，unabletofindvalidcertification。。。

java连接mysql报错信息

05-Dec-2020 13:56:59.027 严重 [localhost-startStop-1] Start 启动过滤器异常

eException: Plugin start error: RecordPlugin.

icationsException: Communications link failure

The last packet successfully received from the server was 356 milliseconds ago. The last packet sent successfully to the server was 351 milliseconds ago.

at lugins(:116)

at JFinal(:53)

at (:63)

at (:49)

at lter(:281)

at ter(:262)

at ationFilterConfig.(:106)

at Start(:4538)

at nternal(:5181)

at (:183)

at ldInternal(:743)

at ld(:719)

at ld(:705)

at WAR(:970)

at nfig$(:1840)

at ors$(:511)

at (:266)

at ker(:1149)

at PoolExecutor$(:624)

at (:748)

Caused by: RecordException: icationsException: Communications link failure

The last packet successfully received from the server was 356 milliseconds ago. The last packet sent successfully to the server was 351 milliseconds ago.

at (:50)

at (:209)

at lugins(:107)

... 19 more

Caused by: icationsException: Communications link failure

The last packet successfully received from the server was 356 milliseconds ago. The last packet sent successfully to the server was 351 milliseconds ago.

at tance0(Native Method)

at tance(:62)

at tance(:45)

at tance(:423)

at NewInstance(:404)

at CommunicationsException(:988)

at ormSocketToSSLSocket(:164)

at ateSSLConnection(:4894)

at dHandshakeWithPluggableAuthentication(:1661)

at shake(:1228)

at nnect(:2253)

at tOneTryOnly(:2284)

at NewIO(:2083)

at tionImpl.(:806)

at 4Connection.(:47)

at tance0(Native Method)

at tance(:62)

at tance(:45)

at tance(:423)

at NewInstance(:404)

at tance(:410)

at t(:328)

at PhysicalConnection(:1461)

at PhysicalConnection(:1525)

at (:734)

at nection(:1060)

at nection(:1056)

at nection(:104)

at (:38)

... 21 more

Caused by: dshakeException: torException: PKIX path building failed: tPathBuilderException: unable to find valid certification path to r

at SSLException(:131)

at (:353)

at (:296)

at (:291)

at icateMessage$erverCerts(:652)

at icateMessage$ificate(:471)

at icateMessage$e(:367)

at e(:376)

at ch(:444)

at ch(:422)

at ch(:183)

at (:154)

at (:1279)

at ndshakeRecord(:1188)

at andshake(:401)

at andshake(:373)

at ormSocketToSSLSocket(:149)

... 43 more

Caused by: torException: PKIX path building failed: tPathBuilderException: unable to find valid certification path to requested target

at d(:439)

at Validate(:306)

at te(:271)

at te(:312)

at rusted(:221)

at erverTrusted(:128)

at icateMessage$erverCerts(:636)

... 55 more

Caused by: tPathBuilderException: unable to find valid certification path to requested target

at (:141)

at Build(:126)

at (:280)

at d(:434)

... 61 more

mysql的配置信息

jdbcUrl = jdbc:mysql://127.0.0.1:3306/wawaji?characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true

user = root

password =root

错误解决

将jdbcUrl中的useSSL去掉即可，修改之后为

jdbcUrl = jdbc:mysql://127.0.0.1:3306/wawaji?characterEncoding=utf8&zeroDateTimeBehavior=convertToNull

user = root

password =root