ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jeff Butler" <jeffgbut...@gmail.com>
Subject Re: Weird IN OUT Param problem.
Date Wed, 30 Jan 2008 21:38:59 GMT
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 <
Sundar.Sankaranarayanan@phoenix.edu> 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 .
>

Mime
View raw message