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