tags:

views:

264

answers:

0

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.