Hi Jayachandra, Register new group in entityengine.xml with new name and data resource;
<group-map group-name="your.group.name" datasource-name="yourDataResourceName"/> Add new data resource entry in the entityengine.xml like we have many. In your case entityengine will contains two entry as localmysql and localmysql2 (or any name you prefer). Now register all the entities with "your.group.name" in entity-group.xml. Refer <group-map group-name="org.apache.ofbiz.tenant" datasource-name="localderbytenant"/> and related entries for more details. HTH! Rishi Solanki Sr Manager, Enterprise Software Development HotWax Systems Pvt. Ltd. Direct: +91-9893287847 http://www.hotwaxsystems.com www.hotwax.co On Tue, Mar 20, 2018 at 3:45 PM, Rajesh Mallah <mallah.raj...@gmail.com> wrote: > Hi Jaya , > > thanks for sharing the interesting details . Pls allow some time for > detailed reply > which database do you use btw? > > regds > Mallah. > > On Tue, Mar 20, 2018 at 2:40 PM, jayachandr...@gmail.com < > jayachandr...@gmail.com> wrote: > > > > > > > On 2018/03/19 15:23:07, Rajesh Mallah <mallah.raj...@gmail.com> wrote: > > > Hello Jaya , > > > > > > Could you consider hinting why you would want certain entities in a > > > separate database? > > > What are you trying to achieve? > > > > > > regds > > > mallah. > > > > > > > > > On Mon, Mar 19, 2018 at 8:23 PM, jayachandr...@gmail.com < > > > jayachandr...@gmail.com> wrote: > > > > > > > Hi All, > > > > > > > > In Ofbiz I want to create separate database for inventory module > with > > > > dependency tables like InentoryItem & so on. I don't see any issue > > foreign > > > > key relations between dependency tables(like product, order related) > > but i > > > > see the view entities are using many places in application hence some > > of > > > > the inventory process may breaks. > > > > > > > > Appreciate the response/solution for this. Thanks for advance. > > > > > > > > Below are the tables list and view entity list. > > > > > > > > Inventory Entities > > > > --------------------------- > > > > > > > > InventoryItem > > > > InventoryItemDetail > > > > InventoryItemAttribute > > > > InventoryItemStatus > > > > InventoryItemTempRes > > > > InventoryItemType > > > > InventoryItemTypeAttr > > > > InventoryItemVariance > > > > InventoryTransfer > > > > OldOrderItemInventoryRes > > > > PhysicalInventory > > > > InventoryItemLabel > > > > InventoryItemLabelAppl > > > > InventoryItemLabelType > > > > OrderItemShipGrpInvRes > > > > > > > > > > > > View Entity with depenndencies > > > > -------------------------------- > > > > > > > > OrderHeaderItemAndInv(Not in use) > > > > MemberEntity > > > > ------------- > > > > OrderHeader > > > > OrderItem > > > > OrderItemShipGrpInvRes > > > > OrderHeaderItemAndInvRoles(Not in use) > > > > MemberEntity > > > > ------------- > > > > OrderHeader > > > > OrderItem > > > > OrderRole > > > > OrderItemShipGrpInvRes > > > > > > > > OrderItemAndShipGrpInvResAndItem - Using to calculation time of > > inventory > > > > MemberEntity > > > > ------------ > > > > OrderItem > > > > OrderItemShipGrpInvRes > > > > InventoryItem > > > > > > > > OrderItemAndShipGrpInvResAndItemSum - Packing time using in ofbiz > > > > MemberEntity > > > > ------------ > > > > OrderItem > > > > OrderItemShipGrpInvRes > > > > InventoryItem > > > > > > > > OrderItemShipGrpInvResAndItem - Reserve time usage in ofbiz > > > > MemberEntity > > > > ------------ > > > > InventoryItem > > > > OrderItemShipGrpInvRes > > > > > > > > ProductInventoryItem - Prouction usage > > > > MemberEntity > > > > ------------ > > > > Product > > > > InventoryItem > > > > > > > > ProductInventoryItemAndItemIssuance > > > > MemberEntity > > > > ------------ > > > > Product > > > > InventoryItem > > > > ItemIssuance > > > > > > > > ItemIssuanceAndInventoryItem > > > > MemberEntity > > > > ------------ > > > > ItemIssuance > > > > InventoryItem > > > > ItemIssuanceInventoryItemAndProduct > > > > MemberEntity > > > > ------------ > > > > ItemIssuance > > > > InventoryItem > > > > Product > > > > > > > > ProductInventoryItemAndItemIssuance > > > > MemberEntity > > > > ------------ > > > > Product > > > > InventoryItem > > > > ItemIssuance > > > > > > > > InventoryItemAndDetail > > > > MemberEntity > > > > ------------ > > > > InventoryItem > > > > InventoryItemDetail` > > > > > > > > WorkEffortAndInventoryAssign > > > > MemberEntity > > > > ------------ > > > > InventoryItem > > > > WorkEffortInventoryAssign > > > > WorkEffortAndInventoryProduced` > > > > MemberEntity > > > > ------------ > > > > WorkEffortInventoryProduced > > > > InventoryItem > > > > > > > > > > > > > > > > > > > > > > > > Facility Related Entities > > > > ------------------------- > > > > > > > > Facility > > > > FacilityAttribute > > > > FacilityContactMechPurpose > > > > FacilityContent > > > > FacilityGroup > > > > FacilityGroupMember > > > > FacilityGroupRole > > > > FacilityGroupRollup > > > > FacilityGroupType > > > > FacilityLocation > > > > FacilityLocationGeoPoint > > > > FacilityParty > > > > FacilityType > > > > FacilityTypeAttr > > > > ProdCatalogInvFacility > > > > OldFacilityRole > > > > ProductFacility > > > > ProductFacilityLocation > > > > ProductStoreFacility > > > > > > > > > > > > View Entity depenndency > > > > --------------------------- > > > > > > > > ProductStoreFacilityByOrder(Use In ShipmentForms.xml) > > > > MemberEntity > > > > ------------ > > > > OrderHeader > > > > ProductStoreFacility > > > > ProductStore > > > > Facility > > > > > > > > FacilityAndContactMech(Use in OrderView.groovy) > > > > MemberEntity > > > > ------------ > > > > Facility > > > > FacilityContactMech > > > > ContactMech > > > > > > > > FacilityLocationAndGeoPoint(Use in FacilityLocationGeoLocation. > groovy > > and > > > > EditFacilityLocation.ftl) > > > > MemberEntity > > > > ------------ > > > > FacilityLocation > > > > FacilityLocationGeoPoint > > > > GeoPoint > > > > ProductFacilityAndPostalAddress(Not in Use) > > > > MemberEntity > > > > ------------ > > > > ProductFacility > > > > FacilityContactMech > > > > ContactMech > > > > PostalAddress > > > > > > > > Thanks & Regards > > > > Jayachandra > > > > > > > > > > > Hi Rajesh, > > > > I am going to create facility for each supplier(In my case which is > approx > > 300) and each facility has all products info(In my case 7000 products) > > which means i am going to nearly 21 lac records in the entities. > > > > So performing inventory CURD operation on inventory > > tables(reserve/receive) is going to be high. And which may also cause the > > actual performance issue with transactional data (order, product). > > > > To remove dependency with order/product info i am planning to do this. > > > > Thanks & Regards > > Jaya > > > > > > >
