In Scala 2.12, I am trying to convert two columns from a MySQL query into two arrays, before combining the two arrays into one as below

```
val url = "jdbc:mysql://00.0.0.00:3306/dataanalysis"
val driver = "com.mysql.jdbc.Driver"
val username = "xxxx"
val password = "yyyy"
var connection:Connection = _

  Class.forName(driver)

  connection = DriverManager.getConnection(url, username, password)
  val statement = connection.createStatement
  val rs1 = statement.executeQuery("" +
    "select BBK,date_format(min(date(AAA)),'%Y%m%d') as AAA from OPER_MEMB_AAAD " +
    "where AAF between '2020/07/01' and '2020/07/31' " +
    "group by BBK order by BBK")

val strBBKArray=new Iterator[String] {
    def hasNext = rs1.next()
    def next() = rs1.getString(1)
 }.toArray

val strAAAArray=new Iterator[String] {
  def hasNext = rs1.next()
  def next() = rs1.getString(2)
}.toArray

```

val strRs1Array=Array(strBBKArray,strAAAArray)

It worked with column BBK but not AAA.

```
val strBBKArray: Array[String] = Array(1211212,2324324...
val strAAAArray: Array[String] = Array()

```

When I have strAAAArray filled with element before strBBKArray, column AAA is converted into an Array but no BBK. My guess is the iterator went to the bottom of rs1 for the first column and it found no more records when I wanted to iterate again. How can I get the iterator back to the first row of rs1 or there is a better way of converting a multi-column recordset into one Array?