Return an array after querying database in Java

Question

I have to query a MSSQL database and I want the result of the query to returned as a Array or ArrayList. I have a this code now, but it gives an error. I have a connection to the database so that's not the problem. ``` public ArrayList queryResult(String q) throws SQLException { ArrayList array = new ArrayList<>(); Statement statement = this.getConnection().createStatement(); ResultSet rs = statement.executeQuery(q); while(rs.next()) { Array n = rs.getArray(rs.getRow()); System.out.println(n); array.add(n); } return array; } ``` I get the following error ``` Exception in thread "main" com.microsoft.sqlserver.jdbc.SQLServerException: This operation is not supported. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190) at com.microsoft.sqlserver.jdbc.SQLServerResultSet.NotImplemented(SQLServerResultSet.java:750) at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getArray(SQLServerResultSet.java:2625) at server.Database.queryRe…

Accepted Answer

`getArray()` returns the value of a particular column of the current row as an array. See this - http://docs.oracle.com/javase/6/docs/api/java/sql/ResultSet.html#getArray%28int%29

If you want to get row values as array then you have to write code for that some thing like this.

```
while (rs.next()){
     java.util.ArrayList alRowData = new java.util.ArrayList();
     java.sql.ResultSetMetaData rsmd = rs.getMetaData();
     int numberOfColumns = rsmd.getColumnCount();
     for(int columnIndex = 1; columnIndex <= numberOfColumns; columnIndex ++){
          alRowData.add(rs.getObject(columnIndex));
     }
     System.out.println(alRowData);
}
```

Return an array after querying database in Java

Solution

Problem