From: | Daniel Schaedler <postgres-jdbc(at)daniel(dot)schaedler(dot)name> |
---|---|
To: | Guillaume Cottenceau <gc(at)mnc(dot)ch> |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: problem to get nextval of a sequence |
Date: | 2004-12-28 13:32:59 |
Message-ID: | 41D1608B.10109@daniel.schaedler.name |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Guillaume Cottenceau wrote:
> Daniel Schaedler <postgres-jdbc 'at' daniel.schaedler.name> writes:
>
>
>>Hi List
>>
>>I try to get the 'nextval' of a sequence:
>>***
>> String query = "SELECT nextval('nodes_nodeid_seq')";
>> pstmt = conn.prepareStatement(query);
>> logger.debug("statement: " + pstmt.toString());
>> ResultSet ress = pstmt.executeQuery();
>> long newID = ress.getLong("nextval"); // <-- Exception
>>***
>>
>>I get the following Exception:
>>***
>>org.postgresql.util.PSQLException: ResultSet not positioned properly,
>>perhaps you need to call next.
>
>
> "perhaps you need to call next".
>
> Have you tried calling next?
uhhh....
....now yes...and it works.
When I expect only one set of data, I never call next. That's why I
ignored the statement.
thanks anyway.
Daniel
From | Date | Subject | |
---|---|---|---|
Next Message | Nico | 2004-12-28 13:33:08 | Re: Open connections |
Previous Message | Guillaume Cottenceau | 2004-12-28 13:19:04 | Re: problem to get nextval of a sequence |