I am new to accessing stored procs as such. I don't know how I would do it
JDBC. I had an example with Springs jdbcTemplate where my jdbcType was
ARRAY. But no matter what I give the type as(ARRAY, OBJECT, CURSOR) ibatis
was throwing me an UncatergorizedSQLException or a NullPointer exception and
asked me to check the mapping for the property. I had tried having a
resultMap too mapping, an object where each of the columns where mapped to
properties. I also made sure in the unit test that none of the properties
were Null.
Still I am getting this error.
My Mapping file is something like this
<parameterMap id="saveOrUpdateCoursesParam" class="map">
<parameter property="p_property" jdbcType="OTHER" javaType="
com.model.modelClass"
mode="IN"/>
<parameter property="p_prop2" jdbcType="NUMBER"
javaType="java.lang.Long" mode="IN" />
</parameterMap>
<procedure id="proc"
parameterMap="procParam">
{call
theProc(?,?)}
</procedure>
<resultMap
class="com.model.modelClass"
id="transcriptActivity">
<result
.
.
.
.
.
</resultMap>
I have tried changing the parameterMap to various formats where the jdbcType
have been all that I have mentioned and have also tried including the
resultMap as as the map below. In my unit test, I set in values to all the
properties explicitly, leaving nothing null.
Regards
Sundar Sankarnarayanan
On Jan 10, 2008 9:04 AM, Larry Meadors <[EMAIL PROTECTED]> wrote:
> How would you do it with JDBC?
>
> Larry
>
>
> On Jan 10, 2008 9:00 AM, Sundar Sankar <[EMAIL PROTECTED]> wrote:
> > Hi,
> > I have a stored procedure that takes rowtype, an instance of a
> table,
> > in my database. How do you create the mapping for such kind of case.
> Does
> > Ibatis support this?
> >
> > Regards
> > Sundar Sankarnarayanan
> >
>
