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 Tue, 08 Jul 2008 14:23:38 GMT

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