[jboss-jira] [JBoss JIRA] Closed: (JBPM-771) Auto-increment long primary keys for process definition and instance are not acceptable for the systems with decentralized database

[Tom Baeyens (JIRA)]

     [ http://jira.jboss.com/jira/browse/JBPM-771?page=all ]

Tom Baeyens closed JBPM-771.
----------------------------

    Resolution: Rejected

for this specific use case, i don't want to change all the long-ids to string-ids.  not for the work it takes, but for the runtime overhead and processing it generates for all the people that will not use it.

there is a workaround: you can write and configure your own id generator that would produce sequences of ids for different nodes like this

node A: 1, 4, 7, 10, 13, ...
node B: 2, 5, 8, 11, 14, ...
node C: 3, 6, 9, 12, 15, ...

the id generators in each node would have to be configured with information like 'i'm node 3 out of 5'

in that case you could do the same with longs instead of using UUIDS

> Auto-increment long primary keys for process definition and instance are not acceptable for the systems with decentralized database
> -----------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: JBPM-771
>                 URL: http://jira.jboss.com/jira/browse/JBPM-771
>             Project: JBoss jBPM
>          Issue Type: Feature Request
>          Components: Core Engine
>    Affects Versions: jBPM 3.1.3
>            Reporter: Andriy Gryn
>         Assigned To: Tom Baeyens
>
> Due to different reasons (e.g. absense of the reliable communication channels) it may be necessary to support decentralized mode when there is several database servers containing partial data (e.g. one database server per region) that are replicated from time to time to the central database to build consolidated system. ProcessDefinition and ProcessInstance have now long primary key with native generator. In the scenario with decentralized database this approach will not work. Instead GUIDs could to be used as primary keys for objects that are to be consolidated to central database.  It seems that currently modification required to support decentralized mode.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira