[IBATIS-610] how to use parameterMap in ibatis

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Invalid
• Component/s: Core
• Environment: Windows 2003; JDK1.6; Tomcat 5.5
• Assignee: Unassigned
• Reporter: mona
• Created: 18/Jun/09 09:26
• Updated: 18/Jun/09 14:59
• Resolved: 18/Jun/09 14:59

Description

Dear All,

I am using ibatis and i want to call function in ibatis but the problem is here when i pass two parameter IN and Out together in to my mysql function it throws exception like:-

Exception in callFunction of GenerateXMLFromProc Classcom.ibatis.common.jdbc.exception.NestedSQLException:
— The error occurred in com/wil/web/ibatis/sql/testQry.xml.
— The error occurred while applying a parameter map.
— Check the qry.genOuput.
— Check the parameter mapping for the 'param' property.
— Cause: java.sql.SQLException: Parameter index out of range (2 > number of parameters, which is 1).

when i use individually IN and OUT parameter in diffrent mysql function it works, so tell me how to use both IN and OUT parameter in function calling through ibatis.

My developed mysql function perfectly work when i run it from mysql, so i don't understand where is the problem?

can any one help me out it's urgent for me.
_________________
Thanks