John T. Dow wrote:
> Certainly that piece of code can be made more efficient. One query ought to be able to return all the primary keys.
It's not the PKs it is after (it's already worked those out earlier),
it's the column names to select to populate the rest of the resultset.
But yes, it could be more efficient. We'd need a static String[]
Field.getColumnNames(Connection,Field[]) method or similar.
-O