access exclusive lock

[SkipDever]

I am about to bring another server online that will share a postgres
database with another server.

I am worried about generating sales order numbers that are unique.  It is
trivial if I can get an "access exclusive lock" on the PartyAcctgPreference
table.  In postgres I can do this with a LOCK table in ACCESS EXCLUSIVE  ...
COMMIT

Can I do something similiar in Ofbiz?

Thanks in advance

Skip

[Jacques Le Roux]

Check https://issues.apache.org/jira/browse/OFBIZ-2353. It might help

Jacques

From: "SkipDever" <[hidden email]>

>I am about to bring another server online that will share a postgres
> database with another server.
>
> I am worried about generating sales order numbers that are unique.  It is
> trivial if I can get an "access exclusive lock" on the PartyAcctgPreference
> table.  In postgres I can do this with a LOCK table in ACCESS EXCLUSIVE  ...
> COMMIT
>
> Can I do something similiar in Ofbiz?
>
> Thanks in advance
>
> Skip
>