Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-9563

When using the non-default schema in PostgreSQL performing the action ofBizDelegator.bulkUpdateByPrimaryKey(...) will cause an error

XMLWordPrintable

      When performing the following method call:

      ofBizDelegator.bulkUpdateByPrimaryKey(...)

      The following SQL exception is thrown:

      UPDATE propertystring SET  propertyvalue = ?  WHERE  id = ?  (ERROR: relation "propertystring" does not exist)
      

      When using a non-default schema in postgres, OfBiz is not appending the schema name to the above update. The SQL should look something like

      UPDATE schema_name.propertystring SET  propertyvalue = ?  WHERE  id = ?  (ERROR: relation "propertystring" does not exist)
      

      This is reproducable by running the UpgradeTask_Build150 with an older data import. Also note the entityengine.xml does have a reference to the schema-name attribute. Note this error may also occur in DB2.

              justin@atlassian.com Justin Koke
              justin@atlassian.com Justin Koke
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Created:
                Updated:
                Resolved: