CODEWITHSUNDEEP
javamysqljdbccursorresultset
Chris
Chris

Reputation: 117

ResultSet.TYPE_FORWARD_ONLY can scroll backwards

I create a TYPE_FORWARD_ONLY ResultSet

statement = connection.createStatement();  // TYPE_FORWARD_ONLY = default
ResultSet resultSet = statement.executeQuery(sqlCommand);

yet, when I do this

resultSet.afterLast();
while (resultSet.previous())
{
    for (int i = 1; i <= numberOfColumns; i++)
    {
        System.out.printf("%-10s", resultSet.getObject(i));
    }
    System.out.println();
}

I get the rows in reverse order, so it is definitely NOT forward only. I expected a runtime-error, something like: "Cannot scroll backwards"

What is wrong in my assumption?

Upvotes: 1

Views: 465

Answers (1)

dreinoso
dreinoso

Reputation: 1689

Your MySQL JDBC driver defaults to a scrollable cursor.

Upvotes: 1

Related Questions