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. > >
