DatabaseMetaData.getColumns returns rs with unexpected order
Status: Beta
Brought to you by:
rohanr2
I am trying to use Ashpool in an application
development framework. It tries to do some
introspection on tables by doing:
DatabaseMetaData.getColumns(null, "%", tableName, "%")
and then checking the returned recordset for:
- The column name in columnIndex 4
- The column size in columnIndex 7
- If it allows nulls in columnIndex 11
Ashpool does not return a compatible recordset. I don't
know if this is a jdbc requirement, but other databases
return a recordset with columns ordered by the javadoc
description of getColumns.
thanks,
mike