Call a statement from resultMap->result iBatis

Posted by Vinay on Stack Overflow See other posts from Stack Overflow or by Vinay
Published on 2010-04-23T11:34:03Z Indexed on 2010/04/23 11:43 UTC
Read the original article Hit count: 224

Filed under:

ibatis

Hi All,

Please tell me is it correct configuration in given below. If there are mistake please reply.





select * from PAYMENT where ORDER_ID = #ordId# and CUST_ID = #ordCustId#

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.

Related posts about ibatis

Getting output parameter(SYS_REFCURSOR) from Oracle stored procedure in iBATIS 3(by using annotation

as seen on Stack Overflow - Search for 'Stack Overflow'
I got an example how to call oracle SP in iBATIS 3 without a map file. And now I understand how to call it. But I got another problem that how to get a result from output parameter(Oracle cursor). A part of exception messages is "There is no setter for property named 'rs' in 'class java.lang.Class"… >>> More
How to get a result from output parameter(SYS_REFCURSOR) of Oracle stored procedure in iBATIS 3(by u

as seen on Stack Overflow - Search for 'Stack Overflow'
I got an example how to call oracle SP in iBATIS 3 without a map file. And now I understand how to call it. But I got another problem that how to get a result from output parameter(Oracle cursor). A part of exception messages is "There is no setter for property named 'rs' in 'class java.lang.Class"… >>> More
Oracle XMLDB's XMLCAST and XMLQUERY incompatible with iBatis?

as seen on Stack Overflow - Search for 'Stack Overflow'
I've been trying to select a list of values from XMLs stored in an XMLType column but I keep getting the errors which are listed at the tail end of this post. The select id is getXMLFragment , and the relevant subset of the sqlmap.xml is as follows: <select id="getXMLFragment" resultClass="list"> … >>> More
Getting stored procedure's return value with iBatis.NET

as seen on Stack Overflow - Search for 'Stack Overflow'
How can I retrieve the return value of a stored procedure using iBatis.NET? The below code successfully calls the stored procedure, but the QueryForObject<int> call returns 0. SqlMap <procedure id="MyProc" parameterMap="MyProcParameters" resultClass="int"> MyProc </procedure> <parameterMap… >>> More
Mapping parent-child relationships with iBatis

as seen on Stack Overflow - Search for 'Stack Overflow'
I have the classic setup public class Parent { Integer id; ... // No generics Collection someCollectionAttribute; ... public void setChildren(Collection c) { ... } } public class Child { Integer id; ... } and I'm trying to map this on the usual table… >>> More

Developer IT