CA Plex - Unable to save Boolean database value using Winc/Java variant

Products

• CA Plex

Issue/Introduction

When attempting to save database to a table that has a Boolean data type, receive the following error:

ERROR: column "send_pager_msg" is of type boolean but expression is of type integer

Environment

CA Plex

Resolution

CA Plex does not support Boolean data type out of the box.

This requires complete support of new datatype to make it work consistently across Java and all other variants.

The problem lies while binding happens between the CA Plex data type and the data coming from the database side.

To support Boolean data type, will need to add a new data type support within Plex.

CA Plex Engineering created an internal backlog item for this request to be considered in upcoming CA Plex release planning.