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