title: How to add SELECT statements in addBatch()?
body: <p>Hi I am trying to execute couple of queries in a batch by using <code>statement.addBatch(sql)</code> Now I have found that if query is <code>SELECT BLAH BLAH</code> then it throws Exception saying <code>BatchUpdateExecption</code> So how do I add SELECT statement inside batch. For e.g. the following does not work because on batch contains SELECT statement</p>
  
  <pre><code>st.addBatch("UPDATE")
  st.addBatch("CREATE")
  st.addBatch("SELECT")
  st.executeBatch()
  </code></pre>
  
  <p>One work around is I execute SELECT statement in <code>st.execute("SELECT")</code> instead of <code>st.addBatch("SELECT")</code>. Are there any recommended ways or best practice for this usecase? Please guide thanks in advance.</p>