how to get nextval from a sequence

andrea.fontanelli · **Joined:** Tue Aug 24, 2004 6:43 am **Posts:** 3

Hi all,
I have a problem getting nextval form a sequence in Postgres.

I'd like execute the simple SQL code:

select nextval('<my_sequence_in_postgres>')

and return the int value of the nextval of teh sequence.

Could anybody help me?

Thanks and regards,

Andrea

ernst_pluess · **Posted:** Thu Nov 04, 2004 8:43 am

Guess chapter 9.3.6. Queries in native SQL of the reference manual is for you.

HTH
Ernst

andrea.fontanelli · **Joined:** Tue Aug 24, 2004 6:43 am **Posts:** 3

ernst_pluess wrote:

Guess chapter 9.3.6. Queries in native SQL of the reference manual is for you.

HTH
Ernst

HI,
thanks for your answer. I already tryed thi way, but I got thi Exception:

class java.lang.UnsupportedOperationException

this is my source code:

log.debug(session.createSQLQuery("select nextval('contacts_userid_seq')", "", Integer.class).getQueryString());

query = session.createSQLQuery("select nextval('contacts_userid_seq')", "", Integer.class);

Integer nextValue = (Integer)query.iterate().next();

log.debug("Next Value= " + nextValue.intValue());

Why I have this exception?

Something to configure?

Andrea

steveedw · **Joined:** Tue Nov 16, 2004 2:57 pm **Posts:** 1

Here is how I did that:

Code:

            Connection conn = sess.connection();
            
            Statement stmt = conn.createStatement();
            ResultSet res = stmt.executeQuery("select genid_seq_standard.nextval from dual");
            if (res.next())
            {
                nextId = res.getString(1);
            }

andrea.fontanelli · **Joined:** Tue Aug 24, 2004 6:43 am **Posts:** 3

Thank you.
I followed the same way:

conn = HibernateUtil.currentSession().connection();
stmt = conn.createStatement();
rs = stmt.executeQuery("select nextval('"+ ApplicationResource.CONTACT_SEQ + "')");
rs.next();
Integer nextVal = new Integer(rs.getString(1));

Ciao,
andrea