ofbiz-notifications mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jacques Le Roux (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (OFBIZ-1607) let the ofbiz work with db2
Date Thu, 06 Jul 2017 07:45:01 GMT

    [ https://issues.apache.org/jira/browse/OFBIZ-1607?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12564306#comment-12564306
] 

Jacques Le Roux edited comment on OFBIZ-1607 at 7/6/17 7:44 AM:
----------------------------------------------------------------

the other configuration to let ofbiz work with the db2
1.change the database pagesize to 16k
2.add two fk-name to two entity's relation, one is PartyInvitationGroupAssoc the other is
PartyInvitationRoleAssoc:
{code}
<entity entity-name="PartyInvitationGroupAssoc"
            package-name="org.ofbiz.party.party"
            title="Party Invitation Group Assoc Entity">
        <field name="partyInvitationId" type="id-ne"></field>
        <field name="partyIdTo" type="id-ne"></field>
        <prim-key field="partyInvitationId"/>
        <prim-key field="partyIdTo"/>
        <relation type="one" title="To" rel-entity-name="PartyGroup">
            <key-map field-name="partyIdTo" rel-field-name="partyId"/>
        </relation>
        <relation type="one" title="To" rel-entity-name="Party">
            <key-map field-name="partyIdTo" rel-field-name="partyId"/>
        </relation>
        <relation type="one" fk-name="PTY_INT_GA_PTY_INT" rel-entity-name="PartyInvitation">
            <key-map field-name="partyInvitationId"/>
        </relation>
    </entity>
    <entity entity-name="PartyInvitationRoleAssoc"
            package-name="org.ofbiz.party.party"
            title="Party Invitation Role Assoc Entity">
        <field name="partyInvitationId" type="id-ne"></field>
        <field name="roleTypeId" type="id-ne"></field>
        <prim-key field="partyInvitationId"/>
        <prim-key field="roleTypeId"/>
        <relation type="one" rel-entity-name="RoleType">
            <key-map field-name="roleTypeId"/>
        </relation>
        <relation type="one" fk-name="PTY_INT_RA_PTY_INT" rel-entity-name="PartyInvitation">
            <key-map field-name="partyInvitationId"/>
        </relation>
    </entity>
    {code}
this avoid the same fk-name problems. I think it's the good habit we need add the fk-name
if there is more than one relation with the same entity.
3.the INVITEM_SOFID and INVITEM_ACTNM index is unique in InventoryItem entity, but The demo
data do not include the unique data. so, when insert the data It will thrown exeception, it
happen in DemoProduct.xml, I add the data like this:
{code}
  <InventoryItem facilityId="WebStoreWarehouse" locationSeqId="TLTLTLUL01"
        inventoryItemId="9000" inventoryItemTypeId="NON_SERIAL_INV_ITEM" productId="GZ-2644"
ownerPartyId="Company" currencyUomId="USD" unitCost="2.5" softIdentifier="9000" activationNumber="9000"/>
    <InventoryItemDetail inventoryItemId="9000" inventoryItemDetailSeqId="0001" effectiveDate="2001-05-13
12:00:00.0" availableToPromiseDiff="500" quantityOnHandDiff="500"/>
    <InventoryItem facilityId="WebStoreWarehouse" locationSeqId="TLTLTLLL01"
        inventoryItemId="9001" inventoryItemTypeId="NON_SERIAL_INV_ITEM" productId="GZ-2644"
ownerPartyId="Company" currencyUomId="USD" unitCost="2.5"  softIdentifier="9001" activationNumber="9001"/>
    <InventoryItemDetail inventoryItemId="9001" inventoryItemDetailSeqId="0001" effectiveDate="2001-05-13
12:00:00.0" availableToPromiseDiff="5" quantityOnHandDiff="5"/>
    <InventoryItem facilityId="WebStoreWarehouse" locationSeqId="TLTLTLUL02"
        inventoryItemId="9002" inventoryItemTypeId="NON_SERIAL_INV_ITEM" productId="GZ-8544"
ownerPartyId="Company" currencyUomId="USD" unitCost="3.0"  softIdentifier="9002" activationNumber="9002"/>
    <InventoryItemDetail inventoryItemId="9002" inventoryItemDetailSeqId="0001" effectiveDate="2001-05-13
12:00:00.0" availableToPromiseDiff="15" quantityOnHandDiff="15"/>
    <InventoryItem facilityId="WebStoreWarehouse" locationSeqId="TLTLTLLL02"
        inventoryItemId="9003" inventoryItemTypeId="NON_SERIAL_INV_ITEM" productId="GZ-8544"
ownerPartyId="Company" currencyUomId="USD" unitCost="3.0"  softIdentifier="9003" activationNumber="9003"/>
    <InventoryItemDetail inventoryItemId="9003" inventoryItemDetailSeqId="0001" effectiveDate="2001-05-13
12:00:00.0" availableToPromiseDiff="3" quantityOnHandDiff="3"/>
    <InventoryItem facilityId="WebStoreWarehouse" locationSeqId="TLTLTLUL03"
        inventoryItemId="9004" inventoryItemTypeId="NON_SERIAL_INV_ITEM" productId="WG-1111"
ownerPartyId="Company" currencyUomId="USD" unitCost="4.5"  softIdentifier="9004" activationNumber="9004"/>
    <InventoryItemDetail inventoryItemId="9004" inventoryItemDetailSeqId="0001" effectiveDate="2001-05-13
12:00:00.0" availableToPromiseDiff="50" quantityOnHandDiff="50"/>
    <InventoryItem facilityId="WebStoreWarehouse" locationSeqId="TLTLTLLL03"
        inventoryItemId="9005" inventoryItemTypeId="NON_SERIAL_INV_ITEM" productId="WG-1111"
ownerPartyId="Company" currencyUomId="USD" unitCost="4.5"  softIdentifier="9005" activationNumber="9005"/>
    <InventoryItemDetail inventoryItemId="9005" inventoryItemDetailSeqId="0001" effectiveDate="2001-05-13
12:00:00.0" availableToPromiseDiff="5" quantityOnHandDiff="5"/>
    <InventoryItem facilityId="WebStoreWarehouse" locationSeqId="TLTLTLUL04"
        inventoryItemId="9006" inventoryItemTypeId="NON_SERIAL_INV_ITEM" productId="WG-5569"
ownerPartyId="Company" currencyUomId="USD" unitCost="5.0"  softIdentifier="9006" activationNumber="9006"/>
    <InventoryItemDetail inventoryItemId="9006" inventoryItemDetailSeqId="0001" effectiveDate="2001-05-13
12:00:00.0" availableToPromiseDiff="10" quantityOnHandDiff="10"/>

    <InventoryItem facilityId="WebStoreWarehouse" inventoryItemId="9010" inventoryItemTypeId="NON_SERIAL_INV_ITEM"
productId="WG-9943-B3" ownerPartyId="Company" currencyUomId="USD" unitCost="3.5"  softIdentifier="9010"
activationNumber="9010"/>
    <InventoryItemDetail inventoryItemId="9010" inventoryItemDetailSeqId="0001" effectiveDate="2001-05-13
12:00:00.0" availableToPromiseDiff="10" quantityOnHandDiff="10"/>
    <InventoryItem facilityId="WebStoreWarehouse" inventoryItemId="9011" inventoryItemTypeId="NON_SERIAL_INV_ITEM"
productId="WG-9943-B4" ownerPartyId="Company" currencyUomId="USD" unitCost="3.5"  softIdentifier="9011"
activationNumber="9011"/>
    <InventoryItemDetail inventoryItemId="9011" inventoryItemDetailSeqId="0001" effectiveDate="2001-05-13
12:00:00.0" availableToPromiseDiff="10" quantityOnHandDiff="10"/>
    <InventoryItem facilityId="WebStoreWarehouse" inventoryItemId="9012" inventoryItemTypeId="NON_SERIAL_INV_ITEM"
productId="WG-9943-S3" ownerPartyId="Company" currencyUomId="USD" unitCost="3.5"  softIdentifier="9012"
activationNumber="9012"/>
    <InventoryItemDetail inventoryItemId="9012" inventoryItemDetailSeqId="0001" effectiveDate="2001-05-13
12:00:00.0" availableToPromiseDiff="10" quantityOnHandDiff="10"/>
    <InventoryItem facilityId="WebStoreWarehouse" inventoryItemId="9013" inventoryItemTypeId="NON_SERIAL_INV_ITEM"
productId="WG-9943-S4" ownerPartyId="Company" currencyUomId="USD" unitCost="3.5"  softIdentifier="9013"
activationNumber="9013"/>
    <InventoryItemDetail inventoryItemId="9013" inventoryItemDetailSeqId="0001" effectiveDate="2001-05-13
12:00:00.0" availableToPromiseDiff="10" quantityOnHandDiff="10"/>

    <InventoryItem facilityId="WebStoreWarehouse" inventoryItemId="9021" inventoryItemTypeId="NON_SERIAL_INV_ITEM"
productId="GZ-1006-1" ownerPartyId="Company" currencyUomId="USD" unitCost="2.4"  softIdentifier="9021"
activationNumber="9021"/>
    <InventoryItemDetail inventoryItemId="9021" inventoryItemDetailSeqId="0001" effectiveDate="2001-05-13
12:00:00.0" availableToPromiseDiff="8" quantityOnHandDiff="8"/>
    <InventoryItem facilityId="WebStoreWarehouse" inventoryItemId="9022" inventoryItemTypeId="NON_SERIAL_INV_ITEM"
productId="GZ-1006-2" ownerPartyId="Company" currencyUomId="USD" unitCost="2.4"  softIdentifier="9022"
activationNumber="9022"/>
    <InventoryItemDetail inventoryItemId="9022" inventoryItemDetailSeqId="0001" effectiveDate="2001-05-13
12:00:00.0" availableToPromiseDiff="8" quantityOnHandDiff="8"/>
    <InventoryItem facilityId="WebStoreWarehouse" inventoryItemId="9023" inventoryItemTypeId="NON_SERIAL_INV_ITEM"
productId="GZ-1006-3" ownerPartyId="Company" currencyUomId="USD" unitCost="2.4"  softIdentifier="9023"
activationNumber="9023"/>
    <InventoryItemDetail inventoryItemId="9023" inventoryItemDetailSeqId="0001" effectiveDate="2001-05-13
12:00:00.0" availableToPromiseDiff="8" quantityOnHandDiff="8"/>
    <InventoryItem facilityId="WebStoreWarehouse" inventoryItemId="9024" inventoryItemTypeId="NON_SERIAL_INV_ITEM"
productId="GZ-1006-4" ownerPartyId="Company" currencyUomId="USD" unitCost="2.4"  softIdentifier="9024"
activationNumber="9024"/>
    <InventoryItemDetail inventoryItemId="9024" inventoryItemDetailSeqId="0001" effectiveDate="2001-05-13
12:00:00.0" availableToPromiseDiff="8" quantityOnHandDiff="8"/>
{code}
4. good luck, if there is any problem please let me know.


was (Author: jack_guo):
the other configuration to let ofbiz work with the db2
1.change the database pagesize to 16k
2.add two fk-name to two entity's relation, one is PartyInvitationGroupAssoc the other is
PartyInvitationRoleAssoc:
<entity entity-name="PartyInvitationGroupAssoc"
            package-name="org.ofbiz.party.party"
            title="Party Invitation Group Assoc Entity">
        <field name="partyInvitationId" type="id-ne"></field>
        <field name="partyIdTo" type="id-ne"></field>
        <prim-key field="partyInvitationId"/>
        <prim-key field="partyIdTo"/>
        <relation type="one" title="To" rel-entity-name="PartyGroup">
            <key-map field-name="partyIdTo" rel-field-name="partyId"/>
        </relation>
        <relation type="one" title="To" rel-entity-name="Party">
            <key-map field-name="partyIdTo" rel-field-name="partyId"/>
        </relation>
        <relation type="one" fk-name="PTY_INT_GA_PTY_INT" rel-entity-name="PartyInvitation">
            <key-map field-name="partyInvitationId"/>
        </relation>
    </entity>
    <entity entity-name="PartyInvitationRoleAssoc"
            package-name="org.ofbiz.party.party"
            title="Party Invitation Role Assoc Entity">
        <field name="partyInvitationId" type="id-ne"></field>
        <field name="roleTypeId" type="id-ne"></field>
        <prim-key field="partyInvitationId"/>
        <prim-key field="roleTypeId"/>
        <relation type="one" rel-entity-name="RoleType">
            <key-map field-name="roleTypeId"/>
        </relation>
        <relation type="one" fk-name="PTY_INT_RA_PTY_INT" rel-entity-name="PartyInvitation">
            <key-map field-name="partyInvitationId"/>
        </relation>
    </entity>
this avoid the same fk-name problems. I think it's the good habit we need add the fk-name
if there is more than one relation with the same entity.
3.the INVITEM_SOFID and INVITEM_ACTNM index is unique in InventoryItem entity, but The demo
data do not include the unique data. so, when insert the data It will thrown exeception, it
happen in DemoProduct.xml, I add the data like this:

  <InventoryItem facilityId="WebStoreWarehouse" locationSeqId="TLTLTLUL01" 
        inventoryItemId="9000" inventoryItemTypeId="NON_SERIAL_INV_ITEM" productId="GZ-2644"
ownerPartyId="Company" currencyUomId="USD" unitCost="2.5" softIdentifier="9000" activationNumber="9000"/>
    <InventoryItemDetail inventoryItemId="9000" inventoryItemDetailSeqId="0001" effectiveDate="2001-05-13
12:00:00.0" availableToPromiseDiff="500" quantityOnHandDiff="500"/>
    <InventoryItem facilityId="WebStoreWarehouse" locationSeqId="TLTLTLLL01" 
        inventoryItemId="9001" inventoryItemTypeId="NON_SERIAL_INV_ITEM" productId="GZ-2644"
ownerPartyId="Company" currencyUomId="USD" unitCost="2.5"  softIdentifier="9001" activationNumber="9001"/>
    <InventoryItemDetail inventoryItemId="9001" inventoryItemDetailSeqId="0001" effectiveDate="2001-05-13
12:00:00.0" availableToPromiseDiff="5" quantityOnHandDiff="5"/>
    <InventoryItem facilityId="WebStoreWarehouse" locationSeqId="TLTLTLUL02" 
        inventoryItemId="9002" inventoryItemTypeId="NON_SERIAL_INV_ITEM" productId="GZ-8544"
ownerPartyId="Company" currencyUomId="USD" unitCost="3.0"  softIdentifier="9002" activationNumber="9002"/>
    <InventoryItemDetail inventoryItemId="9002" inventoryItemDetailSeqId="0001" effectiveDate="2001-05-13
12:00:00.0" availableToPromiseDiff="15" quantityOnHandDiff="15"/>
    <InventoryItem facilityId="WebStoreWarehouse" locationSeqId="TLTLTLLL02" 
        inventoryItemId="9003" inventoryItemTypeId="NON_SERIAL_INV_ITEM" productId="GZ-8544"
ownerPartyId="Company" currencyUomId="USD" unitCost="3.0"  softIdentifier="9003" activationNumber="9003"/>
    <InventoryItemDetail inventoryItemId="9003" inventoryItemDetailSeqId="0001" effectiveDate="2001-05-13
12:00:00.0" availableToPromiseDiff="3" quantityOnHandDiff="3"/>
    <InventoryItem facilityId="WebStoreWarehouse" locationSeqId="TLTLTLUL03" 
        inventoryItemId="9004" inventoryItemTypeId="NON_SERIAL_INV_ITEM" productId="WG-1111"
ownerPartyId="Company" currencyUomId="USD" unitCost="4.5"  softIdentifier="9004" activationNumber="9004"/>
    <InventoryItemDetail inventoryItemId="9004" inventoryItemDetailSeqId="0001" effectiveDate="2001-05-13
12:00:00.0" availableToPromiseDiff="50" quantityOnHandDiff="50"/>
    <InventoryItem facilityId="WebStoreWarehouse" locationSeqId="TLTLTLLL03" 
        inventoryItemId="9005" inventoryItemTypeId="NON_SERIAL_INV_ITEM" productId="WG-1111"
ownerPartyId="Company" currencyUomId="USD" unitCost="4.5"  softIdentifier="9005" activationNumber="9005"/>
    <InventoryItemDetail inventoryItemId="9005" inventoryItemDetailSeqId="0001" effectiveDate="2001-05-13
12:00:00.0" availableToPromiseDiff="5" quantityOnHandDiff="5"/>
    <InventoryItem facilityId="WebStoreWarehouse" locationSeqId="TLTLTLUL04" 
        inventoryItemId="9006" inventoryItemTypeId="NON_SERIAL_INV_ITEM" productId="WG-5569"
ownerPartyId="Company" currencyUomId="USD" unitCost="5.0"  softIdentifier="9006" activationNumber="9006"/>
    <InventoryItemDetail inventoryItemId="9006" inventoryItemDetailSeqId="0001" effectiveDate="2001-05-13
12:00:00.0" availableToPromiseDiff="10" quantityOnHandDiff="10"/>

    <InventoryItem facilityId="WebStoreWarehouse" inventoryItemId="9010" inventoryItemTypeId="NON_SERIAL_INV_ITEM"
productId="WG-9943-B3" ownerPartyId="Company" currencyUomId="USD" unitCost="3.5"  softIdentifier="9010"
activationNumber="9010"/>
    <InventoryItemDetail inventoryItemId="9010" inventoryItemDetailSeqId="0001" effectiveDate="2001-05-13
12:00:00.0" availableToPromiseDiff="10" quantityOnHandDiff="10"/>
    <InventoryItem facilityId="WebStoreWarehouse" inventoryItemId="9011" inventoryItemTypeId="NON_SERIAL_INV_ITEM"
productId="WG-9943-B4" ownerPartyId="Company" currencyUomId="USD" unitCost="3.5"  softIdentifier="9011"
activationNumber="9011"/>
    <InventoryItemDetail inventoryItemId="9011" inventoryItemDetailSeqId="0001" effectiveDate="2001-05-13
12:00:00.0" availableToPromiseDiff="10" quantityOnHandDiff="10"/>
    <InventoryItem facilityId="WebStoreWarehouse" inventoryItemId="9012" inventoryItemTypeId="NON_SERIAL_INV_ITEM"
productId="WG-9943-S3" ownerPartyId="Company" currencyUomId="USD" unitCost="3.5"  softIdentifier="9012"
activationNumber="9012"/>
    <InventoryItemDetail inventoryItemId="9012" inventoryItemDetailSeqId="0001" effectiveDate="2001-05-13
12:00:00.0" availableToPromiseDiff="10" quantityOnHandDiff="10"/>
    <InventoryItem facilityId="WebStoreWarehouse" inventoryItemId="9013" inventoryItemTypeId="NON_SERIAL_INV_ITEM"
productId="WG-9943-S4" ownerPartyId="Company" currencyUomId="USD" unitCost="3.5"  softIdentifier="9013"
activationNumber="9013"/>
    <InventoryItemDetail inventoryItemId="9013" inventoryItemDetailSeqId="0001" effectiveDate="2001-05-13
12:00:00.0" availableToPromiseDiff="10" quantityOnHandDiff="10"/>

    <InventoryItem facilityId="WebStoreWarehouse" inventoryItemId="9021" inventoryItemTypeId="NON_SERIAL_INV_ITEM"
productId="GZ-1006-1" ownerPartyId="Company" currencyUomId="USD" unitCost="2.4"  softIdentifier="9021"
activationNumber="9021"/>
    <InventoryItemDetail inventoryItemId="9021" inventoryItemDetailSeqId="0001" effectiveDate="2001-05-13
12:00:00.0" availableToPromiseDiff="8" quantityOnHandDiff="8"/>
    <InventoryItem facilityId="WebStoreWarehouse" inventoryItemId="9022" inventoryItemTypeId="NON_SERIAL_INV_ITEM"
productId="GZ-1006-2" ownerPartyId="Company" currencyUomId="USD" unitCost="2.4"  softIdentifier="9022"
activationNumber="9022"/>
    <InventoryItemDetail inventoryItemId="9022" inventoryItemDetailSeqId="0001" effectiveDate="2001-05-13
12:00:00.0" availableToPromiseDiff="8" quantityOnHandDiff="8"/>
    <InventoryItem facilityId="WebStoreWarehouse" inventoryItemId="9023" inventoryItemTypeId="NON_SERIAL_INV_ITEM"
productId="GZ-1006-3" ownerPartyId="Company" currencyUomId="USD" unitCost="2.4"  softIdentifier="9023"
activationNumber="9023"/>
    <InventoryItemDetail inventoryItemId="9023" inventoryItemDetailSeqId="0001" effectiveDate="2001-05-13
12:00:00.0" availableToPromiseDiff="8" quantityOnHandDiff="8"/>
    <InventoryItem facilityId="WebStoreWarehouse" inventoryItemId="9024" inventoryItemTypeId="NON_SERIAL_INV_ITEM"
productId="GZ-1006-4" ownerPartyId="Company" currencyUomId="USD" unitCost="2.4"  softIdentifier="9024"
activationNumber="9024"/>
    <InventoryItemDetail inventoryItemId="9024" inventoryItemDetailSeqId="0001" effectiveDate="2001-05-13
12:00:00.0" availableToPromiseDiff="8" quantityOnHandDiff="8"/>

4. good luck, if there is any problem please let me know.

> let the ofbiz work with db2
> ---------------------------
>
>                 Key: OFBIZ-1607
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-1607
>             Project: OFBiz
>          Issue Type: New Feature
>          Components: framework
>    Affects Versions: Trunk
>         Environment: db2 v9.1.0.356
>            Reporter: WeizhanGuo
>            Assignee: Jacques Le Roux
>             Fix For: 16.11.01
>
>         Attachments: contentForm.diff, entityFordb2.diff
>
>   Original Estimate: 40m
>  Remaining Estimate: 40m
>
> create the db2filedtype file ; 
> change the seed/demo data to fixed the db2 requirement;
> change some relation define if needed;
> others



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message