Error in finding view-entity

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

Error in finding view-entity

su2
Hello Friends,

I am trying to call a java class from Form widget.

----------------------------Form Widget-------------------------------------------------
<display description="${bsh:com.opensourcestrategies.financials.reports.ReportHelper.getOrderSubTotal(delegator, OTCMOrderNo)}"/>

-------------------------------------------------

my Java class

-------------------------------------------------

 public static String getOrderSubTotal(GenericDelegator delegator, String OTCMOrderNo) {
        List subTotalObject = null;
       
        EntityExpr condition = new EntityExpr("OTCMOrderNo", EntityOperator.EQUALS,OTCMOrderNo);
       
        try {
                 
        subTotalObject = delegator.findByCondition("OrderAndTaxByCounty", condition, null, null);
       
        } catch (GenericEntityException e) {
            Debug.logError(e, "Error finding OrderAndTaxByCounty in getPartyName", module);
        }
       
        String subTotal = String.valueOf(subTotalObject);
        return subTotal;
       
    }
-------------------------------------------------

I am getting "Null" in return. And Getting following error in my log file.
-------------------------------------------------------------------------
Error finding OrderAndTaxByCounty in getPartyName
Exception: org.ofbiz.entity.transaction.GenericTransactionException
Message: The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Failure in findByPrimaryKey operation for entity [OrderAndTaxByCounty]: org.ofbiz.entity.GenericModelException: [GenericDelegator.findByPrimaryKey] Passed primary key is not a valid primary key: [GenericEntity:OrderAndTaxByCounty][OTCMOrderNo,ORD143486(java.lang.String)]. Rolling back transaction.org.ofbiz.entity.GenericModelException: [GenericDelegator.findByPrimaryKey] Passed primary key is not a valid primary key: [GenericEntity:OrderAndTaxByCounty][OTCMOrderNo,ORD143486(java.lang.String)] ([GenericDelegator.findByPrimaryKey] Passed primary key is not a valid primary key: [GenericEntity:OrderAndTaxByCounty][OTCMOrderNo,ORD143486(java.lang.String)])
-------------------------------------------------------------------------

OTCMOrderNo is one my primary key (there are total 5 primary keys) in view-entity.

Does anybody has idea whats wrong with my code?

I also dont know why the error is pointing to findByPrimaryKey as I have used findByCondition with the delgator in my java class.

I really appreciate the help.

Thank you in advance.
Su-