Make sure you are specifying the jdbcType of the out/inout parameters in
your parameter map.
Jeff Butler
On Jan 30, 2008 3:37 PM, Sundar Sankaranarayanan <
[EMAIL PROTECTED]> wrote:
> Hi All,
> I have a stored procedure, which is something like this.
>
> call example(?,?,?,?,?,?)
>
> The first four params are IN params and the last 2 are out params. If I
> set the mode="OUT" or set the mode as "INOUT" in the sql-map xml file I get
> a
>
>
>
> --- Cause: *java.sql.SQLException*
> : Invalid column type; nested exception is *
> com.ibatis.common.jdbc.exception.NestedSQLException*:
>
> --- The error occurred in
> ibatis/config/procedures/example.xml.
>
>
> --- The error occurred while executing query procedure.
>
> --- Check the {call example(?,?,?,?,?,?)}
>
> --- Check the output parameters (register output
> parameters failed).
>
> * --- Cause: **java.sql.SQLException**: Invalid column type
> *
>
> at
> org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(
> *SQLStateSQLExceptionTranslator.java:121*)
>
> at
> org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate
> (*SQLErrorCodeSQLExceptionTranslator.java:322*)
>
> at
> org.springframework.orm.ibatis.SqlMapClientTemplate.execute(*
> SqlMapClientTemplate.java:197*)
>
> at
> org.springframework.orm.ibatis.SqlMapClientTemplate.executeWithListResult(
> *SqlMapClientTemplate.java:220*)
>
> at
> org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(*
> SqlMapClientTemplate.java:267*)
>
> at
> com.apollo.sisaw.entry.dao.implementation.IbatisTranscriptActivityDaoImpl.insertTranscriptActivity
> (*IbatisTranscriptActivityDaoImpl.java:408*)
>
> at
> com.apollo.sisaw.entry.dao.implementation.IbatisTranscriptActivityDaoImplTest.testInsertTranscriptActivity
> (*IbatisTranscriptActivityDaoImplTest.java:197*)
>
> at sun.reflect.NativeMethodAccessorImpl.invoke0(*Native
> Method*)
> .
> The procedure does run fine if I change the mode to "IN" but the values
> that I expect to be set into the input map I provide is being set as null. I
> dont know what has to be done. I am using Spring with Ibatis together and
> have an oracle database. Any help on this is appreciated.
>
>
> Thanks and Regards
> Sundar .
>
