Hellow!

I call stored procedure from IBATIS (Mssql-2008 stored procedure).

create procedure dbo.test_wsdl_select (@ag_our_number varchar(32)) as begin select 'number_agreem: ' + ltrim(rtrim(min(ag_our_number))) as 'ag_number' , ' Ofiice: ' + ltrim(rtrim(min(servicing_office)))as 'office' from agreement where ag_our_number = @ag_our_number end

Query configured like that:

<parameter property="cursor_data" jdbcType="CURSOR" javaType="java.sql.ResultSet" mode="OUT" />

sqlMapConfig like this :

<sqlMap resource="avTestQuery.xml" />

</sqlMapConfig>

When i start this bandle - i see error:

ava.lang.RuntimeException: Error occurred.  Cause: com.ibatis.common.xml.NodeletException: Error parsing XML.  Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.  Cause: com.ibatis.common.xml.NodeletException: Error parsing XML.  Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMap/resultMap'.  Cause: java.lang.RuntimeException: Error configuring Result.  Could not set ResultClass.  Cause: java.lang.ClassNotFoundException: ru.alfastrah.interplat4.avis.types.IdList

?:|I thinck , that problem in:

<parameter property="cursor_data" jdbcType="CURSOR" javaType="java.sql.ResultSet" mode="OUT" />

It is right? And how resolve my problem! Thank  you for our answers!

P.S. Hellow all from Russia;)

Edited by: andrey_7 on Jan 16, 2012 8:31 AM

Edited by: andrey_7 on Jan 16, 2012 9:03 AM