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'.

Why do you have `&` in the URL? Did you copy this from an XML file? Otherwise replace that `&` with `&`. — Mark Rotteveel, Dec 23 '20 at 16:35

score 0 · Answer 1 · answered Dec 23 '20 at 14:19

0

I think you are having the URL as follows.

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

Try the following

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

answered Dec 23 '20 at 14:19

Pubci

3,834
1
13
28

wso2 connection mysql jdbc

1 Answers1