4 Replies Latest reply on Mar 17, 2008 4:59 AM by Mohammad Norouzi

    How to use all available ID as primary key?

    Mohammad Norouzi Novice

      Hi all,

      I have a table that in a slice of time, many records may be deleted and inserted. the record deletion is physically, this table acts as a pool.

      now, I want this table uses deleted IDs for the new records that is going to insert, in other words, if IDs say, 23, 55, 77 are deleted, when I try to add new record, one of these IDs being opted for this record.

      how can I manage this with EJB3? I am welcome if you've got any idea or suggestion, or even if you have any experience I appreciate if you share your knowledge on this.

      thanks