title: jaydebeapi set autocommit off for bulk inserts
body: <p>I have many rows to insert into a table and tried doing row by row but it is taking a really long time. i read this link <a href="https://stackoverflow.com/questions/6482004/pythonmysql-bulk-insert">Python+MySQL - Bulk Insert</a> and seems like setting autocommit to be off can speed things up. </p>
  
  <pre><code>import jadebeapi
  
  connection = jaydebeapi.connect('com.teradata.jdbc.TeraDriver', ['jdbc:teradata://some url',USER,PASS], ['tdgssconfig.jar','terajdbc4.jar'],) 
  
  
  cur = connection.cursor()
  connection.jconn.setAutoCommit(False)
  cur.execute('select * from my_table')
  connection.commit()
  </code></pre>
  
  <p>Other queries i perform are:</p>
  
  <pre><code>l = [(1,2,3),(2,4,6).....]
  for tup in l:
      cur.execute('my insert statement')
  #this is the really slow part.
  </code></pre>
  
  <p>When i have the <code>connection.jconn.setAutoCommit(False)</code> i always get this error: </p>
  
  <pre><code>[Teradata Database] [TeraJDBC 15.10.00.14] [Error 3932] [SQLState 25000] Only an ET or null statement is legal after a DDL Statement.
  </code></pre>
  
  <p>When that line and <code>connection.commit()</code> is commented out, the code works fine. What is the right syntax to set autocommit false? </p>