title: How to set connection timeout in groovy sql?
body: <p>Is there a way to set connection timeout in groovy sql, also what is the default connection timeout? I checked official doc <a href="http://docs.groovy-lang.org/latest/html/gapi/groovy/sql/Sql.html" rel="nofollow">here</a> but did not get anything. Below is my code.</p>
  
  <pre><code>private final def dev_env = [
      url:"jdbc:oracle:thin:@//aguat:1521/orcl",
      user:"ricky",
      password:"ricky",
      driver:"oracle.jdbc.OracleDriver"
  ]
  def query="select * from emp where email=?"
  def keys=["ricky@gmail.com"]
  def Sql sql = Sql.newInstance(dev_env)
  def results = []
  sql.eachRow(query,keys){row -&gt;
      def resultMap = [:]
      row.toRowResult().each {k,v-&gt; resultMap.put(k,v) }
      results &lt;&lt; resultMap            
  }
  </code></pre>
  
  <p>Groovy version: 1.8.6</p>
  
  <p>Please help</p>