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