jdbc mysql sql变量,如何正确传递JDBC url中的会话变量？

I have to increase group_concat_max_len.

I cannot do it by preparestatement, and also I cannot do it in mysql my.conf file.

I found on mysql docs that there is an option to pass session variables in url.

But there is no example, I tried to do it like that:

jdbc.url=jdbc:mysql://xxxx.xx.xx.xx/dbName?sessionVariables=group_concat_max_len:204800

and I have this exception:

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':204800' at line 1

And also I tried it like like this:

jdbc.url=jdbc:mysql://xxxx.xx.xx.xx/dbName?sessionVariables=group_concat_max_len,204800

because the official docs says:

sessionVariables

A comma-separated list of name/value pairs to be sent as SET SESSION ... to the server when the driver connects.

Since version: 3.1.8

Any ideas???

解决方案

Try this:

jdbc.url=jdbc:mysql://xxxx.xx.xx.xx/dbName?sessionVariables=group_concat_max_len=204800