I am getting a preparation falied "UndeclaredThrowableException" when I
call:

return (Integer) executeQueryForObject("getTaxable", item);

The SQL Map is:

  <select id="getTaxable" parameterClass="item"
resultClass="java.lang.Integer">
    SELECT count(1) as value FROM ecrs_v_InventoryMaster, ecrs_TaxMain,
ecrs_StockInventoryLinkTax WHERE ecrs_v_InventoryMaster.INV_PK =
ecrs_StockInventoryLinkTax.ILT_INV_FK AND ecrs_v_InventoryMaster.INV_CPK =
ecrs_StockInventoryLinkTax.ILT_INV_CFK AND
ecrs_StockInventoryLinkTax.ILT_TAX_FK = ecrs_TaxMain.TAX_PK AND
ecrs_v_InventoryMaster.INV_ScanCode = #upc:CHAR#
  </select>

What am I doing wrong?

Thanks,

Warren Bell


Reply via email to