-
Bug
-
Resolution: Fixed
-
Medium
-
3.5.3
-
PostgreSQL 8.0
-
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.