1 Reply Latest reply on Jun 30, 2006 9:19 AM by Kirill Mikhailov

    How to map entity bean on dynamicly created names of table?

    Michal Skrdla Newbie

      Hi,
      I'm using legacy database schema where is one table (e.g. laboratory) and for each laboratory exists one table (e.g. [laboratory_shortcut]_order) with same structure.

      example:
      table laboratory
      id - shortcut - description
      1 - bio - biochemistry
      2 - hem - hematology

      and there are two tables bio_order and hem_order. These tables have same structure.
      I wish make one entity (Order) that could be mapped sometimes on first table (bio_order) and sometimes on second table (hem_order).

      I know that this db schema is terrible but I must use it :(
      Thx for advice