Re: problem to get nextval of a sequence

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?

--
Guillaume Cottenceau