Previous Topic: Java and C# Exec SQL Action Diagram Source CodeNext Topic: Java Source Code When Upgrading from CA Plex r5.5


Java and Oracle varchar null support

Java applications that target the Oracle database and use optional varchar fields may behave differently after upgrading from r5.5 or earlier. Depending on how the varchar is modeled in Plex, unexpected optimistic locking errors may occur after upgrade. For example:

"Instance of .... changed by another user"

The typical solution is to add FLD null VAL triples to the varchar field where the target value is empty. For more information, search the CA Support Online web site for problem CPLEX 1296.