ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From puneet arya <puneet_arya_...@yahoo.co.in>
Subject output problem
Date Fri, 23 Jun 2006 05:05:22 GMT
Hi,
     i have made stored procedure in oracle and try to run the output in the store procedure
through IBATIS. The problem is i am having two output parameters and i want to execute it
in the IBATIS 
  I am calling my procedure as 
  <parameterMap id="inputNewRegisterMap" class="newRegisterMap" >
  <parameter property="StartDate" jdbcType="VARCHAR2" javaType="java.lang.String" mode="IN"/>
  <parameter property="EndDate" jdbcType="VARCHAR2" javaType="java.lang.String" mode="IN"/>
  <parameter property="lvocode" jdbcType="VARCHAR2" mode="IN"/>
  <parameter property="outputnewRegister" jdbcType="ORACLECURSOR" mode = "OUT" resultMap
= "spNewRegister" />
  <parameter property="outputResults" jdbcType="VARCHAR2" mode = "OUT" resultMap = "spNewRegister"
/>
  </parameterMap> 
  
  <procedure id="getNewRegistrationList" parameterMap="inputNewRegisterMap" resultMap =
"spNewRegister">
  { call SP_NEWREGISTRATION(?, ?, ?, ?, ?) }
  </procedure>
   
  but while implementing it in dao i think i am not able to implement it properly
   
  i am defining like
   public NewRegistrations[] getNewRegistrationList(ReportRequest reportRequest)
  {
         NewRegistrations[] newRegistrations = null;
   try
   
   {
     daoManager.startTransaction();
     Map newRegisterMap = new HashMap();
     newRegisterMap.put("StartDate",reportRequest.getFrmDate());
     newRegisterMap.put("EndDate",reportRequest.getToDate());
     newRegisterMap.put("lvocode",reportRequest.getLvoCodes());
     queryForObject("getNewRegistrationList",newRegisterMap);
     ArrayList lstnewRegister = (ArrayList) newRegisterMap.get("outputnewRegister");
          lstnewRegister = (ArrayList) newRegisterMap.get("outputResults");
        
     if(null != lstnewRegister)
     {
      newRegistrations = new NewRegistrations[lstnewRegister.size()];
     }
    
     for (int index=0; index < lstnewRegister.size(); index++)
     {
      newRegistrations[index] = (NewRegistrations) lstnewRegister.get(index);
     }
   }
   finally
   {
     daoManager.endTransaction();
   }
   return newRegistrations;
   
  , i want to define the second  output parameter as i have bold it.plz suggest
                                                                             Regards,
                                                                            Puneet Arya

 				
---------------------------------
 Yahoo! India Answers: Share what you know. Learn something new Click here
Catch all the FIFA World Cup 2006 action on Yahoo! India Click here
Mime
View raw message