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