3 Replies Latest reply on Apr 2, 2002 9:53 AM by Adrian Brock

    duplicate entries in db

    Phil Lewis Newbie

      For something we really believe shouldn't happen...

      We have an entity, and a process that runs in batches creating instances of this entity.

      The process checks to see whether anything in the dB should cause a conflict with the entity about to be created - not on the primary key, but on the value in a (string) field.

      However, the process is resulting in rows in the database with duplicate values in this string field.

      Now we can probably get round this by changing the schema a bit, but I am interested to know how this could be happening.

      Any thoughts would be helpful. We are using TRANSACTION_READ_COMMITTED, and the process has transaction-attribute required, the entity transaction-attribute supports. The process component (session bean) is called repeatedly by a Servlet.