Resolution:
Description:
===========
Collections (array properties) are not being saved in Backingstore as expected (blank records).

Environment:
===========
BE 3.0.2 (backingstore Oracle database, Oracle types)
All Operating Systems

Symptoms:
=========
Collections not saved in Backingstore as expected (blank records). When checked, the database concept array strings will not be inserted into the backingstore correctly (data in the cache are ok).  All records for concept array strings are empty.

To append a new value function Instance.PropertyArray.appendString() is used.

SQL to test the values:
select att."COLUMN_VALUE" from d_&ltconcept>
myConcept,Table(myConcept.entity."&ltattributeValue>")att;

i.e. (concept testcpt, property: arrayValue):
select att."COLUMN_VALUE" from d_testcpt
myConcept,Table(myConcept.entity."arrayValue")att;

Cause:
======
Database NLS_LANG settings

Resolution:
========
The Oracle JDBC library ojdbc14.jar supports only character sets (NLS_LANG)  US7ASCII, WE8DEC, WE8ISO8859P1, WE8MSWIN1252 and UTF8.

When your database uses another character set (ex.: WE8ISO8859P15) you have to add the Oracle library orai18n.jar to the classpath.

Please download that file (orai18n.jar) from the following:

http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc_10201.html and add the fiile to the classpath.