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.
Please see my reply to a related question:
http://www.jboss.org/modules/bb/index.html?module=bb&op=viewtopic&t=