Обсуждение: Problem with jdbc, nextval ('myseq'), and rs.getInt (1) - SOLVED

Поиск
Список
Период
Сортировка

Problem with jdbc, nextval ('myseq'), and rs.getInt (1) - SOLVED

От
Felix Morley Finch
Дата:
Well, heck, if I ever need proof I'm not perfect, I just got it :-)

I had this code which gave me a null pointer exception with clumn 1,
or SQLException for column 0:

    seq.execute ("SELECT nextval ('myseq')");
    ResultSet rs = seq.getResultSet ();
    id = rs.getInt (1);

The problem was, I had forgotten to include this statement --

    rs.next ();

which makes it all work fine.

Doh!

--
            ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._.
     Felix Finch: scarecrow repairman & rocket surgeon / felix@crowfix.com
  PGP = 91 B3 94 7C E9 E8 76 2D   E1 63 51 AA A0 48 89 2F  ITAR license #4933
I've found a solution to Fermat's Last Theorem but I see I've run out of room o