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 <[EMAIL PROTECTED]> 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.
