title: Spring JdbcTemplate "insert into.. select from.." not working
body: <p>I am trying to execute following SQL with Spring JdbcTemplate:</p>
  
  <pre><code>INSERT INTO japan_wht.PIVOT_20427002(doc_header_text, value_date, total_amt, is_refund)                    
   (SELECT 
      doc_header_text, DATE(value_date), SUM(LOCAL_CCY_AMT), is_refund
   FROM
      (SELECT 
          *
      FROM
          japan_wht.DATA_20427002
      WHERE IS_REFUND in ('N')
      ) t 
  GROUP BY DATE(value_date) , doc_header_text, is_refund)
  </code></pre>
  
  <p>However, it does not insert anything into database table and no error is thrown.</p>
  
  <p>When I tried to execute following SQL with JdbcTemplate, it works and inserts data in DB table:</p>
  
  <pre><code>INSERT INTO japan_wht.PIVOT_20427002(id, doc_header_text, value_date, total_amt, is_refund) values('1', '1', '2017-12-31', 3000, 'Y');
  </code></pre>
  
  <p>Below is my call to execute above SQLs:</p>
  
  <pre><code>jdbcTemplate.update(sqlString);
  </code></pre>
  
  <p>Not sure what is going wrong here.</p>