0 Replies Latest reply on Jun 30, 2006 9:02 AM by Kirill Mikhailov

    Entity - how dynamically change mapped table database schema

    Kirill Mikhailov Newbie

      I have an Oracle database with multiplies oracle schemas. Every oracle schema represent a project. All projects contain tables with same structure but have different data.
      Now we're using ejb2.1 bmp entity beans to represent a data.
      every finder method have a "project" parameter to modify sql:
      "select ... from " +project+".table ..."

      Could anyone tell me how to achive the same result using CMP EJB3?
      That is how to dynamically change database schema while calling find() and other methods...

      Thanx!