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

XMLWordPrintable

    • 3.05

      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.

            Assignee:
            Justin Koke
            Reporter:
            Justin Koke
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: