I was using previously MySQL database and the task Ids, process Ids etc were generated in a sequence automatically like 1, 2, 3, 4....
However, Now I changed my application to Oracle 10G and it seems to be using random ids like 1549, 2000.
I have used Sequence and Triggers for my Tables and It seems to be working. Now my question is If I don't add any sequences to JBPM Tables , will they work fine for over a period of time. What I mean is will their ID's conflict.
If anyone else can tell me what to do to make JBPM Tables use proper ID generation incrementing by 1 , it will be great.
Thanks in Advance.
you can configure the hibernate config files any way you like.... so feel free to do whatever you like.
And yes, duplicate id's will cause problems...