3 Replies Latest reply on Dec 17, 2008 8:34 AM by Joram Barrez

    why the single hibernate oracle sequence

    Eric Pedersson Newbie

      Hi

      Why does the hibernate only use the single oracle database sequence? We tend to use a separate sequence for every table unless we need to have uniqueness across multiple tables.

      Does jBPM use the sequence value in any way? We had the same problem when we used OS Workflow in that the whole framework schema used one sequence [hibernate_sequence] and the application code also required the separate entities to have unique identifiers. We thought that was odd and only found out when we were cleaning up our hibernate mappings and creating separate sequences and OSWorkflow started acting funny. Nast bug.

      Any help would be appreciated as we want to have separate sequences for each table. We don't mind some table sharing a sequence if necessary.

      Eric