access exclusive lock

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

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

Reply | Threaded
Open this post in threaded view
|

Re: access exclusive lock

Jacques Le Roux
Administrator
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
>