You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Purani S <pu...@rediffmail.com> on 2006/09/15 15:09:15 UTC
how to set the relation

Hi,
I store the categoryId in the table "Product_Category_Assoc".
I try to get the value of the category name using the categoryId from the table "Product_Category_Assoc" using the following syntax. 
<#assign curCategoryAssoc = productCategoryAssoc.getRelatedOneCache("ProductCategory")>

But I get the following error :

Method public org.ofbiz.entity.GenericValue org.ofbiz.entity.GenericValue.getRelatedOneCache(java.lang.String) throws org.ofbiz.entity.GenericEntityException threw an exception when invoked on [GenericEntity:ProductCategoryAssoc][createdStamp,2006-09-15 07:03:13.0(java.sql.Timestamp)][createdTxStamp,2006-09-15 07:03:13.0(java.sql.Timestamp)][lastUpdatedStamp,2006-09-15 07:03:13.0(java.sql.Timestamp)][lastUpdatedTxStamp,2006-09-15 07:03:13.0(java.sql.Timestamp)][prodCatalogId,Coordinate Catalog(java.lang.String)][productCategoryId,0100245(java.lang.String)][productId,101965(java.lang.String)] The problematic instruction: ---------- ==> assignment: curCategoryAssoc=productCategoryAssoc.getRelatedOneCache("ProductCategory") [on line 114, column 17 in EditProductCategoryAssoc.ftl] ---------- Java backtrace for programmers: ---------- freemarker.template.TemplateModelException: Method public org.ofbiz.entity.GenericValue org.ofbiz.entity.GenericValue.getRelatedOneCache(java.lang.String) throws org.ofbiz.entity.GenericEntityException threw an exception when invoked on [GenericEntity:ProductCategoryAssoc][createdStamp,2006-09-15 07:03:13.0(java.sql.Timestamp)][createdTxStamp,2006-09-15 07:03:13.0(java.sql.Timestamp)][lastUpdatedStamp,2006-09-15 07:03:13.0(java.sql.Timestamp)][lastUpdatedTxStamp,2006-09-15 07:03:13.0(java.sql.Timestamp)][prodCatalogId,Coordinate Catalog(java.lang.String)][productCategoryId,0100245(java.lang.String)][productId,101965(java.lang.String)] at freemarker.ext.beans.SimpleMethodModel.exec(SimpleMethodModel.java:136) at freemarker.core.MethodCall._getAsTemplateModel(MethodCall.java:93) at freemarker.core.Expression 

Could I please get some hint on this.

Thanks
Purani