0 Replies Latest reply on Jan 16, 2012 4:04 AM by Andrey Victor

    MSSQL procedure with select (as cursor) and Ibatis -> problem

    Andrey Victor Newbie

      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