Connection string for MySQL with multiple connection parameters?

Question

In reference to this question, I'm trying to frame the connection string to connect to MySQL database with the following connection parameters, but I'm unable to get it right.

I've referred the documentation that the post is referring to, but I'm unable to resolve even after following the instructions. Can anybody help me in this regard?

Connection Parameters that are being used:

• useOldAliasMetadataBehavior=true
• useUnicode=true
• characterEncoding=UTF-8

Normal connection string: jdbc:mysql://localhost:3307/databaseName

Adding these connection parameters and their corresponding values, how would the connection string be?

Answer 1

According to the reference documentation, it would be:

jdbc:mysql://localhost:3307/databaseName?useOldAliasMetadataBehavior=true&unicode=true&characterEncoding=UTF-8

However, the standard port is 3306 not 3307 like in your question.

Answer 2

Just stitch parameters like a url, eg:

jdbc:MySql://localhost:3307/databaseName?characterEncoding=UTF-8&useUnicode=true&useOldAliasMetadataBehavior=true

If your connection string is being held in an XML or properties document, you need to encode & as &, like this:

jdbc:MySql://localhost:3307/databaseName?characterEncoding=UTF-8&useUnicode=true&useOldAliasMetadataBehavior=true