ibatis-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From prabu p <prabu...@gmail.com>
Subject Need help on calling stored procedure from ibatis
Date Thu, 10 Jun 2010 16:49:03 GMT

                As I am new to ibatis, I need your help on calling stored
procedure from ibatis.

Here is the code I am trying to call stored procedure, but it is not
working.

Stored procedure as follows:-

getRadiusData( rc  OUT SYS_REFCURSOR,ArgFromDate in varchar2,ArgEndDate in
varchar2,
rptType VARCHAR2,timeRange VARCHAR2, authStatus  VARCHAR2,userName
VARCHAR2,identityGroup VARCHAR2 ,
netwokDeviceGroup  VARCHAR2 ,netwokDevicename  VARCHAR2 ,accessService 
VARCHAR2 ,identityStore  VARCHAR2 ,
acsInstance  VARCHAR2,Failure_Reason  VARCHAR2,Calling_Station_ID 
VARCHAR2,Device_IP_Address  VARCHAR2,
Audit_Session_ID VARCHAR2,ACS_Session_ID VARCHAR2, Acct_Session_ID
VARCHAR2,isMab VARCHAR2,adDomain VARCHAR2,
CTS_Security_Group VARCHAR2,  Show_SGT_Assign VARCHAR2, Show_SGT_Environment
VARCHAR2,ID number ,
isDrillDown number)

XDEQueriesMap.xml file has entry as follows:-

    <procedure id="getRadiusData" parameterClass="java.util.HashMap"
resultClass="java.util.HashMap">
          {call getRadiusData(?, #FromDate#, #ToDate#,
#AuthenticationStatus#, #TimeRange#, 'All', #UserName#, 'All', 'All', 'All',
'All', 'All', 'All', #FailureReason#,
#CallStationID#, #DeviceIP#, #AuditSessionID#, 'All', 'All', 'All', 'All',
'All', 'All','All','1', '0')}
    </procedure>

>From java file I am calling the procedure getRadiusData as follows:- 

                                hashMap.put(QUERY_USERNAME, userName);
                                hashMap.put(CALL_STATION_ID, stationID);
                                hashMap.put(QUERY_AUDIT_SESSION_ID,
auditSessionID);                          
                                hashMap.put(DEVICE_IP, deviceIP);
                                hashMap.put(QUERY_NAS_PORT, nasPort);
                                hashMap.put(AUTHEN_STATUS, authStatus);
                                hashMap.put(QUERY_FAILURE_REASON,
failureReason);
                                hashMap.put(FROM_DATE, fromDate);
                                hashMap.put(TO_DATE, toDate);
                                hashMap.put(TIME_RANGE, timeRange); 
                                hashMap.put(TOP_N, topNRecords);

List<HashMap> list = xdeDAO.callContentSearch("getRadiusData", hashMap);



In the procedure we are using “SYS_REFCURSOR”. I am not sure how to pass
parameter for “SYS_REFCURSOR” to the stored procedure from ibatis.

-- 
View this message in context: http://old.nabble.com/Need-help-on-calling-stored-procedure-from-ibatis-tp28845673p28845673.html
Sent from the iBATIS - Dev mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@ibatis.apache.org
For additional commands, e-mail: dev-help@ibatis.apache.org


Mime
View raw message