ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brandon Goodin <brandon.goo...@gmail.com>
Subject Re: Stored procedures not working?
Date Sat, 28 May 2005 22:36:31 GMT
Did you execute it against the database using straight JDBC with the
JayBird JDBC Driver?   Also, did you examine your logging output? If
you have done both of these things...please post your logging output
here for us to examine.

Brandon

On 5/28/05, Michael Glitzner <michael.glitzner@inode.at> wrote:
>  
>  
> 
> 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 
> 
>   
> 
>   
> 
>   
> 
>
Mime
View raw message