From: | Dave Cramer <pg(at)fastcrypt(dot)com> |
---|---|
To: | Daniel Schaedler <postgres-jdbc(at)daniel(dot)schaedler(dot)name> |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: problem to get nextval of a sequence |
Date: | 2004-12-28 13:08:27 |
Message-ID: | 41D15ACB.8050109@fastcrypt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Daniel,
You have to call ress.next() before you get the value.
Dave
Daniel Schaedler wrote:
> 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.
> at
> org.postgresql.jdbc2.AbstractJdbc2ResultSet.checkResultSet(AbstractJdbc2ResultSet.java:2380)
>
> at
> org.postgresql.jdbc2.AbstractJdbc2ResultSet.getString(AbstractJdbc2ResultSet.java:1821)
>
> at
> org.postgresql.jdbc2.AbstractJdbc2ResultSet.getFixedString(AbstractJdbc2ResultSet.java:2326)
>
> at
> org.postgresql.jdbc2.AbstractJdbc2ResultSet.getLong(AbstractJdbc2ResultSet.java:1935)
>
> at
> org.postgresql.jdbc2.AbstractJdbc2ResultSet.getLong(AbstractJdbc2ResultSet.java:2158)
>
> at org.daniel.pws.store.PostgresStore.newNode(PostgresStore.java:307)
> at org.daniel.pws.store.StoreTester.main(StoreTester.java:71)
> 2004-12-28 13:41:57,983 - not able to get the new nodeID
> ****
>
> executing the query in PostgresSQL directly works, I get the correct
> return value.
> The Query itself seems to be executet, as I get other exceptions if I
> misspell the columnname (e.g.).
> I'm working with Postgres-jdbc: pg80b1-1.308.jdbc3.jar and JDK 1.5.0
>
> someone an Idea?
>
> wishing all a Happy new Year
> Daniel
--
Dave Cramer
http://www.postgresintl.com
519 939 0336
ICQ#14675561
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Cramer | 2004-12-28 13:09:52 | Re: Open connections |
Previous Message | Daniel Schaedler | 2004-12-28 12:45:52 | problem to get nextval of a sequence |