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

Поиск
Список
Период
Сортировка
От Felix Morley Finch
Тема Problem with jdbc, nextval ('myseq'), and rs.getInt (1) - SOLVED
Дата
Msg-id 19980510001611.19433.qmail@crowfix.com
обсуждение исходный текст
Список pgsql-interfaces
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

В списке pgsql-interfaces по дате отправления:

Предыдущее
От: Anil Amarakoon
Дата:
Сообщение: Re: [INTERFACES] jdbc can't getResult of "select nextval (seq_name)"
Следующее
От: Byron Nikolaidis
Дата:
Сообщение: Re: [INTERFACES] NEW ODBC DRIVER