Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 71646 invoked from network); 30 Oct 2007 13:51:22 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 30 Oct 2007 13:51:22 -0000 Received: (qmail 97729 invoked by uid 500); 30 Oct 2007 13:51:07 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 97714 invoked by uid 500); 30 Oct 2007 13:51:07 -0000 Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user-java@ibatis.apache.org Delivered-To: mailing list user-java@ibatis.apache.org Received: (qmail 97701 invoked by uid 99); 30 Oct 2007 13:51:07 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 30 Oct 2007 06:51:07 -0700 X-ASF-Spam-Status: No, hits=-0.8 required=10.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_MED,SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (nike.apache.org: 161.225.129.126 is neither permitted nor denied by domain of Hemant.Kamatgi@target.com) Received: from [161.225.129.126] (HELO smtpout01.target.com) (161.225.129.126) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 30 Oct 2007 13:51:21 +0000 Received: from emailhub11.email.target.com ([10.116.210.35]) by smtpout01.target.com with ESMTP; 30 Oct 2007 08:37:37 -0500 Received: from EMAILMBX10.email.target.com ([10.116.180.156]) by emailhub11.email.target.com ([10.116.210.35]) with mapi; Tue, 30 Oct 2007 08:50:30 -0500 From: Hemant.Kamatgi To: "user-java@ibatis.apache.org" Date: Tue, 30 Oct 2007 08:50:25 -0500 Subject: infinite loop in the method 'moveToNextResultsIfPresent' Thread-Topic: infinite loop in the method 'moveToNextResultsIfPresent' Thread-Index: Acga+9L2rhdHLGCoRIu6Em74KXiFvQ== Message-ID: <07292702F07DB64BB8224048499C79190245396A89@EMAILMBX10.email.target.com> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: acceptlanguage: en-US Content-Type: multipart/alternative; boundary="_000_07292702F07DB64BB8224048499C79190245396A89EMAILMBX10ema_" MIME-Version: 1.0 X-Virus-Checked: Checked by ClamAV on apache.org --_000_07292702F07DB64BB8224048499C79190245396A89EMAILMBX10ema_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi, I'm trying to call a stored procedure in Oracle. It's a fairly simple store= d procedure. Our Map file has the following details: {call tsimn3.T511008(?,?,?,?,?)} Our Java file: public Trailer getTrailerSeq(Trailer trailer, User user) { HashMap params =3D 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 =3D 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 th= e 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 --_000_07292702F07DB64BB8224048499C79190245396A89EMAILMBX10ema_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi,

 

I’m trying to call a stored procedure in Oracle. I= t’s a fairly simple stored procedure.

 

Our Map file has the following details:

 

         &n= bsp;  <parameterMap id=3D"trailerSeqParamMap" class=3D"map"><= /span>

         &n= bsp;              <parameter property=3D"trlr_scac_c_in" jdbcType=3D"VARCHAR" javaType=3D"java.lang.String"   mode=3D"IN"/&= gt;

         &n= bsp;              <parameter property=3D"trlr_i_in" jdbcType=3D"VARCHAR" javaType=3D"java.lang.String"  mode=3D"IN"/>

         &n= bsp;               <parameter property=3D"trlr_seq_i_out" jdbcType=3D"NUMBER" javaType=3D"java.lang.Double" mode=3D"OUT"/>

         &n= bsp;              <parameter property=3D" user_id_in" jdbcType=3D"VARCHAR" javaType=3D"java.lang.String"  mode=3D"IN"/>

         &n= bsp;              <parameter property=3D"  client_type_in" jdbcType=3D"VARCHAR" javaType=3D"java.lang.String"  mode=3D"IN"/>

          &= nbsp; </parameterMap>

 

          &= nbsp; <procedure id=3D" getTrailerSeqSP " parameterMap=3D"trailerSeqParamMap" >=

          &= nbsp;           &nbs= p; {call tsimn3.T511008(?,?,?,?,?)}

         &n= bsp;  </procedure>

 

Our Java file:

public Trailer getTrailerSeq(Trailer trailer, User user)=

{

HashMap params =3D new HashMap= ();

params.put("trlr_scac_c_i= n",trailer.getScacCode());

params.put("trlr_i_in&quo= t;,trailer.getTrailerID());

params.put("user_id_in&qu= ot;,user.getUserId());

params.put("client_type_i= n",user.getClientType());

try

{

     =        List obj =3D this.queryForObject("getTrailerSeqSP",params);=

     =        System.out.println("*********OUTP= UT****"+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.<= /span>

Is there a solution to this problem or are we doing anyt= hing wrong?

 

Regards

Hemant

 

 

 

 

 

--_000_07292702F07DB64BB8224048499C79190245396A89EMAILMBX10ema_--