1 Reply Latest reply on Nov 20, 2003 6:10 PM by Alan Bram

    auto-increment & PostgreSQL

    mike80439 Newbie

      I'd like to be able to call the postgres function nextval from EJBQL. I could then include the value in the call to create. Is there a way to do this?

      I can set my auto-increment field using a db trigger, but the EJB never sees the value.

      Also, does anyone have an example of the postgresql-fetch-seq command in standardjbosscmp-jdbc.xml?

      Thanks a bunch.