Stored procedures not working?

[Michael Glitzner]

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