Re: problem to get nextval of a sequence - Mailing list 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