🚀 go-pugleaf

Hello,

I'm using JDK 1.1.6 (with JBuilder 2), the JDBC-ODBC bridge, and SQL Server
6.5 and have been experiencing some odd behavior from the
ResultSet.getString(String) and ResultSet.getInt(String) methods.  The order
in which I execute the getXXX methods seems to matter for some reason.

For instance, I have a column named "settlement", which is a varchar field.
If I don't call rs.getString("settlement") before I call any of the other
getXXX methods, an SQLException is thrown that says: "[Microsoft][ODBC SQL
Server Driver]Invalid column number"  If I put the getXXX calls in a certain
order (and I haven't figured out the pattern yet), then life is good, no
Exceptions thrown.

I've found that this happens with the ResultSet.getInt(String) method as
well.  It's like there is some kind of problem with the hash tables that the
getXXX methods are using.  On the other hand, it could be some dumb mistake
that I'm making!

Anybody ever see this kind of behavior?

Thanks in advance,

Jason