ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Amit Jagtap <amit.jag...@gmail.com>
Subject Re: IBatis on Spring:: error when calling SP. the SP returns cursor
Date Fri, 27 Jun 2008 15:22:31 GMT

Thanks for the reply Larry!

Yes it is indeed a driver issue. I replaced my oracle 9X driver with a 10X 
one according to my db version and it solved the problem.

Cheers,
Amit



Larry Meadors wrote:
> 
> This looks like an Oracle error...have you tried to reproduce this
> with a simpler scenario (i.e., a simple JDBC call)?
> 
> Larry
> 
> 
> On Fri, Jun 27, 2008 at 12:59 AM, amutap <amit.jagtap@gmail.com> wrote:
>>
>> Hi guys,
>>
>> I have a stored procedure that returns a cursor. my Sp has only this
>> single
>> OUT param.
>>
>> following is my sqlmapping:
>>        <resultMap id="notifications" class="lenderNtfnDTO">
>>        <result property="lenderId" column="LNDR_OID"/>
>>        <result property="lenderNotificationTypeId"
>> column="LNDR_NTFN_TMPL_CD"/>
>>        <result property="lenderQASIdentifier" column="LNDR_QAS_IND"/>
>>        </resultMap>
>>        <parameterMap id="notificationsParameterMap" class="map">
>>                <parameter property="CO_LNDR_NTFN"
>> javaType="java.sql.ResultSet"
>> jdbcType="ORACLECURSOR" mode="OUT" resultMap="notifications" />
>>        </parameterMap>
>>        <procedure id="getNotificationsByLender"
>> parameterMap="notificationsParameterMap" >
>>                {call pkg_ntfn.p_get_ntfn_by_lndr(?)}
>>        </procedure>
>>
>> here, the procedure out param (cursor) name is "CO_LNDR_NTFN".
>>
>> I call it using following -
>>           HashMap map = new HashMap();
>>           map.put("CO_LNDR_NTFN", null);
>>
>>           sqlMapClientTemplate.queryForObject("getNotifications", map);
>>
>>           notificationList = (ArrayList)map.get("CO_LNDR_NTFN");
>>
>> I receive following error -
>>
>> --- The error occurred in com/.../sqlmap/SendNotificationMap.xml.
>> --- The error occurred while applying a parameter map.
>> --- Check the SendNotification.notificationsParameterMap.
>> --- Check the statement (update procedure failed).
>> --- Cause: java.sql.SQLException: Bigger type length than Maximum; nested
>> exception is com.ibatis.common.jdbc.exception.NestedSQLException:
>> --- The error occurred in com/.../sqlmap/SendNotificationMap.xml.
>> --- The error occurred while applying a parameter map.
>> --- Check the SendNotification.notificationsParameterMap.
>> --- Check the statement (update procedure failed).
>> --- Cause: java.sql.SQLException: Bigger type length than Maximum
>>
>> I do not understand the issue is with the way I am handling the resultset
>> or
>> something is wrong with the procedure!
>>
>> my iBatis version is 2.3.0.677 and Spring version is 1.2.7
>>
>> looking forward for a reply..
>>
>> Thanks,
>> Amit
>>
>> --
>> View this message in context:
>> http://www.nabble.com/IBatis-on-Spring%3A%3A-error-when-calling-SP.-the-SP-returns-cursor-tp18149219p18149219.html
>> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
>>
>>
> 
> 

-- 
View this message in context: http://www.nabble.com/IBatis-on-Spring%3A%3A-error-when-calling-SP.-the-SP-returns-cursor-tp18149219p18157539.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.


Mime
View raw message