Question & Answer > View Question

Generate UUIDv4 compliant IDs (or use standard java uuid generator)

Confluence User - 18 Apr, 2018

Hi team,

I am running into problems when moving data from Joget into databases that require the unique identifier to be compliant with UUIDv4 / RFC (for example MS SQL uniqueidentifier column).

Would it be possible to give the option at app or system level to switch between how the UUID is generated? For example the UUID service could use the java standard instead:

import java.util.UUID;

UUID uuid = UUID.randomUUID();

return uuid.toString();

Cheers,

Eric

system;java;uuid

3

Confluence User •

19 Apr, 2018 •

confluenceUser •

•

confluenceUser •

Hi, do you need to use a column type like uniqueidentifier? It would work fine in MS SQL if you just use varchar.

Confluence User •

19 Apr, 2018 •

confluenceUser •

•

confluenceUser •

Hi Anders, I fear we have to as other systems rely on the uniqueidentifier type and we need the performance efficiency with large tables. I can use beanshell hash variables with the code above in some cases but it becomes painful to customize everywhere. Looking at the community version github code it seems a switch between the proprietary id algorithm and java standard should be doable?

Confluence User •

25 Apr, 2018 •

confluenceUser •

•

confluenceUser •

Hi Hugo, Owen Ong and team, any ideas for this one?

Building in the switch would be great (assuming the changes would have to be made in the settings UI and UUID service?).

Cheers,

Eric

1

CSV | Excel | XML | PDF

Your answer

Print

Generate UUIDv4 compliant IDs (or use standard java uuid generator)

3

RELATED QUESTIONS

Your answer

To answer a question you'll need an account.

3.builder-style-679e71b3-793f-49bb-bde9-e514f9b324cd{color:#008C60 !important;}

RELATED QUESTIONS

Your answer.builder-style-35ed6c9f-f974-405d-8b9a-0a90172aa369{color:#008C60 !important; margin-left:10px !important;}

To answer a question you'll need an account.

3

Your answer