title: Oracle JDBC Datasource set auto commit property to false to all connections
body: <p>I have this bean:</p>
  
  <pre><code>public DataSource getDatsource() throws SQLException {
      OracleDataSource dataSource = new OracleDataSource();
      dataSource.setUser(userName);
      dataSource.setPassword(password);
      dataSource.setURL(wallet);
      Properties props = new Properties();
      props.put("AutoCommit", false); // not working
      dataSource.setConnectionProperties(props );
      return dataSource;
  }
  </code></pre>
  
  <p>I would set up datasource like all the connection generated from it, has auto commit to false.</p>
  
  <p>How can I do it?</p>
  
  <p>PS I know <code>-Doracle.jdbc.autoCommitSpecCompliant=false</code> and works, but I would set the property hard coded.</p>
  
  <p>Thanks.</p>