title: in Grails can you use both sql.newInstance and Domain class calls in the same method?
body: <p>Can you have code that looks like this?</p>
  
  <pre><code>def methodname ()
  {
  proc = "sql to call a stored proc"
  def conn = Sql.newInstance(DB_CONN, DB_USERNAME, DB_PASSWORD, "org.postgresql.Driver")
  def result1 = conn.rows(proc)
  def result2 = MyClass.Find("from MyClass where foo='bar'")
  return [result1, result2]
  }
  </code></pre>
  
  <p>If so are they using different connections?  Is there any way to get the call to the stored proc to use the same connection as the MyClass call?</p>