Announcement Announcement Module
No announcement yet.
multiple databases query (with a twist) Page Title Module
Move Remove Collapse
Conversation Detail Module
  • Filter
  • Time
  • Show
Clear All
new posts

  • multiple databases query (with a twist)

    I'm looking at Spring and iBatis as the basis for a new project. My requirements are two fold.

    firstly i need to provide CRUD functionality supporting PL/SQL calls and SQL which i've modelled and understood.

    secondly i need to provide isolated data migration across multiple database instances. for example i'm offering CRUD of a Party bean but I also need to offer copy of Party bean from one database instance to another. Even though I'm dealing with mulitple instances i can get away without JTA because a "write" transaction would only ever exist on one database (read from a and write to b). What I can't clearly realise is the modelling of one Party bean that can exist programatically in n number of instances. (the declaration of DAO explicitly ties it to a data source.)

    My initial modelling consists of a lookUp database instance that holds information of all Party Beans and the environments they exist in.

    All advice would be welcome.