Javelin - Exclude Internal Hidden Columns in Oracle 11.2.0.4

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

 

We have run into an issue with the EqualizeSchema javelin flow with a client that is on Oracle 11.2.0.4.  This is related to CA case # 00967701 where we needed the exclusion of Virtual and Hidden columns.  That change only excludes hidden columns when the Oracle version is > 12.  This was because Oracle didn't support users to create hidden columns until this version.  Based on my investigation and this client it appears internally hidden columns were supported prior to Oracle 12.  I believe we need the oracle version check removed from this check and always exclude hidden and virtual columns.  I have attached our version of EqualizeSchema as a reference.

Environment

Release : 4.9

Component : CA Test Data Manager - Javelin

Resolution

Engineering reviewed the EqualizeSchema flow, and added an additional connection parameter to the Oracle connection. The additional parameter they added is 'EnableTransaction="{x:Null}"'.