Environment
NetIQ Identity Manager
Novell Identity Manager 4.0
Novell Identity Manager 3.6.1
Novell Identity Manager Driver - JDBC
Situation
How do I submit an event to my RDB via the JDBC driver which will be interpreted as a an empty string as opposed to a null?
Resolution
You can use XSLT. This is the base document:
<modify-attr attr-name="firstname">
<remove-all-values/>
<add-value>
<value type="string"/>
</add-value>
</modify-attr>
</modify>
XSLT:
<modify-attr attr-name="firstname">
<remove-all-values/>
<add-value>
<value type="string"/>
</add-value>
</modify-attr>
</modify>
XSLT:
<value type="string"/> to <value type="string"></value>. (This is the XSLT code that does it)
<xsl:template match="value[not(node())]">
<value type="string">
<xsl:text disable-output-escaping="yes"/>
</value>
</xsl:template>
<xsl:template match="value[not(node())]">
<value type="string">
<xsl:text disable-output-escaping="yes"/>
</value>
</xsl:template>