Get and SET Database Server Connection Variable with JDBC

Question

When i open a JDBC connection to a MySQL database i want to set some database server variable, so for example every time that a connection is established i want to set the variable sqlmode with this value :

SET sql_mode='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION,PIPES_AS_CONCAT';

for enabling pipe string concatenation ...

I have to send this parameter in a query statement or can i set this parameter directly on the JDBC Connection ? Is there a property on the JDBC connection that allow set this variable ?

What is the best way to set or retrieve database server variable with a JDBC Connection ?

Gigab0rt · Accepted Answer · 2011-09-04 10:47:31Z

10

Have you tried adding it into the getConnection call?

String url = "jdbc:mysql://localhost/test?user=sqluser&password=sqluserpw&sessionVariables=sql_mode='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION,PIPES_AS_CONCAT'";
Class.forName("com.mysql.jdbc.Driver");
Connection c = DriverManager.getConnection(url);

Regards

answered Sep 4, 2011 at 10:47

Gigab0rt

3024 silver badges14 bronze badges

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

2 Comments

Bishnu Prasad Over a year ago

To URL i want to add below SQL mode. Could you please help me how my url will look like. SET @@SQL_MODE = CONCAT(@@SQL_MODE, ',PAD_CHAR_TO_FULL_LENGTH');

gkephorus Over a year ago

I had to use the %3D in the value of the sessionVariables to make it work. But this really helped me, thanks @Gigab0rt.

Collectives™ on Stack Overflow

Get and SET Database Server Connection Variable with JDBC

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related