ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From mimy17 <ninn...@hotmail.com>
Subject Re: insert null value for int type
Date Wed, 09 Jul 2008 12:28:56 GMT

I'm running ibatis 2.0
 

Clinton Begin wrote:
> 
> 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.
>>
>>
> 
> 

-- 
View this message in context: http://www.nabble.com/insert-null-value-for-int-type-tp18339264p18359981.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.


Mime
View raw message