anorm hack to use row cursors

gistfile1.scala

// hack to get a Stream with a cursor-backed query because anorm doesn't combine the two
private def resultSetToStream(sql: SimpleSql[Row])(implicit c: Connection): Stream[SqlRow] = {
  val stmt = sql.getFilledStatement(c, getGeneratedKeys = false)
  stmt.setFetchSize(1000)
  val rs = stmt.executeQuery()
  val rsMetaData = Sql.metaData(rs)
  val columns = List.range(1, rsMetaData.columnCount + 1)
  def data(rs: java.sql.ResultSet) = columns.map(nb => rs.getObject(nb))
  Useful.unfold(rs)(rs => if (!rs.next()) { rs.getStatement.close(); None } else Some((new SqlRow(rsMetaData, data(rs)), rs)))
}

I tried, and I have to say

1. do not forget to "connection.setAutoCommit(false)" before calling this method.
2. do not forget to "conn.commit()" before closing the connection.