fetchAndConvertDataFromResultSet
Fetches and converts data from a ResultSet into a DataFrame.
Will handle data in the following order:
For each column (inside
readAndPreprocessRowsFromResultSet):Fetches each individual value from the ResultSet using DbType.getValueFromResultSet with the return type defined by DbType.getExpectedJdbcType.
Potentially preprocesses the value using DbType.preprocessValue with the return type defined by DbType.getPreprocessedValueType.
From the resulting list of columns,
List<List<Any?>>, (insidebuildDataFrameFromColumnData):Uses DbType.buildDataColumn to turn each list of values into a DataColumn with the correct structure defined by DbType.getTargetColumnSchema.
Turns the result into a DataFrame.
Return
A DataFrame containing the fetched and converted data.
Parameters
a list containing the column metadata for the table.
the ResultSet object containing the data to be fetched and converted.
the type of the database.
the maximum number of rows to retrieve from the table. null (default) means no limit - all available rows will be fetched.
indicates how the column nullability should be inferred.