Your right, i was confusing two different issues, my only excuse is
that it was 3:30 in the morning :)

With regards to finding a column number from name what you've
proposed seems fine, as a side note, i presume the jdbc spec doesn't
include the possibility of an ambiguous field? For example, if a
table has 2 columns Col1 and col1, then a search for col1 depends on
the order the search is made as well as the order of the columns as
returned from the database.

eg

loop over columns
check case sensitive
check case insensitive

gives different results to

loop over columns
check case sensitive
loop over fields
check case insensitive

my obvious answer would be to implement it simply and ignore those
who are stupid enough to name the fields the same except for case,
but then again, they will only demand a correction later on :)

JOHN