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.
