CODEWITHSUNDEEP
javamysqljdbc
aleroot
aleroot

Reputation: 72636

Get and SET Database Server Connection Variable with JDBC

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 ?

Upvotes: 3

Views: 5690

Answers (1)

Gigab0rt
Gigab0rt

Reputation: 302

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

Upvotes: 10

Related Questions