Getting the error "java.sql.SQLException: After end of result set" when using ResultSet .getArray()

Question

I'm trying to get a table from my SQL database using a select distinct query and then putting it into an array. However, I am getting an error when I try to save the array as a variable.

Code:

private ResultSet query(String query) throws SQLException {
    assert testConn();
    try {
        Statement statement = connection.createStatement();
        return statement.executeQuery(query);
    } catch (SQLException e) {
        e.printStackTrace();
    }
    throw new SQLException();
}


private boolean testConn(){
    try {
        return connection.isValid(1);
    } catch (SQLException e){
        return false;
    }
}

@Test
void test_rs(){
    try {
        ResultSet rs = query("select distinct client_id from email_filtering_scores;");
        Array a = rs.getArray("client_id");
        String[] set = (String[])a.getArray();
        System.out.println(Arrays.deepToString(set));
    } catch (SQLException e) {
        e.printStackTrace();
    }
}

I don't know why this is throwing the SQLException so any help is appreciated.

Thanks in advance.

PS. I don't know what best practice is for using jdbc so if there's anything that egregious with my code I would love some advice.

my initial attempt at fixing it was based on this response here — Max Lyman
– Max Lyman, Commented May 22, 2020 at 19:33
What is data type of client_id ? You can use Object also for unknow type — Eklavya
– Eklavya, Commented May 22, 2020 at 19:41

0xh3xa · Accepted Answer · 2020-05-22 19:46:43Z

2

Just check if the resultset has values using next()

    if (rs.next()) {
        Array a = rs.getArray("client_id");
        String[] set = (String[]) a.getArray();
        System.out.println(Arrays.deepToString(set));
    }

answered May 22, 2020 at 19:46

0xh3xa

4,8672 gold badges17 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Max Lyman Over a year ago

This is the same answer I came to.

Collectives™ on Stack Overflow

Getting the error "java.sql.SQLException: After end of result set" when using ResultSet .getArray()

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related