Environment:
- VPS, Java, MySQL, Wildfly 32 and other. The wildfly is configured as domain mode, in my domain.xml I defined a datasource as “jdbc:mysql://xxx.xxx.xx.xxx:3306/db_medical?userSSL=true?zeroDateTimeBehavior=CONVERT_TO_NULL”. When I test the connection in wildfly console manager clicking in datasource test button I receive this error "WFLYJCA0040: failed to invoke operation: java.lang.IllegalStateException:
WFLYJCA0047: Connection is not valid Caused by: jakarta.resource.ResourceException:
jakarta.resource.ResourceException: IJ031084: Unable to create connection Caused by:
jakarta.resource.ResourceException: IJ031084: Unable to create connection Caused by:
com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago.
The driver has not received any packets from the server. Caused by:
com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago.
The driver has not received any packets from the server. Caused by:
java.net.ConnectException: Connection refused".
How to solve this?
Thanks.