JDBC Driver sending NULL instead of an empty string

  • 7011311
  • 05-Nov-2012
  • 05-Nov-2012


NetIQ Identity Manager
Novell Identity Manager 4.0
Novell Identity Manager 3.6.1
Novell Identity Manager Driver - JDBC


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?


You can use XSLT. This is the base document:

<modify-attr attr-name="firstname">
<value type="string"/>

<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"/>