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