ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Larry Meadors" <larry.mead...@gmail.com>
Subject Re: IBatis on Spring:: error when calling SP. the SP returns cursor
Date Fri, 27 Jun 2008 13:26:56 GMT
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.
>
>

Mime
View raw message