ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Clinton Begin" <clinton.be...@gmail.com>
Subject Re: insert null value for int type
Date Tue, 08 Jul 2008 14:26:28 GMT
That's weird, I'm sure the type alias registry is case insensitive.

Which version of iBATIS are you running?

Clinton

On Tue, Jul 8, 2008 at 8:23 AM, mimy17 <ninny12@hotmail.com> wrote:

>
> I had tried #field:integer# and it didn't work, but in uppercase it does. I
> lost my time for nothing, but I shall not have thought of it.
>
> Thanks Larry
>
>
>
> Larry Meadors wrote:
> >
> > 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.
> >>
> >>
> >
> >
>
> --
> View this message in context:
> http://www.nabble.com/insert-null-value-for-int-type-tp18339264p18340432.html
> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
>
>

Mime
View raw message