I have a situation where I want to delete a set of entries (68) from a database tables via its primary keys. I have a EJB method that loops through the set of primary keys and calls a Storage EJB that in turn calls the database layer to perform the individual delete. What I find is that after 7 records are deleted, the records suddenly reappear in the database. No exceptions are thrown, no apparent rollbacks.
I'm using EJB 2 and the transactions are required.
Any ideas on how to pursue this problem are greatly appreciated.