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.

