have you done resultset.next() after you retrieve for the pointer to be
pointed on the first row of the resultset.
If you don't do resultset.next(), you will get error, not sure which error
but seems to be the error you have got.
HTH
> Remain Kooollll......,
> Mohamed Ashraf Memon
> Advanced Micro Devices (Singapore)
> TEL : 7969-888 X 39826
> FAX : 4492-360
> DID : 7969-826
> Email : [EMAIL PROTECTED]
>
>
>
> -----Original Message-----
> From: B Alaguselvan [SMTP:[EMAIL PROTECTED]]
> Sent: Saturday, February 05, 2000 8:38 AM
> To: [EMAIL PROTECTED]
> Subject: JDBC problem - Invalid Descriptor Index
>
> Hi All
>
> I am using JRun with IIS. I am connecting to my SQL Server database with
> JDBC-ODBC.
>
> I have a query where i try to retreive data from 5 tables.
>
> it goes something like this:
>
> select t1.a as field1, t2.b as field2, t3.c as field3
> from db1 t1, db2 t2, db3 t3
> where t1.x=t2.x and
> t2.y=t3.y
>
> when i retrieve the value of field1 thru:
>
> String name = rs.getString("field1") or
> String name = rs.getString(1)
>
> I get a sql exception:
> SQLException: [Microsoft][ODBC SQL Server Driver]Invalid Descriptor Index.
>
> Theres no problem with the query. The problem seems to be in accessing the
> value from the result set.
>
> any pointers will be of great help.....
>
> thanks
> Alagu
>
> ==========================================================================
> =
> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
> JSP-INTEREST".
> FAQs on JSP can be found at:
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.html
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
FAQs on JSP can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
