LBR in oracle

[Carlos Ruiz]

Hi Alan, hi community,

Sorry to write in english, but I don't feel confident enough in google translate to write in portuguese   ;-)

I was asked to do a work to correct and complete LBR in oracle, and I'm glad to contribute the patch of the work involved in that process.

Short summary I made modifications to migration scripts failing in oracle, generated fixed UUIDs for system objects in the scripts, and changed three classes to use UUIDs instead of fixed IDs.

You can see more detailed information on the commit message of the attached patch.

The patch contains all those scripts and modifications for you to consider if you want that imported in LBR.

Initially I had the wish to migrate the scripts to 2packs - but because of time limitations that was not possible and decided to fix the oracle scripts.

However I think is a worthy work if possible to migrate the scripts to 2Packs - enabling the possibility to install LBR in a system that is already running (at this moment that will present conflicts with IDs).

As a suggestion, I would advice in future to avoid migration scripts and stick to just 2packs - I see you're using IDs in the range of 800.000 - but there's no guarantee that other people in iDempiere community can use the same IDs - or that at some point of time in future the official iDempiere IDs arrive to that number.  (Although I hope at some point in future we definitely get rid off IDs and stick to UUIDs in core too).

Regards,

Carlos Ruiz

[Alan Lescano]

Hello Carlos

Great work! thanks for sharing the result. Many contributors made it clear the need for tweaks to fully support oracle, especially some views manually created.

Back in 2013 when the first script was written there were some issues in 2pack, so I decided to use centralized ids instead. 2pack is much better now, and maybe it's ready to handle such big projects like LBR. I already use it some times and find perfect for small customizations.

Best regards,

Alan

--
Você recebeu essa mensagem porque está inscrito no grupo "iDempiereLBR" dos Grupos do Google.
Para cancelar inscrição nesse grupo e parar de receber e-mails dele, envie um e-mail para idempierelbr...@googlegroups.com.
Acesse esse grupo em https://groups.google.com/group/idempierelbr.
Para ver essa discussão na Web, acesse https://groups.google.com/d/msgid/idempierelbr/b7e770ca-4844-404d-9d31-8176a8df26da%40googlegroups.com.
Para mais opções, acesse https://groups.google.com/d/optout.