title: Execute Initiating Statements After Connection Is Acquired
body: <p>I'm using Spring JDBC + C3P0. I want to set the 'sql_mode' variable to empty string ''. </p>
  
  <p>First I tried to set it in JDBC url:</p>
  
  <pre><code>DataSource dataSource = new DriverManagerDataSource(
      "jdbc:mysql://127.0.0.1/test?sessionVariables=sql_mode=''",
      "root", "password");
  </code></pre>
  
  <p>But it's not working.</p>
  
  <p>So I'm wondering whether there's a way to execute some statements right after the connection is acquired, such as "SET sql_mode=''".</p>
  
  <p>Thanks.</p>