[ARROW-6083] [Java] Refactor Jdbc adapter consume logic

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.15.0
• Component/s: Java
• Labels: pull-request-available
• External issue URL: https://github.com/apache/arrow/issues/22482
• Assignee: Ji Liu
• Reporter: Ji Liu
• Created: 31/Jul/19 12:43
• Updated: 11/Jan/23 07:44
• Resolved: 12/Aug/19 03:09

Description

Jdbc adapter read from ResultSet looks like:

while (rs.next()) {
for (int i = 1; i <= columnCount; i++)

{ jdbcToFieldVector( rs, i, rs.getMetaData().getColumnType(i), rowCount, root.getVector(rsmd.getColumnName(i)), config); }

rowCount++;
}

And in jdbcToFieldVector has lots of switch-case, that is to see, for every single value from ResultSet we have to do lots of analyzing conditions.

I think we could optimize this using consumer/delegate like avro adapter.

Issue Links

• links to: GitHub Pull Request #4978