[ofbiz-framework] branch trunk updated: Improved: Demo Data in conflict with Entity Unique Index when loading data during creation (OFBIZ-11998)

[jl...@apache.org]

This is an automated email from the ASF dual-hosted git repository.

jleroux pushed a commit to branch trunk
in repository https://gitbox.apache.org/repos/asf/ofbiz-framework.git


The following commit(s) were added to refs/heads/trunk by this push:
     new 231f97f  Improved: Demo Data in conflict with Entity Unique Index when loading data during creation (OFBIZ-11998)
231f97f is described below

commit 231f97f030ad14b04542f6214ef48a8b74b551b4
Author: Jacques Le Roux <ja...@les7arts.com>
AuthorDate: Wed Sep 16 09:09:06 2020 +0200

    Improved: Demo Data in conflict with Entity Unique Index when loading data during creation (OFBIZ-11998)
    
    This is a known issue with MsSQL since
    http://ofbiz.135035.n4.nabble.com/Unique-constraint-on-Person-cardId-breaks-ofbiz-on-SQL-Server-td4656840.html
    The problem does not exist with Derby, nor with the mostly open source DBMS
    used with OFBiz: Postres, MySQL, MariaDB, etc.
    So we will not change the current OOTB setting and suggest to simply change
    your own configuration
    
    Thanks: Schumann Ye for report
---
 framework/entity/config/entityengine.xml | 4 ++++
 1 file changed, 4 insertions(+)

diff --git a/framework/entity/config/entityengine.xml b/framework/entity/config/entityengine.xml
index 8e4301c..1dd11c1 100644
--- a/framework/entity/config/entityengine.xml
+++ b/framework/entity/config/entityengine.xml
@@ -722,6 +722,10 @@ access. For a detailed description see the core/docs/entityconfig.html file.
       http://forum.java.sun.com/thread.jspa?forumID=48&threadID=184797
      b. If using an old version of the driver, beware of this resource leak:
       http://support.microsoft.com/kb/820773/
+     c. Demo data are in conflict with Entity Unique Index when loading data
+      This is a known issue with MsSQL since http://ofbiz.135035.n4.nabble.com/Unique-constraint-on-Person-cardId-breaks-ofbiz-on-SQL-Server-td4656840.html
+      The problem does not exist with Derby, nor with the mostly open source DBMS used with OFBiz: Postres, MySQL, MariaDB, etc.
+      So we will not change the current OOTB setting and suggest to simply change your own configuration. See OFBIZ-11998 for more.
     -->
     <datasource name="localmssql"
             helper-class="org.apache.ofbiz.entity.datasource.GenericHelperDAO"