You can set unique "sequenced-id-prefix" value for the delegator in entityengine.xml for each ofbiz instance. This will ensure that the all the sequence generated from a ofbiz instance have prefix attached to primary key. This makes is easy to identify between two different instances.
Pradeep On 7/31/07, Akotaobi, Uche <[EMAIL PROTECTED]> wrote: > [jin1212] > > > Hello, > > Our company has the need to physically have > > accounting/manufacturing portion of Ofbiz on server A, and > > e-commerce apps on server B,C,D .. etc. > > The servers will have to communicate through web services > > call provided all relevent services have 'export' flag set to > > true. I would like to know if this is even possible > > > Sure--Apache Axis makes web service calls pretty simple. > > > > because Ofbiz uses a a single database for all its applications. > > > That's easily changed in framework/entity/config/entityengine.xml. Either > add a new <group-map/> with a different name and then refer to that group for > all of your custom entities or edit the existing org.ofbiz group-map. Change > the "localderby" to something else like "localpostgres", add the JDBC driver > to framework/entity/lib/jdbc, and edit the JDBC connection settings. > > http://ofbiz.apache.org/docs/entity.html > > > > I can see issues right now with database syncing. For example, different > > products with same id. Unless there is a way to identify the global > > productId from a clientProductId, I just dont see how this can be done. > > > How about making a "MachineInfo" entity with a "machineId" field and > "run-install-seed"ing it with a different GUID for each server? Then you > could have your services return that ID, combine it with an existing field to > make a new primary key, or whatever. The possibilities are limitless. > > > -- > Uche O. Akotaobi > Workflow Engineer > Xerox Corporation > 701 South Aviation Blvd., ESAE-116 > El Segundo, CA 90245 > Phone (310) 333-2403 Internal 8*823-2403 > Fax (310) 333-8419 > [EMAIL PROTECTED] > > XEROX > Technology. Document Management. Consulting Services > > www.xerox.com >