[jira] Created: (OFBIZ-1607) let the ofbiz work with db2
Locked
12
12
[jira] Created: (OFBIZ-1607) let the ofbiz work with db2
 
|
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: SVN trunk Environment: db2 v9.1.0.356 Reporter: WeizhanGuo Fix For: SVN trunk create the db2filedtype file ; change the seed/demo data to fixed the db2 requirement; change some relation define if needed; others -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Commented: (OFBIZ-1607) let the ofbiz work with db2
|
|
[ https://issues.apache.org/jira/browse/OFBIZ-1607?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12563815#action_12563815 ] WeizhanGuo commented on OFBIZ-1607: ----------------------------------- please read this first: http://docs.ofbiz.org/display/OFBIZ/Entity+Engine+DB2+Express-C+integration > 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: SVN trunk > Environment: db2 v9.1.0.356 > Reporter: WeizhanGuo > Fix For: SVN trunk > > Original Estimate: 0.67h > Remaining Estimate: 0.67h > > create the db2filedtype file ; > change the seed/demo data to fixed the db2 requirement; > change some relation define if needed; > others -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Updated: (OFBIZ-1607) let the ofbiz work with db2
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1607?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] WeizhanGuo updated OFBIZ-1607: ------------------------------ Attachment: fieldtypedb2.xml the fieldType file > 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: SVN trunk > Environment: db2 v9.1.0.356 > Reporter: WeizhanGuo > Fix For: SVN trunk > > Attachments: fieldtypedb2.xml > > Original Estimate: 0.67h > Remaining Estimate: 0.67h > > create the db2filedtype file ; > change the seed/demo data to fixed the db2 requirement; > change some relation define if needed; > others -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Issue Comment Edited: (OFBIZ-1607) let the ofbiz work with db2
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1607?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12563815#action_12563815 ] jack_guo edited comment on OFBIZ-1607 at 1/30/08 9:28 PM: ------------------------------------------------------------ please read this first: http://docs.ofbiz.org/display/OFBIZ/Entity+Engine+DB2+Express-C+integration it mentions two bugs in this article , the first one can fixed by lookup of primary keys by each table which the DatabaseUtil has been done. the second is the DB2 jdbc can not support the scrollable resultset with lob datatype,so, I changed the way of pull the data in selectListIteratorByCondition method of GenericDao class , here is the code : private static String DB2PullLobDataWithScrollableErrorCode = "DB2 SQL Error: SQLCODE=-270, SQLSTATE=42997"; .... .... try{ sqlP.executeQuery(); }catch(GenericDataSourceException gse){ //if thrown db2 error with DB2 SQL Error: SQLCODE=-270, SQLSTATE=42997 //try to pull the data again in unscrollable way if(gse.getMessage().toLowerCase().indexOf(DB2PullLobDataWithScrollableErrorCode.toLowerCase())>-1){ sqlP.prepareStatement(sql); if (verboseOn) { // put this inside an if statement so that we don't have to generate the string when not used... Debug.logVerbose("Setting the whereEntityConditionParams: " + whereEntityConditionParams, module); } // set all of the values from the Where EntityCondition for (EntityConditionParam whereEntityConditionParam: whereEntityConditionParams) { SqlJdbcUtil.setValue(sqlP, whereEntityConditionParam.getModelField(), modelEntity.getEntityName(), whereEntityConditionParam.getFieldValue(), modelFieldTypeReader); } if (verboseOn) { // put this inside an if statement so that we don't have to generate the string when not used... Debug.logVerbose("Setting the havingEntityConditionParams: " + havingEntityConditionParams, module); } // set all of the values from the Having EntityCondition for (EntityConditionParam havingEntityConditionParam: havingEntityConditionParams) { SqlJdbcUtil.setValue(sqlP, havingEntityConditionParam.getModelField(), modelEntity.getEntityName(), havingEntityConditionParam.getFieldValue(), modelFieldTypeReader); } sqlP.executeQuery(); } else throw gse; } .... I think it's a way to fix this problem if there is not a better db2 jdbc driver, please tell me if you have a better way to solve this problem, thanks. was (Author: jack_guo): please read this first: http://docs.ofbiz.org/display/OFBIZ/Entity+Engine+DB2+Express-C+integration > 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: SVN trunk > Environment: db2 v9.1.0.356 > Reporter: WeizhanGuo > Fix For: SVN trunk > > Attachments: fieldtypedb2.xml > > Original Estimate: 0.67h > Remaining Estimate: 0.67h > > create the db2filedtype file ; > change the seed/demo data to fixed the db2 requirement; > change some relation define if needed; > others -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Commented: (OFBIZ-1607) let the ofbiz work with db2
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1607?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12564306#action_12564306 ] WeizhanGuo commented on OFBIZ-1607: ----------------------------------- 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 better way 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: SVN trunk > Environment: db2 v9.1.0.356 > Reporter: WeizhanGuo > Fix For: SVN trunk > > Attachments: fieldtypedb2.xml > > Original Estimate: 0.67h > Remaining Estimate: 0.67h > > create the db2filedtype file ; > change the seed/demo data to fixed the db2 requirement; > change some relation define if needed; > others -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Issue Comment Edited: (OFBIZ-1607) let the ofbiz work with db2
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1607?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12564306#action_12564306 ] jack_guo edited comment on OFBIZ-1607 at 1/30/08 9:43 PM: ------------------------------------------------------------ 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. 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 better way 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: SVN trunk > Environment: db2 v9.1.0.356 > Reporter: WeizhanGuo > Fix For: SVN trunk > > Attachments: fieldtypedb2.xml > > Original Estimate: 0.67h > Remaining Estimate: 0.67h > > create the db2filedtype file ; > change the seed/demo data to fixed the db2 requirement; > change some relation define if needed; > others -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Issue Comment Edited: (OFBIZ-1607) let the ofbiz work with db2
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1607?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12563815#action_12563815 ] jack_guo edited comment on OFBIZ-1607 at 2/2/08 12:29 AM: ------------------------------------------------------------ please read this first: http://docs.ofbiz.org/display/OFBIZ/Entity+Engine+DB2+Express-C+integration it mentions two bugs in this article , the first one can fixed by lookup of primary keys by each table which the DatabaseUtil has been done(the db2 v9.5 has been solved this problem). the second is the DB2 jdbc can not support the scrollable resultset with lob datatype, i think there is no good way to fix this problem if there is not a better db2 jdbc driver, the EntityListIterator need a scrollable resultset, please tell me if you have a better way to solve this problem, thanks. was (Author: jack_guo): please read this first: http://docs.ofbiz.org/display/OFBIZ/Entity+Engine+DB2+Express-C+integration it mentions two bugs in this article , the first one can fixed by lookup of primary keys by each table which the DatabaseUtil has been done. the second is the DB2 jdbc can not support the scrollable resultset with lob datatype,so, I changed the way of pull the data in selectListIteratorByCondition method of GenericDao class , here is the code : private static String DB2PullLobDataWithScrollableErrorCode = "DB2 SQL Error: SQLCODE=-270, SQLSTATE=42997"; .... .... try{ sqlP.executeQuery(); }catch(GenericDataSourceException gse){ //if thrown db2 error with DB2 SQL Error: SQLCODE=-270, SQLSTATE=42997 //try to pull the data again in unscrollable way if(gse.getMessage().toLowerCase().indexOf(DB2PullLobDataWithScrollableErrorCode.toLowerCase())>-1){ sqlP.prepareStatement(sql); if (verboseOn) { // put this inside an if statement so that we don't have to generate the string when not used... Debug.logVerbose("Setting the whereEntityConditionParams: " + whereEntityConditionParams, module); } // set all of the values from the Where EntityCondition for (EntityConditionParam whereEntityConditionParam: whereEntityConditionParams) { SqlJdbcUtil.setValue(sqlP, whereEntityConditionParam.getModelField(), modelEntity.getEntityName(), whereEntityConditionParam.getFieldValue(), modelFieldTypeReader); } if (verboseOn) { // put this inside an if statement so that we don't have to generate the string when not used... Debug.logVerbose("Setting the havingEntityConditionParams: " + havingEntityConditionParams, module); } // set all of the values from the Having EntityCondition for (EntityConditionParam havingEntityConditionParam: havingEntityConditionParams) { SqlJdbcUtil.setValue(sqlP, havingEntityConditionParam.getModelField(), modelEntity.getEntityName(), havingEntityConditionParam.getFieldValue(), modelFieldTypeReader); } sqlP.executeQuery(); } else throw gse; } .... I think it's a way to fix this problem if there is not a better db2 jdbc driver, please tell me if you have a better way to solve this problem, thanks. > 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: SVN trunk > Environment: db2 v9.1.0.356 > Reporter: WeizhanGuo > Fix For: SVN trunk > > Attachments: fieldtypedb2.xml > > Original Estimate: 0.67h > Remaining Estimate: 0.67h > > create the db2filedtype file ; > change the seed/demo data to fixed the db2 requirement; > change some relation define if needed; > others -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Commented: (OFBIZ-1607) let the ofbiz work with db2
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1607?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12565201#action_12565201 ] BJ Freeman commented on OFBIZ-1607: ----------------------------------- it is easier to read and submit, what has changed if you submit this as a patch. > 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: SVN trunk > Environment: db2 v9.1.0.356 > Reporter: WeizhanGuo > Fix For: SVN trunk > > Attachments: fieldtypedb2.xml > > Original Estimate: 0.67h > Remaining Estimate: 0.67h > > create the db2filedtype file ; > change the seed/demo data to fixed the db2 requirement; > change some relation define if needed; > others -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Commented: (OFBIZ-1607) let the ofbiz work with db2
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1607?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12569778#action_12569778 ] WeizhanGuo commented on OFBIZ-1607: ----------------------------------- I am not clear what your mean, but I submit this jira to make the ofbiz can support the DB2 out of box, what the changed? you can see the comment above. > 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: SVN trunk > Environment: db2 v9.1.0.356 > Reporter: WeizhanGuo > Fix For: SVN trunk > > Attachments: fieldtypedb2.xml > > Original Estimate: 0.67h > Remaining Estimate: 0.67h > > create the db2filedtype file ; > change the seed/demo data to fixed the db2 requirement; > change some relation define if needed; > others -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Assigned: (OFBIZ-1607) let the ofbiz work with db2
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1607?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jacques Le Roux reassigned OFBIZ-1607: -------------------------------------- Assignee: Jacques Le Roux > 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: SVN trunk > Environment: db2 v9.1.0.356 > Reporter: WeizhanGuo > Assignee: Jacques Le Roux > Fix For: SVN trunk > > Attachments: fieldtypedb2.xml > > Original Estimate: 0.67h > Remaining Estimate: 0.67h > > create the db2filedtype file ; > change the seed/demo data to fixed the db2 requirement; > change some relation define if needed; > others -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Commented: (OFBIZ-1607) let the ofbiz work with db2
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1607?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12569841#action_12569841 ] Jacques Le Roux commented on OFBIZ-1607: ---------------------------------------- Hi Could you send a patch against you entityengine.xml file ? To make a patch : http://docs.ofbiz.org/display/OFBADMIN/OFBiz+Contributors+Best+Practices Else send only your <datasource name="db2".... </datasource> block Thanks > 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: SVN trunk > Environment: db2 v9.1.0.356 > Reporter: WeizhanGuo > Assignee: Jacques Le Roux > Fix For: SVN trunk > > Attachments: fieldtypedb2.xml > > Original Estimate: 0.67h > Remaining Estimate: 0.67h > > create the db2filedtype file ; > change the seed/demo data to fixed the db2 requirement; > change some relation define if needed; > others -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Updated: (OFBIZ-1607) let the ofbiz work with db2
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1607?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] WeizhanGuo updated OFBIZ-1607: ------------------------------ Attachment: entityengine.diff the current problem is the db2 don't support pull the clob data with cursor and the EntityListIterator work with cursored DB results, I try to create another class work like the EntityListIterator and don't need the cursored DB results. > 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: SVN trunk > Environment: db2 v9.1.0.356 > Reporter: WeizhanGuo > Assignee: Jacques Le Roux > Fix For: SVN trunk > > Attachments: entityengine.diff, fieldtypedb2.xml > > Original Estimate: 0.67h > Remaining Estimate: 0.67h > > create the db2filedtype file ; > change the seed/demo data to fixed the db2 requirement; > change some relation define if needed; > others -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Commented: (OFBIZ-1607) let the ofbiz work with db2
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1607?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12570136#action_12570136 ] Jacques Le Roux commented on OFBIZ-1607: ---------------------------------------- Guo, So do I wait for your work on this before commiting ? > 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: SVN trunk > Environment: db2 v9.1.0.356 > Reporter: WeizhanGuo > Assignee: Jacques Le Roux > Fix For: SVN trunk > > Attachments: entityengine.diff, fieldtypedb2.xml > > Original Estimate: 0.67h > Remaining Estimate: 0.67h > > create the db2filedtype file ; > change the seed/demo data to fixed the db2 requirement; > change some relation define if needed; > others -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Commented: (OFBIZ-1607) let the ofbiz work with db2
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1607?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12570144#action_12570144 ] WeizhanGuo commented on OFBIZ-1607: ----------------------------------- Have you done this before? if haven't I think it's better to wait couple of days, I'm trying to fix this problem, you can fix other issue in those days :) And I will let you know the result. > 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: SVN trunk > Environment: db2 v9.1.0.356 > Reporter: WeizhanGuo > Assignee: Jacques Le Roux > Fix For: SVN trunk > > Attachments: entityengine.diff, fieldtypedb2.xml > > Original Estimate: 0.67h > Remaining Estimate: 0.67h > > create the db2filedtype file ; > change the seed/demo data to fixed the db2 requirement; > change some relation define if needed; > others -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Updated: (OFBIZ-1607) let the ofbiz work with db2
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1607?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] WeizhanGuo updated OFBIZ-1607: ------------------------------ Attachment: (was: fieldtypedb2.xml) > 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: SVN trunk > Environment: db2 v9.1.0.356 > Reporter: WeizhanGuo > Assignee: Jacques Le Roux > Fix For: SVN trunk > > Original Estimate: 0.67h > Remaining Estimate: 0.67h > > create the db2filedtype file ; > change the seed/demo data to fixed the db2 requirement; > change some relation define if needed; > others -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Updated: (OFBIZ-1607) let the ofbiz work with db2
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1607?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] WeizhanGuo updated OFBIZ-1607: ------------------------------ Attachment: (was: entityengine.diff) > 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: SVN trunk > Environment: db2 v9.1.0.356 > Reporter: WeizhanGuo > Assignee: Jacques Le Roux > Fix For: SVN trunk > > Original Estimate: 0.67h > Remaining Estimate: 0.67h > > create the db2filedtype file ; > change the seed/demo data to fixed the db2 requirement; > change some relation define if needed; > others -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Updated: (OFBIZ-1607) let the ofbiz work with db2
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1607?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] WeizhanGuo updated OFBIZ-1607: ------------------------------ Attachment: (was: entityengine.diff) > 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: SVN trunk > Environment: db2 v9.1.0.356 > Reporter: WeizhanGuo > Assignee: Jacques Le Roux > Fix For: SVN trunk > > Attachments: entityFordb2.diff > > Original Estimate: 0.67h > Remaining Estimate: 0.67h > > create the db2filedtype file ; > change the seed/demo data to fixed the db2 requirement; > change some relation define if needed; > others -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Updated: (OFBIZ-1607) let the ofbiz work with db2
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1607?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] WeizhanGuo updated OFBIZ-1607: ------------------------------ Attachment: entityFordb2.diff > 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: SVN trunk > Environment: db2 v9.1.0.356 > Reporter: WeizhanGuo > Assignee: Jacques Le Roux > Fix For: SVN trunk > > Attachments: entityFordb2.diff > > Original Estimate: 0.67h > Remaining Estimate: 0.67h > > create the db2filedtype file ; > change the seed/demo data to fixed the db2 requirement; > change some relation define if needed; > others -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Updated: (OFBIZ-1607) let the ofbiz work with db2
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1607?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] WeizhanGuo updated OFBIZ-1607: ------------------------------ Attachment: entityengine.diff > 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: SVN trunk > Environment: db2 v9.1.0.356 > Reporter: WeizhanGuo > Assignee: Jacques Le Roux > Fix For: SVN trunk > > Attachments: entityFordb2.diff > > Original Estimate: 0.67h > Remaining Estimate: 0.67h > > create the db2filedtype file ; > change the seed/demo data to fixed the db2 requirement; > change some relation define if needed; > others -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Updated: (OFBIZ-1607) let the ofbiz work with db2
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1607?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] WeizhanGuo updated OFBIZ-1607: ------------------------------ Attachment: contentForm.diff > 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: SVN trunk > Environment: db2 v9.1.0.356 > Reporter: WeizhanGuo > Assignee: Jacques Le Roux > Fix For: SVN trunk > > Attachments: contentForm.diff, entityFordb2.diff > > Original Estimate: 0.67h > Remaining Estimate: 0.67h > > create the db2filedtype file ; > change the seed/demo data to fixed the db2 requirement; > change some relation define if needed; > others -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
«
Return to OFBiz - Dev
|
1 view|%1 views
| Free forum by Nabble | Edit this page |