-
Type:
Bug
-
Resolution: Fixed
-
Priority:
Medium
-
Affects Version/s: 3.5.3
-
Component/s: Infrastructure & Services - Application Lifecycle
-
Environment:
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.