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.