title: Get and SET Database Server Connection Variable with JDBC
body: <p>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 : </p>
  
  <pre><code>SET sql_mode='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION,PIPES_AS_CONCAT';
  </code></pre>
  
  <p>for enabling pipe string concatenation ...</p>
  
  <p>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 ?</p>
  
  <p>What is the best way to set or retrieve database server variable with a JDBC Connection ?</p>