title: Setting noAccessToProcedureBodies using a DriverManagerDataSource bean
body: <p>Hi all fellow Java Geeks, </p>
  
  <p>I have lots of stored procedures in a MySQL database, which I can call successfully from .NET. However, when calling them from Java Spring <code>SimpleJdbcCall.execute()</code> I get an exception telling me that the user doesn't have the privilege to do so. But that is clearly not the case since the same user can access it both from CLI and .NET.</p>
  
  <p>I would therefore like to set this parameter:</p>
  
  <pre><code>noAccessToProcedureBodies=true
  </code></pre>
  
  <p>However, when adding the parameter in my url in the connector bean below, it thinks that the trailing characters are a part of the database name. </p>
  
  <pre><code>&lt;bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"&gt;
  
      &lt;property name="driverClassName"&gt;
          &lt;value&gt;com.mysql.jdbc.Driver&lt;/value&gt; 
      &lt;/property&gt;
  
      &lt;property name="username"&gt;
          &lt;value&gt;user&lt;/value&gt;
      &lt;/property&gt;
  
      &lt;property name="url"&gt;
          &lt;value&gt;jdbc:mysql://192.168.0.1:3306/database/?noAccessToProcedureBodies=true&lt;/value&gt;
      &lt;/property&gt;
  
      &lt;property name="password"&gt;
          &lt;value&gt;powerpass&lt;/value&gt;
      &lt;/property&gt;
  
  &lt;/bean&gt;
  </code></pre>
  
  <p>I have been looking at overriding the <a href="http://static.springsource.org/spring/docs/2.5.x/api/org/springframework/jdbc/datasource/AbstractDriverBasedDataSource.html#getConnectionProperties%28%29" rel="nofollow"><code>getConnectionProperties</code></a> method, but I don't think that's the right approach? </p>
  
  <p>Thanks all</p>