You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by "Hemant.Kamatgi" <He...@target.com> on 2007/10/30 14:50:25 UTC

infinite loop in the method 'moveToNextResultsIfPresent'

Hi,

I'm trying to call a stored procedure in Oracle. It's a fairly simple stored procedure.

Our Map file has the following details:

            <parameterMap id="trailerSeqParamMap" class="map">
                        <parameter property="trlr_scac_c_in" jdbcType="VARCHAR" javaType="java.lang.String"   mode="IN"/>
                        <parameter property="trlr_i_in" jdbcType="VARCHAR" javaType="java.lang.String"  mode="IN"/>
                         <parameter property="trlr_seq_i_out" jdbcType="NUMBER" javaType="java.lang.Double" mode="OUT"/>
                        <parameter property=" user_id_in" jdbcType="VARCHAR" javaType="java.lang.String"  mode="IN"/>
                        <parameter property="  client_type_in" jdbcType="VARCHAR" javaType="java.lang.String"  mode="IN"/>
            </parameterMap>

            <procedure id=" getTrailerSeqSP " parameterMap="trailerSeqParamMap" >
                        {call tsimn3.T511008(?,?,?,?,?)}
            </procedure>

Our Java file:
public Trailer getTrailerSeq(Trailer trailer, User user)
{
HashMap params = new HashMap();
params.put("trlr_scac_c_in",trailer.getScacCode());
params.put("trlr_i_in",trailer.getTrailerID());
params.put("user_id_in",user.getUserId());
params.put("client_type_in",user.getClientType());
try
{
            List obj = this.queryForObject("getTrailerSeqSP",params);
            System.out.println("*********OUTPUT****"+params);

}
catch (Exception exception)
{
            this.processException(exception);
            //handleException(exception, false);
}
return trailer;
}



However, upon debugging, we see that we are entering an infinite loop in the method 'moveToNextResultsIfPresent' of SqlExecutor.java file.We are using 2.3.0.677 version of iBATIS.
Is there a solution to this problem or are we doing anything wrong?

Regards
Hemant