Query:
select count
from table_a;
Retrieve results using:
int count = resultSet.getInt(1);
Problem:
Driver needs to translate index to a column name. In MySQLResultSetMetaData.getColumnName(index), the method getColumnInformation(column).getOriginalName() returns "". If I changed the code to this workaround:
public String getColumnName(final int column) throws SQLException {
String results = getColumnInformation(column).getOriginalName();
if (results == null || "".equals(results))
return results;
}
then it works. This is because getColumnInformation(column).getName() returns "count" which is what is needed in ColumnNameMap.getIndex(name).
I don't know the code deep enough to tell if the workaround above is the best way to address the issue, please advise.