Stored procedures not working?

Hello!

 

I am having a problem with stored procedures in iBatis. I use the FireBird (JayBird) JDBC driver connecting to an InterBase-Server.

 

My SqLMap.xml file looks the following:

 

<sqlMap>

      <select id="validateUser" parameterClass="ebet.User" resultClass="java.lang.Integer">

            SELECT COUNT(*) FROM WEB_KUNDEN WHERE username=#userName# AND passwort=#password#

      </select>

 

      <resultMap id="mainSportsResult" class="ebet.MainSport" >

            <result property="caption" column="HSPBEZ"/>

            <result property="code" column="HSPART"/>

            <result property="sorter" column="P_SORTKZ"/>

      </resultMap>

 

      <procedure id="selectMainSports" resultMap="mainSportsResult" parameterClass="ebet.SystemConfig">

            {call WEB_HSPORTART(#language#, #company#, 0, #betMode#)}

      </procedure>

</sqlMap>

 

In general iBatis is working in my application for simple queries, so this could be no database or application problem I think. But when I try to execute the procedure:

 

List dataList=session.queryForList("selectMainSports",app.getSystemConfig());

 

-> I only get 1 DataSet back in the List object – but when executed

-> directly on the db (using the same parameters like in my application)

-> I get around 6 DataSets - how could this be??

 

Am I doing anything wrong in my SqlMap?? I really have no idea anymore and it would be a pleasure to read any of your suggestions ...

 

Thanks and greetings, Michael