Ticket #169 (new defect)

Opened 7 months ago

Duplicate fields are created in the generated record files for Oracle

Reported by: not_a_spammer Owned by: dhughes
Type: defect Priority: highest
Milestone: Component: Reactor - Record
Version: Severity: blocker
Keywords: Cc:

Description

Duplicates fields may be created in the record files (at least when using oracle) if another schema has a table with the same name.

The ObjectDAO.readFields method for oracle uses the all_tab_columns, all_updatable_columns, all_cons_columns, and all_constraints data dictionaries. These return global information, not limited to the current schema/user. Either the owner field must be taken into account, or (better yet) use the user_ version of the table. (ie user_tab_collumns, user_constraints). The second option has the bonus of being faster during development.

Note: See TracTickets for help on using tickets.