How to use UPDATE statement and set value to NULL

[Mike Needham]

I am trying to figure out how to set a cache value to a NULL.  The update
is coming through and I am doing the following:

            String sql =
                        "UPDATE MAIN.EXCHANGE" +
                        "   SET LEGACYXRID = ?" +
                        "      ,EXCHANGENAME = ?" +
                        "      ,EXCHANGEMIC = ?" +
                        "      ,EXCHANGEOPERATINGMIC = ?" +
                        " WHERE EXCHANGEXRID = ?;";
//            Object x = map.get("ExchangeXRID");
            testCache.query(new
SqlFieldsQuery(sql).setArgs(LegacyIDNode.asLong(),ExchNameNode.asText(),ExchMicNode.asText(),ExchOperatingMicNode.asText(),ExIDNode.asLong()));

The update succeeds but I am getting the word null instead of a NULL value
the cache.  What is the best way to pass the NULL in the update?


-- 
*Don't be afraid to be wrong. Don't be afraid to admit you don't have all
the answers. Don't be afraid to say "I think" instead of "I know."*