ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From anand khati <anandkhati2...@yahoo.com>
Subject Stored procedure problem in execution
Date Tue, 13 Mar 2007 15:11:36 GMT
Hi,

I'm need of great help from you...
will be very grateful to you....

Problem:
following is the list of entries in my
<sqlMap namespace="Users">


<resultMap id="result"
class="com.flipl.bmantra.model.Users">

<result property="userID" column="user_id"
columnIndex="1"/>

<result property="userName" column="user_name"
columnIndex="2"/>

</resultMap> 


<parameterMap id="getUsers" class="map">

<parameter property="java.lang.Integer" mode="IN"/>

<parameter property="java.lang.Integer" mode="IN"/> 

</parameterMap>


<procedure id="getAllUsers" parameterMap="getUsers"
parameterClass="java.lang.Integer" resultMap="result">

{call bmantra.prc_get_users(?,?)}

</procedure>


</sqlMap>



Moreover, my bmantra.prc_get_users(?,?) SQL stored
procedure is taking two params i.e. both int arguments

and following is my java code in which i'm trying to
pass these two params to execute this stored
procedure:

public List getUsersList()throws DataAccessException{


List listUsers = null;

Map map = new HashMap();

map.put("first", new Integer(1));

map.put("second", new Integer(5));


try {


int update =
sqlMapClientTemplate.update("getAllUsers", map); 


listUsers =
sqlMapClientTemplate.queryForList("getAllUsers", 1,
5);


} catch (Exception e) {

System.out.println("*********EXCEPTION INSIDE
getUsersList()**************");

e.printStackTrace();

} 


return listUsers;

}


I would be really grateful,  for any valubale inputs
regarding this...


Thanks in Advance!

Regards,
Anand Khati


 
____________________________________________________________________________________
We won't tell. Get more on shows you hate to love 
(and love to hate): Yahoo! TV's Guilty Pleasures list.
http://tv.yahoo.com/collections/265 

Mime
View raw message