1 Reply Latest reply: Aug 13, 2013 2:42 PM by Cdelahun-Oracle RSS

    Sequence Problem


      We are having a weird sequencing problem with TopLink


      We have a parent with a 1-many child.

      When we do an insert of a parent and multiple child records we get the same sequence number assigned to a child record randomly and then error out with duplicate key error.

      What could be the reason? We have the same sequencing information in the sessions.xml and the mappings. We use the default pre-allocation of 50 and we even tested it by increasing it to 500.


      Has anyone seen this sort of a problem?

      Thanks for the help

        • 1. Re: Sequence Problem

          How have you configured Sequencing for the application, could it be that reads for the sequence number are occurring within your transaction?   Try turning on TopLink logging to Fine or Finest and post what happens for the problem sequence.


          Best Regards,