title: How to override transaction timeout value for Spring JDBCTemplate during batchUpdate
body: <p>I am calling batch batchUpdate which usually sends more than 50 queries in one call and each update query can potentially update 10,000 records. This entire process is taking time and eventually failing with transaction timeout exception.
  The data source which is defined in springContext.xml is injected to JdbcTemplate through @Qualifier, the transaction timeout which is defined in the springContext.xml is applicable to the entire application, but in this particular transaction I would like to override the transaction timeout value before calling batchUpdate method.</p>
  
  <pre><code>@Qualifier("myDataSource")
    @Autowired
    public void setDataSource(DataSource ds) {
      this.jdbc = new JdbcTemplate(ds);
      jdbc.setFetchSize(10000);
      jdbc.setQueryTimeout(0); // zero means there is no limit
    }
  
    //I want to set custom transaction timeout before calling this from some other methods.
    jdbc.batchUpdate(queries.toArray(new String[0]));
  </code></pre>