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: insert null value for int type
Date Tue, 08 Jul 2008 14:04:31 GMT
Try #field:INTEGER# instead.

Larry


On Tue, Jul 8, 2008 at 7:28 AM, mimy17 <ninny12@hotmail.com> wrote:
>
> Hi,
>
> I try to insert a null value in a integer field, but I have an exception:
>
> com.ibatis.common.jdbc.exception.NestedSQLException:
> --- The error occurred in ratio.xml
> --- The error occurred while applying a parameter map.
> --- Check the insertRatio-InlineParameterMap.
> --- Check the parameter mapping for the 'amount' property.
> --- Cause: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for
> JDBC]The specified SQL type is not supported by this driver.
> Caused by: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for
> JDBC]The specified SQL type is not supported by this driver.
>
> This is my insert:
>
>        <insert id="insertRatio" parameterClass="...">
>                INSERT INTO ##temp
>                (id, ft, amount, gp)
>                VALUES(#id#, #ft#, #amount#, #gp#)
>        </insert>
>
> When "amount" and "gp" are different than "null", it works well.
>
> Does someone have any ideas?
> --
> View this message in context: http://www.nabble.com/insert-null-value-for-int-type-tp18339264p18339264.html
> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
>
>

Mime
View raw message