The integer values stored as NULL in backing store is returned as 0 (zero)

The integer values stored as NULL in backing store is returned as 0 (zero)

book

Article ID: KB0089490

calendar_today

Updated On:

Products Versions
TIBCO BusinessEvents Enterprise Edition -
Not Applicable -

Description

Resolution:
Description:
==========
The integer values stored as NULL in backing store is returned as 0. Do we have any solution to get the NULL integer concept property as NULL?

Environment:
==========
TIBCO BusinessEvent 3.0.2
SQL Server 2008

Symptoms:
=========
  Concept Tree has attribute leaves as integer.
  
  -  Set the leaves with NULL value (leave this value empty when creating the concept in the xslt mapper)
  - Print the leaves' value with tree.leaves. It will be 0 .
  - Check the leaves value from the database. The value will be NULL .
  
The NULL integer value is converted to 0 when extracting with tree.leaves.

Cause:
======
This is an expected behavior as the integer value cannot be NULL. The value of the NULL concept integer property will be extracted as 0.

Resolution:
=========  
The 'isSet' flag could help to determine if the 0 integer property is NULL.  
  
Each property has an 'isSet' flag. If an object is loading from backing store, this flag is set accordingly based on if the value is NULL or not in the db.

When isSet is false, it means the value is NULL.
  
The isSet flag is accessd as following:
    tree.leaves@isSet

Issue/Introduction

The integer values stored as NULL in backing store is returned as 0 (zero)