I am creating a jsp that accesses an SQL db through an ODBC connection. I can successfully read all fields but one in particular keeps giving me an "Invalid Descriptor Index" which sounds to me like it can't find that field name even though it is the correct name. There's nothing out of the ordinary about the data either. Just a simple text field. Any ideas what could be causing this?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Invalid Descriptor Index...Why!?
- Thread starter BillyKrow
- Start date
- Thread starter
- #2
In reading an old post I discovered that by placing the rs.getXXX commands in the order that the fields appear you can avoid this error. So in other words you can't read fields, even withing the same row, in random order. Can someone please tell me this isn't the only way to avoid this error or give me an explanation why it has to be this way since it's on my top five list of biggest pains I've ever encountered while programming.
- Status
Similar threads
- Locked
- Question