Hi All,
Please tell me is it correct configuration in given below. If there are mistake please reply.
<resultMap class="beans.Payment" id="paymentResult">
<select id="getOrderPayments" resultMap="paymentResult">
select * from PAYMENT where ORDER_ID = #ordId# and CUST_ID = #ordCustId#
<select id="getOrders" resultMap="orderResult" parameterClass="int">
select * from PRODORDER where ord_id = #value#
I am getting exceptions -
com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in conf/sql-map.xml.
--- The error occurred while applying a result map.
--- Check the employee.orderResult.
--- Check the result mapping for the 'payments' property.
--- Cause: com.ibatis.sqlmap.client.SqlMapException: There is no statement named getOrderPayments in this SqlMap.