Any better, more idiomatic way to convert SQL ResultSet to a Scala List or other collection type?

Question

I'm using the following naive code to convert a ResultSet to a Scala List:

val rs = pstmt.executeQuery()
var nids = List[String]()
while (rs.next()) {
  nids = nids :+ rs.getString(1)
}
rs.close()

Is there a better approach, something more idiomatic to Scala, that doesn't require using a mutable object?

Answer 1

Why don't you try this:

new Iterator[String] {
  def hasNext = resultSet.next()
  def next() = resultSet.getString(1)
}.toStream

Taken from this answer here

Answer 2

I have a similar problem and my solution is:

Iterator.from(0).takeWhile(_ => rs.next()).map(_ => rs.getString(1)).toList

Hope that will help.