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?

Usecase that I work, adds or drops the connection parameters - Hence I have to change the connection string based on the need! — N00b Pr0grammer
– N00b Pr0grammer, Commented Jul 26, 2016 at 8:09

Arthur Noseda · Accepted Answer · 2016-07-26 07:51:36Z

15

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.

answered Jul 26, 2016 at 7:51

Arthur Noseda

2,68421 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

N00b Pr0grammer Over a year ago

You've got a valid point!, whereas I have two versions of MySQL installed, hence used 2 ports for these!

Arthur Noseda Over a year ago

Just thought it worth mentioning.

N00b Pr0grammer Over a year ago

Thanks for the info @Arthur Noseda, your comment definitely helps others! Cheers!

TTCC · Accepted Answer · 2016-07-26 08:03:12Z

13

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&amp;useUnicode=true&amp;useOldAliasMetadataBehavior=true

edited Jul 26, 2016 at 8:03

answered Jul 26, 2016 at 7:37

TTCC

1,0556 silver badges12 bronze badges

4 Comments

user207421 Over a year ago

You need to encode this if the connection string is being held in an XML document. Not otherwise. There is nothing about XML in the question.

Mark Rotteveel Over a year ago

Also jdbc:MySql: is not the prefix of the MySQL driver, that is jdbc:mysql:

TTCC Over a year ago

@MarkRotteveel jdbc:mysql: can be written in uppercase. it doesn't matter

TTCC Over a year ago

@EJP Yes, you're right. But in my work, I always adhere to do that even the connection string is not being held in an XML or properties document, which is still not wrong.

Collectives™ on Stack Overflow

Connection string for MySQL with multiple connection parameters?

2 Answers 2

3 Comments

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related