Hi,

I have a method which maps resultsets to objects - one row only in this
method.

I have several different SQL, with different columns selected - each
using the same method.

Is the following expensive to execute for every column for every row?

try {
   rset.findColumn(columnName);
} catch (SQLException se) {

}

I use it to check that the column is in the resultset - prior to
executing the copy of the value to the model.  Is this too expensive to
run - if I had 100 rows returned with 10 columns, it would run a 1000
times.  But perhaps this is negligible compared to other overhead?

Is there a better way to execute the various getString, getInt etc. for
only columns in the resultset?

thanks

Tim