If you're using the jdbc-odbc bridge I probably know what
you're problem is.
This error is due to the order you're getting the values
from your resultset. When you select a, b, c you have
to getString a, b, c in the same order, not lkike you do it
(a, c, b).
It's a stupid bug...
/Peter Björkman
> Hi all
>
> I was reading the column values in a different order from
> that in the SQL and that was why i was getting that error.
>
> something like:
>
> select a, b, c from table;
>
> String aaa = rs.getString("a");
> String ccc = rs.getString("c");
> String bbb = rs.getString("b");
>
> is this a restriction in jdbc or odbc??
>
> Alagu
> ---------- Original Message ----------------------------------
> From: [EMAIL PROTECTED]
> Date: Wed, 9 Feb 2000 08:58:57 +0800
>
> >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
>
> ==============================================================
> =============
> 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
