wso2 connection mysql jdbc

Question

i tried to connect an mysql in api manager wso2 jdbc using this url jdbc:mysql://localhost:3306/eemp?allowPublicKeyRetrieval=true&useSSL=false but gets an error:

The data source URL is not accepted by any of the loaded drivers. Cannot load connection class because of underlying exception: com.mysql.cj.exceptions.WrongArgumentException: Malformed database URL, failed to parse the connection string near ';useSSL=false'.

Answer 1

I think you are having the URL as follows.

jdbc:mysql://localhost:3306/db?allowPublicKeyRetrieval=true&useSSL=false

Try the following

jdbc:mysql://localhost:3306/db?allowPublicKeyRetrieval=true&useSSL=false