If what you are saying is you want to pass null value to ibatis, try
substituting the null value with "" in the insert statement.
#email:jdbcType:null value to substitue# On the null value to use part,
use "". iBatis will automatically substitute null values with empty string.
Should work. From documentation, under In-line parameter maps.
http://ibatis.apache.org/docs/java/pdf/iBATIS-SqlMaps-2_en.pdf
Härtel wrote:
Hello list,
I want to insert null for a String/VARCHAR property. Posting http://www.mail-archive.com/[email protected]/msg05079.html tells if my String is null default is null is inserted in the table. But it works not this way here.
I got the following error message:
--- The error occurred while applying a parameter map.
--- Check the insertApplication-InlineParameterMap.
--- Check the parameter mapping for the 'email' property.
--- Cause: java.lang.NullPointerException
The insert mapping:
<insert id="insertApplication"
parameterClass="de.dtrust.tk.ebxml.database.Application">
INSERT INTO application ( degree, firstname, name_prefix, name_affix, lastname,
address_1, address_2, address_3, address_4, email)
VALUES ( #degree#, #firstname#, #namePrefix#, #nameAffix#, #lastname#,
#address_1#, #address_2#, #address_3#, #address_4#, #email# )
</insert>
If I put an empty String("") for the email it works. But with null would be
more comfortable.
Any suggestions?
Gretings Eric
