Hi Saviola, ID generation is standard jBPM or Hibernate. If you take a look at the db tables you'll see that the sequence is used for everyting. Logs, variables, processDefinitions, processInstances, tokens, whatever. So its not really that hard to get to 5000000.
Sequence value use does not mean that all this data is persisted indefinately. All logs etc. are held for 7 days and then deleted. So its not really a question of db size. I think the tablespace is set to something like 600 mb - 1 gb. The system is 14 days short of production, so if I vanish from this screen in two weeks you know something went badly wrong and I'm in hiding. And as a question of principle: numbers are not a scare resource. Last time I checked we have a unlimited supply. And you only get into trouble if you assume a system won't reach it's limits. The archiving / document management system I'm integrating here reuses queue IDs after entries are removed from the queue. It took me three days to figure that one out. I just didn't think anybody could be that stupid. (They are using alphanumeric ids with a huge range of values so there was absolutely no reason to do this.) Ok this turned into a rant... but I think you get my point. Greetings Rainer View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3917856#3917856 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3917856 ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 _______________________________________________ JBoss-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-user
