Is there a better way for dealing with null attributes?
Currently I have to do something like..
<insert id="insertA">
insert into A (
id
<isNotNull prepend="," property="name">
name
</isNotNull>
) values (
#id#
<isNotNull prepend="," property="name">
#name#
</isNotNull>
)
</insert>or
<insert id="insertA">
insert into A (
id,
name
) values (
#id#
<isNotNull prepend="," property="name">
#name#
</isNotNull>
<isNull prepend="," property="name">
null
</isNotNull>
)
</insert>This become very tedious when you have 10+ columns that might be null. Why does this happen with Oracle? Is there anyway that iBatis could check if the property was null and if so call the setNull() of a prepared statement? I am sure that I am over simplifying the process but just thought I would throw it out there.
Nathan

