how to set the relation

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

how to set the relation

puranisank
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